ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where deaths = 129 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501480 | 2501480 | 2022-05-13 | Warren | New York | 36113 | 14739 | 129 |
2498188 | 2498188 | 2022-05-12 | Greene | New York | 36039 | 9055 | 129 |
2498222 | 2498222 | 2022-05-12 | Warren | New York | 36113 | 14739 | 129 |
2494930 | 2494930 | 2022-05-11 | Greene | New York | 36039 | 9044 | 129 |
2494964 | 2494964 | 2022-05-11 | Warren | New York | 36113 | 14693 | 129 |
2491672 | 2491672 | 2022-05-10 | Greene | New York | 36039 | 9025 | 129 |
2491706 | 2491706 | 2022-05-10 | Warren | New York | 36113 | 14635 | 129 |
2488414 | 2488414 | 2022-05-09 | Greene | New York | 36039 | 9017 | 129 |
2488448 | 2488448 | 2022-05-09 | Warren | New York | 36113 | 14616 | 129 |
2485157 | 2485157 | 2022-05-08 | Greene | New York | 36039 | 9012 | 129 |
2485191 | 2485191 | 2022-05-08 | Warren | New York | 36113 | 14588 | 129 |
2481899 | 2481899 | 2022-05-07 | Greene | New York | 36039 | 9002 | 129 |
2478641 | 2478641 | 2022-05-06 | Greene | New York | 36039 | 8990 | 129 |
2475383 | 2475383 | 2022-05-05 | Greene | New York | 36039 | 8961 | 129 |
2472126 | 2472126 | 2022-05-04 | Greene | New York | 36039 | 8943 | 129 |
2468870 | 2468870 | 2022-05-03 | Greene | New York | 36039 | 8921 | 129 |
2465614 | 2465614 | 2022-05-02 | Greene | New York | 36039 | 8914 | 129 |
2462359 | 2462359 | 2022-05-01 | Greene | New York | 36039 | 8910 | 129 |
2459103 | 2459103 | 2022-04-30 | Greene | New York | 36039 | 8898 | 129 |
2442853 | 2442853 | 2022-04-25 | Sullivan | New York | 36105 | 18755 | 129 |
2439597 | 2439597 | 2022-04-24 | Sullivan | New York | 36105 | 18736 | 129 |
2436341 | 2436341 | 2022-04-23 | Sullivan | New York | 36105 | 18709 | 129 |
2433085 | 2433085 | 2022-04-22 | Sullivan | New York | 36105 | 18690 | 129 |
2429829 | 2429829 | 2022-04-21 | Sullivan | New York | 36105 | 18662 | 129 |
2426573 | 2426573 | 2022-04-20 | Sullivan | New York | 36105 | 18641 | 129 |
2423317 | 2423317 | 2022-04-19 | Sullivan | New York | 36105 | 18619 | 129 |
2420060 | 2420060 | 2022-04-18 | Sullivan | New York | 36105 | 18612 | 129 |
2416805 | 2416805 | 2022-04-17 | Sullivan | New York | 36105 | 18601 | 129 |
2413549 | 2413549 | 2022-04-16 | Sullivan | New York | 36105 | 18587 | 129 |
2410293 | 2410293 | 2022-04-15 | Sullivan | New York | 36105 | 18554 | 129 |
2407037 | 2407037 | 2022-04-14 | Sullivan | New York | 36105 | 18528 | 129 |
2403781 | 2403781 | 2022-04-13 | Sullivan | New York | 36105 | 18513 | 129 |
2400526 | 2400526 | 2022-04-12 | Sullivan | New York | 36105 | 18495 | 129 |
2397271 | 2397271 | 2022-04-11 | Sullivan | New York | 36105 | 18484 | 129 |
2394016 | 2394016 | 2022-04-10 | Sullivan | New York | 36105 | 18473 | 129 |
2390760 | 2390760 | 2022-04-09 | Sullivan | New York | 36105 | 18462 | 129 |
2387504 | 2387504 | 2022-04-08 | Sullivan | New York | 36105 | 18446 | 129 |
2384249 | 2384249 | 2022-04-07 | Sullivan | New York | 36105 | 18429 | 129 |
2380994 | 2380994 | 2022-04-06 | Sullivan | New York | 36105 | 18403 | 129 |
2377739 | 2377739 | 2022-04-05 | Sullivan | New York | 36105 | 18386 | 129 |
2374486 | 2374486 | 2022-04-04 | Sullivan | New York | 36105 | 18378 | 129 |
2371234 | 2371234 | 2022-04-03 | Sullivan | New York | 36105 | 18373 | 129 |
2367981 | 2367981 | 2022-04-02 | Sullivan | New York | 36105 | 18364 | 129 |
2364728 | 2364728 | 2022-04-01 | Sullivan | New York | 36105 | 18351 | 129 |
2361474 | 2361474 | 2022-03-31 | Sullivan | New York | 36105 | 18341 | 129 |
2358220 | 2358220 | 2022-03-30 | Sullivan | New York | 36105 | 18331 | 129 |
2354966 | 2354966 | 2022-03-29 | Sullivan | New York | 36105 | 18324 | 129 |
2351713 | 2351713 | 2022-03-28 | Sullivan | New York | 36105 | 18321 | 129 |
2348461 | 2348461 | 2022-03-27 | Sullivan | New York | 36105 | 18320 | 129 |
2345208 | 2345208 | 2022-03-26 | Sullivan | New York | 36105 | 18311 | 129 |
2341955 | 2341955 | 2022-03-25 | Sullivan | New York | 36105 | 18309 | 129 |
2338702 | 2338702 | 2022-03-24 | Sullivan | New York | 36105 | 18304 | 129 |
2335448 | 2335448 | 2022-03-23 | Sullivan | New York | 36105 | 18301 | 129 |
2332194 | 2332194 | 2022-03-22 | Sullivan | New York | 36105 | 18292 | 129 |
2328941 | 2328941 | 2022-03-21 | Sullivan | New York | 36105 | 18286 | 129 |
2325689 | 2325689 | 2022-03-20 | Sullivan | New York | 36105 | 18285 | 129 |
2322436 | 2322436 | 2022-03-19 | Sullivan | New York | 36105 | 18283 | 129 |
2319182 | 2319182 | 2022-03-18 | Sullivan | New York | 36105 | 18276 | 129 |
2315928 | 2315928 | 2022-03-17 | Sullivan | New York | 36105 | 18272 | 129 |
2312675 | 2312675 | 2022-03-16 | Sullivan | New York | 36105 | 18266 | 129 |
2309422 | 2309422 | 2022-03-15 | Sullivan | New York | 36105 | 18261 | 129 |
2306169 | 2306169 | 2022-03-14 | Sullivan | New York | 36105 | 18255 | 129 |
2250860 | 2250860 | 2022-02-25 | Jefferson | New York | 36045 | 19558 | 129 |
2247609 | 2247609 | 2022-02-24 | Jefferson | New York | 36045 | 19545 | 129 |
2244358 | 2244358 | 2022-02-23 | Jefferson | New York | 36045 | 19517 | 129 |
2241107 | 2241107 | 2022-02-22 | Jefferson | New York | 36045 | 19500 | 129 |
2237856 | 2237856 | 2022-02-21 | Jefferson | New York | 36045 | 19488 | 129 |
2234605 | 2234605 | 2022-02-20 | Jefferson | New York | 36045 | 19474 | 129 |
2231354 | 2231354 | 2022-02-19 | Jefferson | New York | 36045 | 19446 | 129 |
2228103 | 2228103 | 2022-02-18 | Jefferson | New York | 36045 | 19415 | 129 |
2224852 | 2224852 | 2022-02-17 | Jefferson | New York | 36045 | 19387 | 129 |
2133752 | 2133752 | 2022-01-20 | Columbia | New York | 36021 | 8894 | 129 |
2130500 | 2130500 | 2022-01-19 | Columbia | New York | 36021 | 8772 | 129 |
2127246 | 2127246 | 2022-01-18 | Columbia | New York | 36021 | 8734 | 129 |
2062224 | 2062224 | 2021-12-29 | Fulton | New York | 36035 | 8938 | 129 |
2058975 | 2058975 | 2021-12-28 | Fulton | New York | 36035 | 8874 | 129 |
2055726 | 2055726 | 2021-12-27 | Fulton | New York | 36035 | 8858 | 129 |
2019990 | 2019990 | 2021-12-16 | Ontario | New York | 36069 | 12959 | 129 |
1935477 | 1935477 | 2021-11-20 | Oswego | New York | 36075 | 13516 | 129 |
1932227 | 1932227 | 2021-11-19 | Oswego | New York | 36075 | 13437 | 129 |
1863971 | 1863971 | 2021-10-29 | Herkimer | New York | 36043 | 7028 | 129 |
1860722 | 1860722 | 2021-10-28 | Herkimer | New York | 36043 | 6994 | 129 |
1857473 | 1857473 | 2021-10-27 | Herkimer | New York | 36043 | 6967 | 129 |
1854224 | 1854224 | 2021-10-26 | Herkimer | New York | 36043 | 6913 | 129 |
1850975 | 1850975 | 2021-10-25 | Herkimer | New York | 36043 | 6890 | 129 |
1740502 | 1740502 | 2021-09-21 | Genesee | New York | 36037 | 6045 | 129 |
1665793 | 1665793 | 2021-08-29 | Montgomery | New York | 36057 | 4645 | 129 |
1136508 | 1136508 | 2021-03-19 | Chautauqua | New York | 36013 | 7660 | 129 |
1133262 | 1133262 | 2021-03-18 | Chautauqua | New York | 36013 | 7635 | 129 |
1130014 | 1130014 | 2021-03-17 | Chautauqua | New York | 36013 | 7598 | 129 |
1126767 | 1126767 | 2021-03-16 | Chautauqua | New York | 36013 | 7582 | 129 |
1123521 | 1123521 | 2021-03-15 | Chautauqua | New York | 36013 | 7562 | 129 |
1120275 | 1120275 | 2021-03-14 | Chautauqua | New York | 36013 | 7538 | 129 |
1117028 | 1117028 | 2021-03-13 | Chautauqua | New York | 36013 | 7527 | 129 |
1058604 | 1058604 | 2021-02-23 | Chemung | New York | 36015 | 6392 | 129 |
1055358 | 1055358 | 2021-02-22 | Chemung | New York | 36015 | 6375 | 129 |
1052112 | 1052112 | 2021-02-21 | Chemung | New York | 36015 | 6362 | 129 |
1048865 | 1048865 | 2021-02-20 | Chemung | New York | 36015 | 6350 | 129 |
1048897 | 1048897 | 2021-02-20 | Rensselaer | New York | 36083 | 8760 | 129 |
1045618 | 1045618 | 2021-02-19 | Chemung | New York | 36015 | 6345 | 129 |
Advanced export
JSON shape: default, array, newline-delimited
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);