What changes when you pay
The free portal gives you
- A FeatureServer table split across four separate year layers, overwritten as the District edits it
- Applicant, owner and edit-history columns still carrying names
- No dated snapshot to check against
- No delivery -- query the FeatureServer layers yourself
This file gives you
- One CSV of the year slice you name (2026, 2025, 2024, 2023, or all four years together), cut from the 172,942 rows we pulled 26 Aug 2026
- PERMIT_APPLICANT, OWNER_NAME, CREATED_USER and LAST_EDITED_USER already taken out
- A dated pull (26 Aug 2026), sold under CC BY 4.0 with the required credit line already printed on the page
- A person emails you that slice as a CSV within one working day of your reply naming the slice
A real slice of the file, not a mock-up
| DCRAINTERNALNUMBER | ISSUE_DATE | PERMIT_ID | PERMIT_TYPE_NAME | PERMIT_SUBTYPE_NAME | PERMIT_CATEGORY_NAME | APPLICATION_STATUS_NAME | FULL_ADDRESS | SSL | ZONING | FEE_TYPE | FEES_PAID | CITY | STATE | LATITUDE | LONGITUDE | XCOORD | YCOORD | ZIPCODE | MARADDRESSREPOSITORYID | DCSTATADDRESSKEY | DCSTATLOCATIONKEY | WARD | ANC | SMD | DISTRICT | PSA | NEIGHBORHOODCLUSTER | HOTSPOT2006NAME | HOTSPOT2005NAME | HOTSPOT2004NAME | BUSINESSIMPROVEMENTDISTRICT | LASTMODIFIEDDATE | GLOBALID | CREATED_DATE | LAST_EDITED_DATE | OBJECTID | LAYER_YEAR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1684339209.0 | 2023-03-26 | G84339209 | SUPPLEMENTAL | PLUMBING AND GAS | NA | NULL | 124 11TH ST NE, WASHINGTON, DC 20002 | 0965 0060 | RF-1 | 2.60 (PLUMBINGEFEE);26.00 (GASFIREPLACE) | 29 | 38.89113958 | -76.99176597 | 400714.34 | 135921.72 | 70078.0 | 6 | ANC 6A | 6A07 | FIRST | 108 | Cluster 26 | 2026-08-17 | {59DCBB16-1BED-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140402520 | 2023 | |||||||||
| 2587288882.0 | 2023-03-26 | P87288882 | SUPPLEMENTAL | PLUMBING AND GAS | NA | PERMIT ISSUED | 1750 P ST NW, WASHINGTON, DC 20036 | 0157 0113 | 73 | 38.90941699 | -77.04060685 | 396478.07 | 137951.41 | 238156.0 | 2 | ANC 2B | 2B05 | SECOND | 208 | Cluster 6 | 2023-03-28 | {59DCBB16-838A-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140429045 | 2023 | |||||||||||
| 2518631478.0 | 2023-02-13 | P18631478 | SUPPLEMENTAL | PLUMBING AND GAS | NA | COMPLETED | 500 21ST ST NE, WASHINGTON, DC 20002 | 29 | 38.89626862 | -76.97479331 | 402186.64 | 136491.39 | 15630.0 | 7 | ANC 7D | 7D05 | FIFTH | 507 | Cluster 25 | 2024-04-01 | {59DCBB16-919E-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140432649 | 2023 | ||||||||||||
| 141305804.0 | 2023-03-26 | E1305804 | SUPPLEMENTAL | ELECTRICAL | NA | EXPIRED | 2400 EAST CAPITOL ST SE, WASHINGTON, DC 20003 | 1128 0804 | 220.00 (REVISION);22.00 (ELECTRICEFEE);55.00 (INSTALL8) | 319 | 38.8897903063 | -76.9718954058 | 402438.25 | 135772.32 | 293222.0 | 7 | ANC 7D | 7D05 | FIRST | 108 | Cluster 25 | 2026-08-17 | {59DCBB16-9852-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140434365 | 2023 | ||||||||||
| 1459855397.0 | 2023-03-26 | E59855397 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 4604 43RD ST NW, WASHINGTON, DC 20016 | 1649 0051 | 31 | 38.95018176 | -77.08406094 | 392713.36 | 142479.26 | 277434.0 | 3 | ANC 3E | 3E01 | SECOND | 202 | Cluster 11 | 2023-03-31 | {59DCBB16-C71E-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140446345 | 2023 | |||||||||||
| 1412679369.0 | 2023-07-26 | E12679369 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 414 SHEPHERD ST NW, WASHINGTON, DC 20011 | 3237 0057 | 539 | 38.93971989 | -77.01795155 | 398443.68 | 141314.66 | 247909.0 | 4 | ANC 4C | 4C07 | FOURTH | 407 | Cluster 18 | 2023-07-27 | {59DCBB16-E3CE-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140453689 | 2023 | |||||||||||
| 1467433672.0 | 2023-06-13 | E67433672 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 1512 OKIE ST NE, WASHINGTON, DC 20002 | 4037 0010 | 344 | 38.91555376 | -76.9819918 | 401561.76 | 138632.05 | 312676.0 | 5 | ANC 5D | 5D02 | FIFTH | 506 | Cluster 23 | 2023-06-15 | {59DCBB17-74AA-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140490773 | 2023 | |||||||||||
| 1427934306.0 | 2023-03-26 | E27934306 | SUPPLEMENTAL | ELECTRICAL | NA | PERMIT ISSUED | 853 52ND ST NE, WASHINGTON, DC 20019 | 5198 0173 | 136 | 38.90142229 | -76.92545756 | 406465.97 | 137065.79 | 81478.0 | 7 | ANC 7C | 7C06 | SIXTH | 608 | Cluster 31 | 2023-03-28 | {59DCBB17-93B8-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140498723 | 2023 | |||||||||||
| 1660667325.0 | 2023-03-26 | G60667325 | SUPPLEMENTAL | PLUMBING AND GAS | NA | COMPLETED | 901 MASSACHUSETTS AVE NW, WASHINGTON, DC 20001 | 0370 0848 | D-4-R | 26.00 (GASLINETEST);5.20 (PLUMBINGEFEE);26.00 (GASFIREPLACE) | 57 | 38.90367009 | -77.02467863 | 397859.39 | 137313.0 | 239811.0 | 2 | ANC 2G | 2G05 | THIRD | 307 | Cluster 8 | 2026-08-17 | {59DCBB17-CF82-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140514029 | 2023 | |||||||||
| 2824212301239.0 | 2023-04-26 | SOL2301239 | CONSTRUCTION | SOLAR SYSTEM | NA | EXPIRED | 630 BURNS ST SE, WASHINGTON, DC 20019 | 5392 0054 | R-2 | 12.50 (SOLFILEFEE);12.50 (SOLAREFEE);125.00 (SOLRESPV.1);125.00 (SOLFILFEE) | 275 | 38.88091608 | -76.9434381 | 404907.71 | 134788.32 | 2928.0 | 7 | ANC 7E | 7E01 | SIXTH | 605 | Cluster 33 | 2026-08-18 | {59DCBB19-BF52-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140640957 | 2023 | |||||||||
| 142308651.0 | 2023-05-31 | E2308651 | SUPPLEMENTAL | ELECTRICAL | NA | PERMIT ISSUED | 4630 ALABAMA AVE SE, WASHINGTON, DC 20019 | 5390 0122 | R-2 | 20.00 (MISCITEM17);2.00 (ELECTRICEFEE) | 22 | 38.87995194 | -76.93953744 | 405246.23 | 134681.51 | 301910.0 | 7 | ANC 7E | 7E01 | SIXTH | 605 | Cluster 33 | 2026-08-14 | {59DCBB19-BF53-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140640958 | 2023 | |||||||||
| 142402073.0 | 2023-11-28 | E2402073 | SUPPLEMENTAL | ELECTRICAL | NA | PERMIT ISSUED | 725 ADRIAN ST SE, WASHINGTON, DC 20019 | 5391 0032 | R-2 | 79 | 38.88034422 | -76.94474307 | 404794.52 | 134724.77 | 77979.0 | 7 | ANC 7E | 7E01 | SIXTH | 605 | Cluster 33 | 2023-11-29 | {59DCBB19-BF54-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140640959 | 2023 | ||||||||||
| 251234200714.0 | 2023-10-18 | PC34200714 | POST CARD | BUILDING | NA | COMPLETED | 3620 13TH ST NW, WASHINGTON, DC 20010 | 2828 0077 | 33.00 (POSTCARD3);3.30 (BUILDEFEE) | 36 | 38.93530509 | -77.03001398 | 397397.76 | 140824.89 | 230272.0 | 1 | ANC 1A | 1A04 | FOURTH | 408 | Cluster 2 | 2026-08-14 | {59DCBB1A-3BE1-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140672844 | 2023 | ||||||||||
| 141108805.0 | 2023-03-26 | E1108805 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 90 K ST NE, WASHINGTON, DC 20002 | 0674 0853 | C-3-C | 52.00 (ELECTRICEFEE);520.00 (MISCITEM23) | 572 | 38.9028841 | -77.00658771 | 399428.58 | 137225.48 | 289039.0 | 6 | ANC 6E | 6E07 | FIFTH | 501 | Cluster 25 | NoMa BID | 2026-08-18 | {59DCBB1C-3567-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140802258 | 2023 | ||||||||
| 1411602621.0 | 2023-03-26 | E11602621 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 4140 7TH ST NW, WASHINGTON, DC 20011 | 3135 0049 | 399 | 38.94177599 | -77.02189356 | 398101.98 | 141542.98 | 249712.0 | 4 | ANC 4C | 4C06 | FOURTH | 407 | Cluster 18 | 2023-03-31 | {59DCBB1C-3A5B-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140803526 | 2023 |
What is in the file, and what $349 buys172,942 rows pulled 26 Aug 2026
$349 buys ONE of the five slices below, not all 172,942 rows. Washington DC publishes a building-permit table and overwrites it. We pulled 172,942 of those rows on 26 Aug 2026 and assembled them as one CSV, with person-name columns taken out. The five slices for sale are 2026, 2025, 2024, 2023, all four years.
| Permit | Type | Issue date | Address | Status |
|---|---|---|---|---|
| G84339209 | SUPPLEMENTAL | 26 Mar 2023 | 124 11TH ST NE | NULL |
| P87288882 | SUPPLEMENTAL | 26 Mar 2023 | 1750 P ST NW | PERMIT ISSUED |
| P18631478 | SUPPLEMENTAL | 13 Feb 2023 | 500 21ST ST NE | COMPLETED |
| E1305804 | SUPPLEMENTAL | 26 Mar 2023 | 2400 EAST CAPITOL ST SE | EXPIRED |
| E59855397 | SUPPLEMENTAL | 26 Mar 2023 | 4604 43RD ST NW | COMPLETED |
| E12679369 | SUPPLEMENTAL | 26 Jul 2023 | 414 SHEPHERD ST NW | COMPLETED |
| E67433672 | SUPPLEMENTAL | 13 Jun 2023 | 1512 OKIE ST NE | COMPLETED |
| E27934306 | SUPPLEMENTAL | 26 Mar 2023 | 853 52ND ST NE | PERMIT ISSUED |
| G60667325 | SUPPLEMENTAL | 26 Mar 2023 | 901 MASSACHUSETTS AVE NW | COMPLETED |
| SOL2301239 | CONSTRUCTION | 26 Apr 2023 | 630 BURNS ST SE | EXPIRED |
| E2308651 | SUPPLEMENTAL | 31 May 2023 | 4630 ALABAMA AVE SE | PERMIT ISSUED |
| E2402073 | SUPPLEMENTAL | 28 Nov 2023 | 725 ADRIAN ST SE | PERMIT ISSUED |
Data retrieved from Open Data DC catalog (https://opendata.dc.gov)
Licence: Creative Commons Attribution 4.0 International (CC BY 4.0).
Person columns stripped (PERMIT_APPLICANT, OWNER_NAME, CREATED_USER, LAST_EDITED_USER). DESC_OF_WORK removed. Rows assembled into dated slices by USTechAutomations.
The underlying District data itself stays CC BY 4.0 in the buyer's hands. We charge for assembly and delivery, not for rights to the data. The District's free portal remains at opendata.dc.gov.
172,942 is what we hold, not what the city has ever published. A row we did not pull is not in the file you buy. The portal itself stays free.
Person columns are stripped. The outbound name guard refuses a paid file whose header names a person or a way to reach one. Those columns stay in the city's portal and stay out of what we sell.
The city's own types in this extract5 values
These are the city's words, not ours. A type with no page of its own is still in the extract and still in the coverage page.
| City's permit type | Rows in this extract |
|---|---|
| SUPPLEMENTAL | 91,251 |
| CONSTRUCTION | 55,395 |
| POST CARD | 18,677 |
| HOME OCCUPATION | 5,944 |
| SHOP DRAWING | 1,675 |
What you get
- One CSV of the slice you buyThe same columns as the sample file, person-name fields taken out.
- The rows we actually pulled172,942 rows on 26 Aug 2026, issue dates 1 Jan 2023 to 17 Aug 2026.
- CC BY 4.0 attribution, in the fileThe same block as on this page, once, at the foot of the CSV.
How it works
- Choose one slice: 2026, 2025, 2024, 2023, all four years.
- Pay $349, then reply to your receipt naming that slice. Rather know the row count first? Email us before you pay and we name it, with the pull date.
- A person emails you that slice as a CSV within one working day of your reply naming the slice.
$349 once is cheaper than the hours it takes to pull four years of FeatureServer layers yourself and strip the person columns out.
See the file before you pay
You do not have to take our word for what is in the file. Here are 25 rows of the real thing, carrying all 38 of its columns, cut out of the dated copies we sealed ourselves. Nothing in it is made up and nothing in it is tidied up.
- Open the 25 rows as a CSVA plain spreadsheet file. It saves to your machine rather than painting itself into a browser tab, and it opens in Excel, Numbers or Google Sheets.
- The same 25 rows as JSONThe same rows again, laid out for reading with code.
What arrives after you pay: the buyer receives what you asked for as a CSV — the same plain spreadsheet as the sample file above, not a login and not a web page —.
What you would be paying for: $349 once, for the assembled CSV of this slice. There is nothing to cancel and no subscription behind it. After you pay, a person emails you the slice you named as a CSV within one working day of your reply naming the slice. The file is sold under CC BY 4.0 with attribution; the required credit is printed on this page and travels with the file. We charge for assembly and delivery, not for rights to the data. The District's free portal remains at opendata.dc.gov. After you pay, a person emails you the slice you named as a CSV within one working day of your reply naming the slice.
These rows are a taste. The slice you buy is every row of the type or year you name, from the pull dated on this page.
Ask before you buy
$349 · One assembled file. Not a subscription.
Buy one slice — $349 onceRefunds: if what you receive is not what the page describes, email operations@ustechautomations.com within 7 days for a full refund. Support: same address, replies within 2 business days.
$349 once, for the assembled CSV of this slice. There is nothing to cancel and no subscription behind it. After you pay, a person emails you the slice you named as a CSV within one working day of your reply naming the slice. The file is sold under CC BY 4.0 with attribution; the required credit is printed on this page and travels with the file. We charge for assembly and delivery, not for rights to the data. The District's free portal remains at opendata.dc.gov. After you pay, a person emails you the slice you named as a CSV within one working day of your reply naming the slice.
Rather ask first? Email operations@ustechautomations.com. Say which Washington DC slice you want. We will tell you the row count and the pull date before you pay.