ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

804 rows where county = "New York City" and state = "New York" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • New York · 804 ✖

fips 1

  • - 804

county 1

  • New York City · 804 ✖
Link rowid date ▲ county state fips cases deaths
2501456 2501456 2022-05-13 New York City New York   2422658 40267
2498198 2498198 2022-05-12 New York City New York   2417909 40261
2494940 2494940 2022-05-11 New York City New York   2411431 40256
2491682 2491682 2022-05-10 New York City New York   2408357 40248
2488424 2488424 2022-05-09 New York City New York   2406070 40240
2485167 2485167 2022-05-08 New York City New York   2392903 40232
2481909 2481909 2022-05-07 New York City New York   2392182 40232
2478651 2478651 2022-05-06 New York City New York   2392182 40232
2475393 2475393 2022-05-05 New York City New York   2387684 40227
2472136 2472136 2022-05-04 New York City New York   2383719 40220
2468880 2468880 2022-05-03 New York City New York   2381364 40210
2465624 2465624 2022-05-02 New York City New York   2378943 40206
2462369 2462369 2022-05-01 New York City New York   2370380 40199
2459113 2459113 2022-04-30 New York City New York   2370380 40199
2455857 2455857 2022-04-29 New York City New York   2370380 40199
2452601 2452601 2022-04-28 New York City New York   2367263 40193
2449345 2449345 2022-04-27 New York City New York   2363845 40184
2446088 2446088 2022-04-26 New York City New York   2362027 40181
2442833 2442833 2022-04-25 New York City New York   2360368 40174
2439577 2439577 2022-04-24 New York City New York   2353829 40167
2436321 2436321 2022-04-23 New York City New York   2353829 40167
2433065 2433065 2022-04-22 New York City New York   2353829 40167
2429809 2429809 2022-04-21 New York City New York   2350614 40166
2426553 2426553 2022-04-20 New York City New York   2348182 40159
2423297 2423297 2022-04-19 New York City New York   2345646 40152
2420040 2420040 2022-04-18 New York City New York   2343807 40144
2416785 2416785 2022-04-17 New York City New York   2336249 40133
2413529 2413529 2022-04-16 New York City New York   2336249 40133
2410273 2410273 2022-04-15 New York City New York   2336249 40133
2407017 2407017 2022-04-14 New York City New York   2333580 40128
2403761 2403761 2022-04-13 New York City New York   2330645 40126
2400506 2400506 2022-04-12 New York City New York   2329080 40118
2397251 2397251 2022-04-11 New York City New York   2327868 40109
2393996 2393996 2022-04-10 New York City New York   2320951 40104
2390740 2390740 2022-04-09 New York City New York   2320951 40104
2387484 2387484 2022-04-08 New York City New York   2320951 40104
2384229 2384229 2022-04-07 New York City New York   2318643 40100
2380974 2380974 2022-04-06 New York City New York   2315916 40097
2377719 2377719 2022-04-05 New York City New York   2315117 40090
2374466 2374466 2022-04-04 New York City New York   2314117 40092
2371214 2371214 2022-04-03 New York City New York   2309135 40087
2367961 2367961 2022-04-02 New York City New York   2309135 40087
2364708 2364708 2022-04-01 New York City New York   2309135 40087
2361454 2361454 2022-03-31 New York City New York   2307640 40079
2358200 2358200 2022-03-30 New York City New York   2305299 40076
2354946 2354946 2022-03-29 New York City New York   2304195 40073
2351693 2351693 2022-03-28 New York City New York   2303319 40064
2348441 2348441 2022-03-27 New York City New York   2302162 40063
2345188 2345188 2022-03-26 New York City New York   2299395 40055
2341935 2341935 2022-03-25 New York City New York   2299395 40055
2338682 2338682 2022-03-24 New York City New York   2297915 40046
2335428 2335428 2022-03-23 New York City New York   2296110 40044
2332174 2332174 2022-03-22 New York City New York   2294930 40030
2328921 2328921 2022-03-21 New York City New York   2294431 40020
2325669 2325669 2022-03-20 New York City New York   2293668 40019
2322416 2322416 2022-03-19 New York City New York   2291467 40022
2319162 2319162 2022-03-18 New York City New York   2291467 40022
2315908 2315908 2022-03-17 New York City New York   2290645 40012
2312655 2312655 2022-03-16 New York City New York   2289696 39994
2309402 2309402 2022-03-15 New York City New York   2288768 39964
2306149 2306149 2022-03-14 New York City New York   2287334 39941
2302898 2302898 2022-03-13 New York City New York   2286771 39941
2299646 2299646 2022-03-12 New York City New York   2285170 39925
2296394 2296394 2022-03-11 New York City New York   2285170 39925
2293142 2293142 2022-03-10 New York City New York   2284312 39913
2289890 2289890 2022-03-09 New York City New York   2283525 39914
2286638 2286638 2022-03-08 New York City New York   2283065 39927
2283386 2283386 2022-03-07 New York City New York   2282699 39903
2280134 2280134 2022-03-06 New York City New York   2282240 39902
2276881 2276881 2022-03-05 New York City New York   2280314 39876
2273628 2273628 2022-03-04 New York City New York   2280314 39876
2270375 2270375 2022-03-03 New York City New York   2279547 39854
2267123 2267123 2022-03-02 New York City New York   2278642 39835
2263871 2263871 2022-03-01 New York City New York   2278302 39811
2260620 2260620 2022-02-28 New York City New York   2277887 39784
2257369 2257369 2022-02-27 New York City New York   2277403 39783
2254118 2254118 2022-02-26 New York City New York   2275738 39754
2250867 2250867 2022-02-25 New York City New York   2275738 39754
2247616 2247616 2022-02-24 New York City New York   2274852 39717
2244365 2244365 2022-02-23 New York City New York   2273785 39679
2241114 2241114 2022-02-22 New York City New York   2273143 39644
2237863 2237863 2022-02-21 New York City New York   2272601 39597
2234612 2234612 2022-02-20 New York City New York   2269786 39554
2231361 2231361 2022-02-19 New York City New York   2269786 39554
2228110 2228110 2022-02-18 New York City New York   2269786 39554
2224859 2224859 2022-02-17 New York City New York   2267599 39503
2221608 2221608 2022-02-16 New York City New York   2266398 39468
2218357 2218357 2022-02-15 New York City New York   2265529 39416
2215106 2215106 2022-02-14 New York City New York   2264844 39324
2211855 2211855 2022-02-13 New York City New York   2263895 39320
2208602 2208602 2022-02-12 New York City New York   2260841 39256
2205349 2205349 2022-02-11 New York City New York   2260841 39256
2202096 2202096 2022-02-10 New York City New York   2259265 39192
2198842 2198842 2022-02-09 New York City New York   2256018 39120
2195588 2195588 2022-02-08 New York City New York   2254081 39012
2192334 2192334 2022-02-07 New York City New York   2252531 38876
2189080 2189080 2022-02-06 New York City New York   2250893 38863
2185827 2185827 2022-02-05 New York City New York   2245915 38766
2182575 2182575 2022-02-04 New York City New York   2245915 38766
2179323 2179323 2022-02-03 New York City New York   2243326 38677

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);