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

800 rows where county = "Nassau" 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 · 800 ✖

fips 1

county 1

  • Nassau · 800 ✖
Link rowid date ▲ county state fips cases deaths
2501455 2501455 2022-05-13 Nassau New York 36059 425386 3853
2498197 2498197 2022-05-12 Nassau New York 36059 425386 3852
2494939 2494939 2022-05-11 Nassau New York 36059 424236 3851
2491681 2491681 2022-05-10 Nassau New York 36059 423242 3850
2488423 2488423 2022-05-09 Nassau New York 36059 422614 3847
2485166 2485166 2022-05-08 Nassau New York 36059 422047 3845
2481908 2481908 2022-05-07 Nassau New York 36059 421094 3844
2478650 2478650 2022-05-06 Nassau New York 36059 420192 3843
2475392 2475392 2022-05-05 Nassau New York 36059 419200 3843
2472135 2472135 2022-05-04 Nassau New York 36059 418294 3842
2468879 2468879 2022-05-03 Nassau New York 36059 417503 3842
2465623 2465623 2022-05-02 Nassau New York 36059 417013 3842
2462368 2462368 2022-05-01 Nassau New York 36059 416557 3842
2459112 2459112 2022-04-30 Nassau New York 36059 416016 3840
2455856 2455856 2022-04-29 Nassau New York 36059 415333 3836
2452600 2452600 2022-04-28 Nassau New York 36059 414671 3835
2449344 2449344 2022-04-27 Nassau New York 36059 413836 3834
2446087 2446087 2022-04-26 Nassau New York 36059 413115 3833
2442832 2442832 2022-04-25 Nassau New York 36059 412805 3833
2439576 2439576 2022-04-24 Nassau New York 36059 412451 3833
2436320 2436320 2022-04-23 Nassau New York 36059 412010 3833
2433064 2433064 2022-04-22 Nassau New York 36059 411633 3831
2429808 2429808 2022-04-21 Nassau New York 36059 410967 3830
2426552 2426552 2022-04-20 Nassau New York 36059 410511 3830
2423296 2423296 2022-04-19 Nassau New York 36059 409997 3830
2420039 2420039 2022-04-18 Nassau New York 36059 409609 3826
2416784 2416784 2022-04-17 Nassau New York 36059 409205 3826
2413528 2413528 2022-04-16 Nassau New York 36059 408824 3826
2410272 2410272 2022-04-15 Nassau New York 36059 408289 3826
2407016 2407016 2022-04-14 Nassau New York 36059 407708 3825
2403760 2403760 2022-04-13 Nassau New York 36059 407111 3825
2400505 2400505 2022-04-12 Nassau New York 36059 406550 3825
2397250 2397250 2022-04-11 Nassau New York 36059 406276 3825
2393995 2393995 2022-04-10 Nassau New York 36059 405875 3825
2390739 2390739 2022-04-09 Nassau New York 36059 405208 3825
2387483 2387483 2022-04-08 Nassau New York 36059 404892 3824
2384228 2384228 2022-04-07 Nassau New York 36059 404538 3824
2380973 2380973 2022-04-06 Nassau New York 36059 404072 3824
2377718 2377718 2022-04-05 Nassau New York 36059 403806 3823
2374465 2374465 2022-04-04 Nassau New York 36059 403647 3822
2371213 2371213 2022-04-03 Nassau New York 36059 403486 3822
2367960 2367960 2022-04-02 Nassau New York 36059 403240 3822
2364707 2364707 2022-04-01 Nassau New York 36059 402919 3822
2361453 2361453 2022-03-31 Nassau New York 36059 402658 3822
2358199 2358199 2022-03-30 Nassau New York 36059 402360 3822
2354945 2354945 2022-03-29 Nassau New York 36059 402165 3822
2351692 2351692 2022-03-28 Nassau New York 36059 401999 3821
2348440 2348440 2022-03-27 Nassau New York 36059 401853 3821
2345187 2345187 2022-03-26 Nassau New York 36059 401654 3821
2341934 2341934 2022-03-25 Nassau New York 36059 401433 3821
2338681 2338681 2022-03-24 Nassau New York 36059 401205 3821
2335427 2335427 2022-03-23 Nassau New York 36059 400984 3821
2332173 2332173 2022-03-22 Nassau New York 36059 400768 3820
2328920 2328920 2022-03-21 Nassau New York 36059 400664 3820
2325668 2325668 2022-03-20 Nassau New York 36059 400564 3820
2322415 2322415 2022-03-19 Nassau New York 36059 400447 3820
2319161 2319161 2022-03-18 Nassau New York 36059 400265 3820
2315907 2315907 2022-03-17 Nassau New York 36059 400107 3819
2312654 2312654 2022-03-16 Nassau New York 36059 399980 3818
2309401 2309401 2022-03-15 Nassau New York 36059 399871 3817
2306148 2306148 2022-03-14 Nassau New York 36059 399755 3815
2302897 2302897 2022-03-13 Nassau New York 36059 399681 3815
2299645 2299645 2022-03-12 Nassau New York 36059 399571 3814
2296393 2296393 2022-03-11 Nassau New York 36059 399467 3814
2293141 2293141 2022-03-10 Nassau New York 36059 399334 3813
2289889 2289889 2022-03-09 Nassau New York 36059 399215 3811
2286637 2286637 2022-03-08 Nassau New York 36059 399090 3809
2283385 2283385 2022-03-07 Nassau New York 36059 399040 3808
2280133 2280133 2022-03-06 Nassau New York 36059 398962 3808
2276880 2276880 2022-03-05 Nassau New York 36059 398883 3808
2273627 2273627 2022-03-04 Nassau New York 36059 398668 3806
2270374 2270374 2022-03-03 Nassau New York 36059 398668 3806
2267122 2267122 2022-03-02 Nassau New York 36059 398487 3806
2263870 2263870 2022-03-01 Nassau New York 36059 398376 3805
2260619 2260619 2022-02-28 Nassau New York 36059 398278 3802
2257368 2257368 2022-02-27 Nassau New York 36059 398199 3801
2254117 2254117 2022-02-26 Nassau New York 36059 398082 3800
2250866 2250866 2022-02-25 Nassau New York 36059 397963 3800
2247615 2247615 2022-02-24 Nassau New York 36059 397812 3797
2244364 2244364 2022-02-23 Nassau New York 36059 397697 3794
2241113 2241113 2022-02-22 Nassau New York 36059 397550 3793
2237862 2237862 2022-02-21 Nassau New York 36059 397464 3792
2234611 2234611 2022-02-20 Nassau New York 36059 397356 3791
2231360 2231360 2022-02-19 Nassau New York 36059 397223 3789
2228109 2228109 2022-02-18 Nassau New York 36059 397058 3787
2224858 2224858 2022-02-17 Nassau New York 36059 396845 3787
2221607 2221607 2022-02-16 Nassau New York 36059 396617 3786
2218356 2218356 2022-02-15 Nassau New York 36059 396418 3785
2215105 2215105 2022-02-14 Nassau New York 36059 396250 3782
2211854 2211854 2022-02-13 Nassau New York 36059 396090 3780
2208601 2208601 2022-02-12 Nassau New York 36059 395873 3772
2205348 2205348 2022-02-11 Nassau New York 36059 395623 3772
2202095 2202095 2022-02-10 Nassau New York 36059 395337 3766
2198841 2198841 2022-02-09 Nassau New York 36059 394917 3761
2195587 2195587 2022-02-08 Nassau New York 36059 394485 3757
2192333 2192333 2022-02-07 Nassau New York 36059 394261 3754
2189079 2189079 2022-02-06 Nassau New York 36059 394006 3753
2185826 2185826 2022-02-05 Nassau New York 36059 393610 3746
2182574 2182574 2022-02-04 Nassau New York 36059 393177 3741
2179322 2179322 2022-02-03 Nassau New York 36059 392767 3735

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);