ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where county = "Marion" and deaths = 36 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2126341 | 2126341 | 2022-01-18 | Marion | Kansas | 20115 | 2624 | 36 |
2123089 | 2123089 | 2022-01-17 | Marion | Kansas | 20115 | 2624 | 36 |
2119837 | 2119837 | 2022-01-16 | Marion | Kansas | 20115 | 2624 | 36 |
2116585 | 2116585 | 2022-01-15 | Marion | Kansas | 20115 | 2624 | 36 |
2113334 | 2113334 | 2022-01-14 | Marion | Kansas | 20115 | 2624 | 36 |
2110082 | 2110082 | 2022-01-13 | Marion | Kansas | 20115 | 2536 | 36 |
2106831 | 2106831 | 2022-01-12 | Marion | Kansas | 20115 | 2536 | 36 |
2103580 | 2103580 | 2022-01-11 | Marion | Kansas | 20115 | 2419 | 36 |
2100329 | 2100329 | 2022-01-10 | Marion | Kansas | 20115 | 2419 | 36 |
2097078 | 2097078 | 2022-01-09 | Marion | Kansas | 20115 | 2389 | 36 |
2093826 | 2093826 | 2022-01-08 | Marion | Kansas | 20115 | 2389 | 36 |
2090574 | 2090574 | 2022-01-07 | Marion | Kansas | 20115 | 2389 | 36 |
1846343 | 1846343 | 2021-10-24 | Marion | Georgia | 13197 | 961 | 36 |
1843093 | 1843093 | 2021-10-23 | Marion | Georgia | 13197 | 961 | 36 |
1839843 | 1839843 | 2021-10-22 | Marion | Georgia | 13197 | 961 | 36 |
1836594 | 1836594 | 2021-10-21 | Marion | Georgia | 13197 | 961 | 36 |
1833345 | 1833345 | 2021-10-20 | Marion | Georgia | 13197 | 961 | 36 |
1830096 | 1830096 | 2021-10-19 | Marion | Georgia | 13197 | 961 | 36 |
1826847 | 1826847 | 2021-10-18 | Marion | Georgia | 13197 | 959 | 36 |
1823598 | 1823598 | 2021-10-17 | Marion | Georgia | 13197 | 956 | 36 |
1820349 | 1820349 | 2021-10-16 | Marion | Georgia | 13197 | 956 | 36 |
1817100 | 1817100 | 2021-10-15 | Marion | Georgia | 13197 | 956 | 36 |
1702433 | 1702433 | 2021-09-09 | Marion | Texas | 48315 | 947 | 36 |
1595859 | 1595859 | 2021-08-08 | Marion | Arkansas | 5089 | 1626 | 36 |
1592610 | 1592610 | 2021-08-07 | Marion | Arkansas | 5089 | 1624 | 36 |
1589361 | 1589361 | 2021-08-06 | Marion | Arkansas | 5089 | 1609 | 36 |
1586112 | 1586112 | 2021-08-05 | Marion | Arkansas | 5089 | 1589 | 36 |
1582862 | 1582862 | 2021-08-04 | Marion | Arkansas | 5089 | 1575 | 36 |
1579612 | 1579612 | 2021-08-03 | Marion | Arkansas | 5089 | 1550 | 36 |
1200681 | 1200681 | 2021-04-08 | Marion | Kentucky | 21155 | 2219 | 36 |
1197432 | 1197432 | 2021-04-07 | Marion | Kentucky | 21155 | 2213 | 36 |
1194184 | 1194184 | 2021-04-06 | Marion | Kentucky | 21155 | 2214 | 36 |
1190934 | 1190934 | 2021-04-05 | Marion | Kentucky | 21155 | 2214 | 36 |
1187687 | 1187687 | 2021-04-04 | Marion | Kentucky | 21155 | 2214 | 36 |
1184440 | 1184440 | 2021-04-03 | Marion | Kentucky | 21155 | 2214 | 36 |
1181193 | 1181193 | 2021-04-02 | Marion | Kentucky | 21155 | 2213 | 36 |
986906 | 986906 | 2021-02-01 | Marion | Missouri | 29127 | 2586 | 36 |
987927 | 987927 | 2021-02-01 | Marion | Tennessee | 47115 | 2408 | 36 |
983659 | 983659 | 2021-01-31 | Marion | Missouri | 29127 | 2584 | 36 |
984680 | 984680 | 2021-01-31 | Marion | Tennessee | 47115 | 2406 | 36 |
980413 | 980413 | 2021-01-30 | Marion | Missouri | 29127 | 2580 | 36 |
977167 | 977167 | 2021-01-29 | Marion | Missouri | 29127 | 2578 | 36 |
973922 | 973922 | 2021-01-28 | Marion | Missouri | 29127 | 2564 | 36 |
970677 | 970677 | 2021-01-27 | Marion | Missouri | 29127 | 2570 | 36 |
967432 | 967432 | 2021-01-26 | Marion | Missouri | 29127 | 2569 | 36 |
806895 | 806895 | 2020-12-08 | Marion | Alabama | 1093 | 1585 | 36 |
803650 | 803650 | 2020-12-07 | Marion | Alabama | 1093 | 1558 | 36 |
800405 | 800405 | 2020-12-06 | Marion | Alabama | 1093 | 1537 | 36 |
797160 | 797160 | 2020-12-05 | Marion | Alabama | 1093 | 1530 | 36 |
793915 | 793915 | 2020-12-04 | Marion | Alabama | 1093 | 1502 | 36 |
790670 | 790670 | 2020-12-03 | Marion | Alabama | 1093 | 1482 | 36 |
787425 | 787425 | 2020-12-02 | Marion | Alabama | 1093 | 1461 | 36 |
784181 | 784181 | 2020-12-01 | Marion | Alabama | 1093 | 1447 | 36 |
780936 | 780936 | 2020-11-30 | Marion | Alabama | 1093 | 1436 | 36 |
777690 | 777690 | 2020-11-29 | Marion | Alabama | 1093 | 1413 | 36 |
774445 | 774445 | 2020-11-28 | Marion | Alabama | 1093 | 1402 | 36 |
771200 | 771200 | 2020-11-27 | Marion | Alabama | 1093 | 1379 | 36 |
767954 | 767954 | 2020-11-26 | Marion | Alabama | 1093 | 1371 | 36 |
643824 | 643824 | 2020-10-18 | Marion | South Carolina | 45067 | 1056 | 36 |
640576 | 640576 | 2020-10-17 | Marion | South Carolina | 45067 | 1048 | 36 |
637330 | 637330 | 2020-10-16 | Marion | South Carolina | 45067 | 1042 | 36 |
581225 | 581225 | 2020-09-29 | Marion | Mississippi | 28091 | 871 | 36 |
276531 | 276531 | 2020-06-26 | Marion | Ohio | 39101 | 2717 | 36 |
273384 | 273384 | 2020-06-25 | Marion | Ohio | 39101 | 2717 | 36 |
270380 | 270380 | 2020-06-24 | Marion | Oregon | 41047 | 1378 | 36 |
31390 | 31390 | 2020-04-04 | Marion | Indiana | 18097 | 1572 | 36 |
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);