NYC Restaurant Inspections Database v.2.0.0
31,462 Restaurant permits
AccountWelcome, guestSign in / Register

Explore 31,462 restaurant and college-cafeteria permit records from NYC DOHMH, captured with an October 2, 2026 source cutoff. Use published names, addresses, cuisine descriptions and qualified inspection summaries for research, mapping and directory projects.
NYC Restaurant Directory includes establishments and latest inspection summaries. NYC Restaurant Inspection History adds 93,248 inspection observations and 289,225 violation records. Complete NYC Restaurant Data adds published administrative-geography identifiers and clearly marked matched historical facts.
The source includes 3,865 permits not yet inspected. Related inspection and citation rows are not additional restaurants. Some source details are missing, and the history is not a complete archive. Scores, grades and citations can change through adjudication. A reported grade or historical closure is not a real-time safety or operating-status guarantee. Consult the current NYC Health Department information and the establishment for current conditions.
Every tier provides its included tables in matching UTF-8 CSV, JSON and SQLite, with schemas, field definitions, samples, statistics and documentation. Codes retain leading zeros; missing values remain explicit.
USAGE
Import, modify, combine and analyze within one organization, including work by supervised contractors.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Usage License
Choose this package abovePUBLICATION
All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Publication License
Choose this package aboveMASTER
All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Master License
Choose this package aboveRelease structure
Review the published tables, record coverage, and field names included with release 2.0.0.
Data dictionary
| Table | Records | Fields |
|---|---|---|
| establishments | 31462 | camis, establishment_name, borough, address_line_1, state_code, postal_code, country_code, phone, cuisine_description, latitude, longitude, inspection_status, latest_inspection_date, latest_inspection_type, latest_inspection_action, latest_inspection_score, latest_observation_count, reported_grade, reported_grade_date, reported_grade_inspection_date, reported_grade_inspection_type, record_date |
| inspections | 93248 | inspection_id, camis, inspection_date, inspection_type, action, score, grade, grade_date, record_date, violation_count |
| violations | 289225 | violation_id, inspection_id, camis, violation_code, violation_description, critical_flag |
| administrative_geography | 31462 | geography_id, camis, community_board, council_district, census_tract, building_identification_number, borough_block_lot, neighborhood_tabulation_area, record_date |
| historical_facts | 34543 | historical_fact_id, camis, field_name, fact_value, verification_status, as_of_date, historical_version |
Release at a glance
Review verified record totals, geographic coverage, classifications, and field completeness for NYC Restaurant Inspections Database.
Select a table to review its schema, record total and fields. Distinct and missing-value counts appear where measured.
Inspect the data
Switch tables to review representative fields and rows from every table advertised for this release.
| camis | establishment_name | borough | address_line_1 | state_code | postal_code | country_code | phone | cuisine_description | latitude | longitude | inspection_status | latest_inspection_date | latest_inspection_type | latest_inspection_action | latest_inspection_score | latest_observation_count | reported_grade | reported_grade_date | reported_grade_inspection_date | reported_grade_inspection_type | record_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30075445 | MORRIS PARK BAKE SHOP | Bronx | 1007 MORRIS PARK AVENUE | NY | 10462 | US | 7188924968 | Bakery Products/Desserts | 40.848231224526 | -73.855971889932 | inspected | 2026-02-27 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 7 | 1 | A | 2026-02-27 | 2026-02-27 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 40936610 | JACK DEMSEY'S PUB | Manhattan | 36 WEST 33 STREET | NY | 10001 | US | 2126299899 | Irish | 40.748387159231 | -73.986556145104 | inspected | 2025-10-22 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 13 | 1 | A | 2025-10-22 | 2025-10-22 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 41384689 | WASABI POINT | Queens | 76-18 WOODSIDE AVENUE | NY | 11373 | US | 7182051056 | Asian/Asian Fusion | 40.743426250014 | -73.888620995926 | inspected | 2025-09-12 | Cycle Inspection / Re-inspection | Violations were cited in the following area(s). | 16 | 1 | B | 2025-09-12 | 2025-09-12 | Cycle Inspection / Re-inspection | 2026-10-02 |
| 41643403 | DON ANTONIO RESTAURANT | Manhattan | 309 WEST 50 STREET | NY | 10019 | US | 6467191043 | Italian | 40.762555628615 | -73.986730157337 | inspected | 2025-07-01 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 7 | 1 | A | 2025-07-01 | 2025-07-01 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50011573 | GRAN VILLA | Brooklyn | 4002 3 AVENUE | NY | 11232 | US | 3472605568 | Latin American | 40.653190707078 | -74.008862036378 | inspected | 2026-08-31 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 12 | 1 | A | 2026-08-31 | 2026-08-31 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50048257 | PATE PALO | Manhattan | 251 DYCKMAN STREET | NY | 10034 | US | 6469186242 | Latin American | 40.866428089872 | -73.928333163048 | inspected | 2026-08-26 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 10 | 1 | A | 2026-08-26 | 2026-08-26 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50071055 | BAO BAO NOODLE | Manhattan | 106 GREENWICH STREET | NY | 10006 | US | 9172617122 | Chinese | 40.708434354251 | -74.013399696944 | inspected | 2025-10-02 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 13 | 1 | A | 2025-10-02 | 2025-10-02 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50088233 | CAFE HESTIA | Manhattan | 513 7 AVENUE | NY | 10018 | US | 2127683838 | American | 40.753267599463 | -73.988951767419 | inspected | 2026-07-28 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 29 | 1 | B | 2025-07-15 | 2025-07-15 | Cycle Inspection / Re-inspection | 2026-10-02 |
| 50103690 | GENESIS | Queens | 78-04 WOODSIDE AVENUE | NY | 11373 | US | 7184262080 | Tex-Mex | 40.743679867795 | -73.886938852936 | inspected | 2026-06-08 | Cycle Inspection / Re-inspection | Violations were cited in the following area(s). | 27 | 1 | B | 2026-06-08 | 2026-06-08 | Cycle Inspection / Re-inspection | 2026-10-02 |
| 50113143 | HUNGRY GHOST | Manhattan | 315 BLEECKER STREET | NY | 10014 | US | 3475299448 | American | 40.732822328898 | -74.003911334621 | inspected | 2026-06-08 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 9 | 1 | A | 2026-06-08 | 2026-06-08 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50122983 | DIANE'S | Brooklyn | 425 GRAHAM AVENUE | NY | 11211 | US | 9175667699 | American | 40.717732167889 | -73.944921874537 | inspected | 2025-12-17 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 7 | 1 | A | 2025-12-17 | 2025-12-17 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50132265 | LOBSTER STEAKHOUSE RESTAURANT | Manhattan | 701 WEST 179 STREET | NY | 10033 | US | 6469344029 | Latin American | 40.848993333747 | -73.937348683074 | inspected | 2026-06-15 | Cycle Inspection / Re-inspection | Violations were cited in the following area(s). | 29 | 1 | Z | 2026-06-15 | 2026-06-15 | Cycle Inspection / Re-inspection | 2026-10-02 |
| 50142234 | LOBSTER PLACE SUSHI | Manhattan | 75 9 AVENUE | NY | 10011 | US | 2122555672 | Seafood | 40.741869040229 | -74.004713006739 | inspected | 2025-08-13 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 9 | 1 | A | 2025-08-13 | 2025-08-13 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50150049 | FABRIQUE | Manhattan | 550 5 AVENUE | NY | 10036 | US | 9295034149 | Bakery Products/Desserts | 40.755618529926 | -73.979335716143 | inspected | 2026-07-30 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 22 | 1 | A | 2025-03-26 | 2025-03-26 | Cycle Inspection / Initial Inspection | 2026-10-02 |
| 50160140 | XING SHUN 8 | Brooklyn | 5014 7 AVENUE | NY | 11220 | US | 6465783777 | Chinese | 40.642302344613 | -74.006068005125 | inspected | 2025-03-28 | Pre-permit (Operational) / Initial Inspection | Violations were cited in the following area(s). | 5 | 1 | A | 2025-03-28 | 2025-03-28 | Pre-permit (Operational) / Initial Inspection | 2026-10-02 |
| 50166919 | CHAYANN | Queens | 40-09 PRINCE STREET | NY | 11354 | US | 9178158896 | Coffee/Tea | 40.758823806017 | -73.831822402698 | inspected | 2025-09-25 | Pre-permit (Operational) / Re-inspection | Violations were cited in the following area(s). | 12 | 1 | A | 2025-09-25 | 2025-09-25 | Pre-permit (Operational) / Re-inspection | 2026-10-02 |
| 50174791 | STUFFED NYC PIZZA | Bronx | 3073 BAILEY AVENUE | NY | 10463 | US | 3478637385 | 40.877544714923 | -73.902823815109 | not_yet_inspected | 0 | 2026-10-02 | |||||||||
| 50180514 | BOCA DEL CIELO | Brooklyn | 8511 3 AVENUE | NY | 11209 | US | 3475606899 | American | 40.624125164536 | -74.030774819771 | inspected | 2026-09-17 | Pre-permit (Operational) / Initial Inspection | Violations were cited in the following area(s). | 20 | 1 | 2026-10-02 | ||||
| 50186801 | BARK BARBECUE | Brooklyn | 25 THAMES STREET | NY | 11206 | US | 3478815799 | 40.704868781233 | -73.932085391566 | not_yet_inspected | 0 | 2026-10-02 | |||||||||
| 50193232 | 100% | Brooklyn | 602 NOSTRAND AVE | NY | 11216 | US | 9734324623 | 40.677948907245 | -73.94974625156 | not_yet_inspected | 0 | 2026-10-02 |
| inspection_id | camis | inspection_date | inspection_type | action | score | grade | grade_date | record_date | violation_count |
|---|---|---|---|---|---|---|---|---|---|
| 0000452006023716054c08ec | 50044589 | 2025-02-01 | Cycle Inspection / Initial Inspection | No violations were recorded at the time of this inspection. | 0 | A | 2025-02-01 | 2026-10-02 | 0 |
| 0d81d4374987bf456fa69a58 | 41046187 | 2022-10-18 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 5 | A | 2022-10-18 | 2026-10-02 | 1 |
| 1ac6e0554ccd07bef7a85490 | 50068836 | 2024-06-12 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 13 | A | 2024-06-12 | 2026-10-02 | 3 |
| 28397558f6d2a78221940498 | 50096278 | 2026-02-04 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 10 | A | 2026-02-04 | 2026-10-02 | 1 |
| 35b00da9e4839ffc8fe82812 | 50165391 | 2025-07-10 | Pre-permit (Operational) / Initial Inspection | Violations were cited in the following area(s). | 40 | 2026-10-02 | 4 | ||
| 42fb6ba69960321d9e8c6af4 | 41319438 | 2024-05-10 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 13 | A | 2024-05-10 | 2026-10-02 | 3 |
| 507085402a0b344998dc1c76 | 50157149 | 2025-06-03 | Cycle Inspection / Re-inspection | Violations were cited in the following area(s). | 21 | B | 2025-06-03 | 2026-10-02 | 3 |
| 5df64a4da4c8003a0ea7df7a | 50017819 | 2023-01-12 | Cycle Inspection / Re-inspection | Violations were cited in the following area(s). | 10 | A | 2023-01-12 | 2026-10-02 | 2 |
| 6b92ecc19d572714341827ff | 50103170 | 2026-05-15 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 6 | A | 2026-05-15 | 2026-10-02 | 3 |
| 7907831ce9f9b9da42658755 | 50079429 | 2025-08-13 | Cycle Inspection / Re-inspection | Violations were cited in the following area(s). | 9 | A | 2025-08-13 | 2026-10-02 | 2 |
| 86b0a6e5ecc39af912443a58 | 50080016 | 2024-09-23 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 10 | A | 2024-09-23 | 2026-10-02 | 2 |
| 94086402779c8de1eee43816 | 50118860 | 2023-06-06 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 30 | 2026-10-02 | 8 | ||
| a1c071064b5780fedd5169b7 | 50166830 | 2025-12-10 | Pre-permit (Operational) / Initial Inspection | Violations were cited in the following area(s). | 27 | N | 2026-10-02 | 9 | |
| aee12104231e2f9859bc8c3c | 41636395 | 2024-09-14 | Inter-Agency Task Force / Initial Inspection | No violations were recorded at the time of this inspection. | 0 | 2026-10-02 | 0 | ||
| bc6ef3d38eedc311c2db144a | 50103577 | 2024-10-30 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 7 | A | 2024-10-30 | 2026-10-02 | 2 |
| ca1106d99f89f590e72d9a5e | 50107410 | 2026-08-06 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 12 | A | 2026-08-06 | 2026-10-02 | 2 |
| d7a2dfa566ca08e0b960f3d0 | 50150901 | 2024-06-27 | Administrative Miscellaneous / Initial Inspection | Violations were cited in the following area(s). | 2026-10-02 | 1 | |||
| e51926539fbb17d9b36c7911 | 50105144 | 2026-06-09 | Cycle Inspection / Re-inspection | Violations were cited in the following area(s). | 10 | A | 2026-06-09 | 2026-10-02 | 2 |
| f292b7a0db9ac3e0f782f566 | 50160958 | 2025-02-21 | Pre-permit (Operational) / Initial Inspection | Violations were cited in the following area(s). | 30 | N | 2026-10-02 | 6 | |
| fffff7e1ec39098093b4ff2c | 50045196 | 2026-06-01 | Cycle Inspection / Initial Inspection | Violations were cited in the following area(s). | 29 | 2026-10-02 | 5 |
| violation_id | inspection_id | camis | violation_code | violation_description | critical_flag |
|---|---|---|---|---|---|
| 00002e61d1e55f923d9d2f6e | f2aad7d53de55d86267fde29 | 50161233 | 06C | Food, supplies, or equipment not protected from potential source of contamination during storage, preparation, transportation, display, service or from customer’s refillable, reusable container. Condiments not in single-service containers or dispensed directly by the vendor. | Critical |
| 0d9c0b5ceaa5c9b1f03432a9 | 95bf3fcae11763327bad4853 | 50146979 | 02G | Cold TCS food item held above 41 °F; smoked or processed fish held above 38 °F; intact raw eggs held above 45 °F; or reduced oxygen packaged (ROP) TCS foods held above required temperatures except during active necessary preparation. | Critical |
| 1b0af2ec00099d55f807e0b3 | f648b3e89fea482b0571fbc3 | 41301576 | 28-05 | Food adulterated or misbranded. Adulterated or misbranded food possessed, being manufactured, produced, packed, sold, offered for sale, delivered or given away | Not Critical |
| 28b9b9e47a08645a2c95d507 | 1b14d9cf67e2e03e5248adbb | 41393008 | 04L | Evidence of mice or live mice in establishment's food or non-food areas. | Critical |
| 3619cdb24f0efb49c87f04b9 | 932b9a6e7c7138057c943887 | 50091290 | 06D | Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred. | Critical |
| 437b96b733c869d311707df1 | 027170efb87c2993c0a22668 | 41543410 | 02G | Cold TCS food item held above 41 °F; smoked or processed fish held above 38 °F; intact raw eggs held above 45 °F; or reduced oxygen packaged (ROP) TCS foods held above required temperatures except during active necessary preparation. | Critical |
| 50df9f928b7f31803f454cec | 02270fe4640ba4dc3be77eed | 50085359 | 09A | Swollen, leaking, rusted or otherwise damaged canned food to be returned to distributor not segregated from intact product and clearly labeled DO NOT USE | Not Critical |
| 5e550f474e8308a266dcab77 | 49233b445094407531d5324f | 41396659 | 10F | Non-food contact surface or equipment made of unacceptable material, not kept clean, or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical |
| 6bcab6a5894142188ff1142b | fb5e56b7bccd383f14636791 | 50152635 | 10G | Dishwashing and ware washing: Cleaning and sanitizing of tableware, including dishes, utensils, and equipment deficient. | Not Critical |
| 79317e8b50927f6fcd5c84eb | 2c8378ce65d79a69011bffbd | 41400697 | 10G | Dishwashing and ware washing: Cleaning and sanitizing of tableware, including dishes, utensils, and equipment deficient. | Not Critical |
| 86a85c2aa0849e68f785681d | 45b2fbd375b30856ff5bb684 | 50147695 | 04N | Filth flies or food/refuse/sewage associated with (FRSA) flies or other nuisance pests in establishment’s food and/or non-food areas. FRSA flies include house flies, blow flies, bottle flies, flesh flies, drain flies, Phorid flies and fruit flies. | Critical |
| 9455f53df24e69e4154e9575 | 2f6fc19af6b9a5f23c7b9810 | 50045891 | 09A | Swollen, leaking, rusted or otherwise damaged canned food to be returned to distributor not segregated from intact product and clearly labeled DO NOT USE | Not Critical |
| a1ae709f8e028f500288c170 | 6159aae6bcd99bbeee368704 | 50107649 | 04N | Filth flies or food/refuse/sewage associated with (FRSA) flies or other nuisance pests in establishment’s food and/or non-food areas. FRSA flies include house flies, blow flies, bottle flies, flesh flies, drain flies, Phorid flies and fruit flies. | Critical |
| af26089ed95e5947e19c852d | ed8dc9ee8b9cd535f1a6a826 | 50083089 | 04N | Filth flies or food/refuse/sewage associated with (FRSA) flies or other nuisance pests in establishment’s food and/or non-food areas. FRSA flies include house flies, blow flies, bottle flies, flesh flies, drain flies, Phorid flies and fruit flies. | Critical |
| bcb973e9f2f37c11fbf2f388 | 9999652d03af4e615465dadf | 41444789 | 10F | Non-food contact surface or equipment made of unacceptable material, not kept clean, or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit. | Not Critical |
| ca4158fdd2d0cd3ad181bad7 | db1eff284902b8aec650e87f | 50115168 | 04H | Raw, cooked or prepared food is adulterated, contaminated, cross-contaminated, or not discarded in accordance with HACCP plan. | Critical |
| d7b77c6f3fd15d4d7a9eed4f | c54dad53cf0b9b6489f3d979 | 50078216 | 02B | Hot TCS food item not held at or above 140 °F. | Critical |
| e520cd759401b64dc87513ea | bed07bc312b8867eeb943355 | 50006735 | 08A | Establishment is not free of harborage or conditions conducive to rodents, insects or other pests. | Not Critical |
| f273328d9f0cbf72953213a0 | ee810b3c2c7e945a062d89d4 | 50006109 | 04L | Evidence of mice or live mice in establishment's food or non-food areas. | Critical |
| ffff76061dc9512a56466d00 | 74c9b5085f7dfaaa2c1cb062 | 50086573 | 04H | Raw, cooked or prepared food is adulterated, contaminated, cross-contaminated, or not discarded in accordance with HACCP plan. | Critical |
| geography_id | camis | community_board | council_district | census_tract | building_identification_number | borough_block_lot | neighborhood_tabulation_area | record_date |
|---|---|---|---|---|---|---|---|---|
| 0008ead1928e97173f9c7c0a | 50169166 | 201 | 17 | 005100 | 2001019 | 2023430032 | BX39 | 2026-10-02 |
| 0e584df575984d61de10aa2d | 50110370 | 302 | 35 | 018300 | 3058292 | 3020720029 | BK68 | 2026-10-02 |
| 1c5db708e37a6ffc4a300874 | 41681330 | 304 | 37 | 042900 | 3073561 | 3032350016 | BK77 | 2026-10-02 |
| 2a0327cc2286fbc7f9781ef8 | 50078334 | 404 | 21 | 040300 | 4048939 | 4019870073 | QN26 | 2026-10-02 |
| 375fc0f7817e696ad9ccc951 | 50099843 | 109 | 07 | 020901 | 1084100 | 1019660033 | MN09 | 2026-10-02 |
| 44f68ab98c951a2168c0f119 | 50192223 | 104 | 03 | 010300 | 1012843 | 1007310001 | MN13 | 2026-10-02 |
| 520dd30f66c01dd29864500c | 50045596 | 208 | 11 | 033700 | 2084805 | 2058481761 | BX22 | 2026-10-02 |
| 5f19bcd3d2d5795986f2153e | 50190088 | 403 | 21 | 040300 | 4442976 | 4017760078 | QN26 | 2026-10-02 |
| 6ca296672f7ffdc2a8f3e20e | 50190437 | 307 | 43 | 010200 | 3324484 | 3008570041 | BK34 | 2026-10-02 |
| 79bf1149229ae192e462327d | 50104563 | 2026-10-02 | ||||||
| 8705fb9715e9628fceaf9195 | 50156700 | 402 | 26 | 000700 | 4436586 | 4000300001 | QN31 | 2026-10-02 |
| 94a4ac4e02dfe641812fb2e4 | 50053932 | 105 | 03 | 009500 | 1015135 | 1008050001 | MN17 | 2026-10-02 |
| a215069ae9365764d893bc2d | 50100556 | 105 | 04 | 009600 | 1034341 | 1012620048 | MN17 | 2026-10-02 |
| af33c874cb02d7c76e4ef1a5 | 50116334 | 108 | 05 | 014602 | 1048848 | 1015340024 | MN32 | 2026-10-02 |
| bcc93caaa38ea2703bdbb81b | 50139065 | 102 | 03 | 007100 | 1010652 | 1006090045 | MN23 | 2026-10-02 |
| ca1c7d7630982284c3eb4c05 | 50043186 | 107 | 07 | 019500 | 1075380 | 1018807501 | MN09 | 2026-10-02 |
| d7e2e20fe0d4778c5941702c | 50155397 | 104 | 03 | 008700 | 1087260 | 1007957501 | MN13 | 2026-10-02 |
| e524fc7a388d4ced7d7062ad | 41690699 | 110 | 09 | 022400 | 1079507 | 1019140034 | MN03 | 2026-10-02 |
| f2efa1878cbfd8cb440f21eb | 50175702 | 104 | 03 | 009900 | 1090682 | 1006897501 | MN13 | 2026-10-02 |
| fffe7198ff5d921cafac5d9b | 50118265 | 411 | 23 | 137700 | 4163156 | 4076440009 | QN42 | 2026-10-02 |
| historical_fact_id | camis | field_name | fact_value | verification_status | as_of_date | historical_version |
|---|---|---|---|---|---|---|
| 00014ecd50b7011335b960fd | 50055322 | insp_date | 04/15/2011 | historical_unverified | 2011-04-15 | 1.0.3 |
| 0d840da7618400379c3caec9 | 41104417 | loc_TZ | EST | historical_unverified | 1.0.3 | |
| 1b2e8ce1f4cf5cc0c9215da7 | 41519649 | loc_FIPS | 36081 | historical_unverified | 1.0.3 | |
| 28211d12a31102b136d2aecb | 41127243 | loc_LONG_centroid | -73.9207 | historical_unverified | 1.0.3 | |
| 361963dfe00fd0f23791098e | 40563041 | loc_LONG_poly | -73.9835113 | historical_unverified | 1.0.3 | |
| 4306fc91ba51912edafd74b9 | 41070857 | loc_LAT_poly | 40.6634893 | historical_unverified | 1.0.3 | |
| 50dadee3ade5a1a000f7799d | 41663211 | loc_TZ | EST | historical_unverified | 1.0.3 | |
| 5e36a8c085a18ede315a3db9 | 41468119 | insp_violations | 7 | historical_unverified | 2010-11-29 | 1.0.3 |
| 6b9716f1c516964aa789e234 | 41185899 | loc_LAT_centroid | 40.7500 | historical_unverified | 1.0.3 | |
| 789fafb09bd0c35257d8dc22 | 50001311 | loc_LONG_poly | -73.771251 | historical_unverified | 1.0.3 | |
| 85ce84a06ee5d1024dbb5588 | 50168037 | loc_area_code | 718 | historical_unverified | 1.0.3 | |
| 9373972d9e6891f7411f1383 | 40375286 | loc_PMSA | 5600 | historical_unverified | 1.0.3 | |
| a10eb9039c10c19fe9df0d04 | 40403857 | loc_area_code | 718 | historical_unverified | 1.0.3 | |
| af3017785e79e7fbb163476b | 50044993 | loc_DST | Y | historical_unverified | 1.0.3 | |
| bcfea95dcd3bc38639cd1ddb | 50058174 | loc_TZ | EST | historical_unverified | 1.0.3 | |
| cb0a73cc9bd4f85250d48a7a | 40686067 | loc_PMSA | 5600 | historical_unverified | 1.0.3 | |
| d85d7d878855b1c4fa23fb1f | 41689690 | insp_date | 04/21/2011 | historical_unverified | 2011-04-21 | 1.0.3 |
| e5a6566c24f4f933668c8b24 | 40999268 | loc_county | Queens | historical_unverified | 1.0.3 | |
| f2de97eb0667f4bf1283b516 | 40402424 | loc_LONG_centroid | -74.0132 | historical_unverified | 1.0.3 | |
| fffe6f42c855d6f6c64cc84e | 50146167 | loc_LONG_poly | -74.0097911 | historical_unverified | 1.0.3 |
31,462 establishments; 93,248 inspections; 289,225 violations; 31,462 administrative geography; 34,543 historical facts. Establishment permits are the primary count; related rows are not extra restaurants.
Need a closer fit?
A clear path from download to project
Understand the files, check the sample coverage, and choose the license that fits your use.