ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
139 rows where deaths = 48 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337701 | 2337701 | 2022-03-24 | Allen | Kansas | 20001 | 3953 | 48 |
2334447 | 2334447 | 2022-03-23 | Allen | Kansas | 20001 | 3953 | 48 |
2331193 | 2331193 | 2022-03-22 | Allen | Kansas | 20001 | 3953 | 48 |
2331198 | 2331198 | 2022-03-22 | Bourbon | Kansas | 20011 | 4383 | 48 |
2327941 | 2327941 | 2022-03-21 | Allen | Kansas | 20001 | 3953 | 48 |
2327946 | 2327946 | 2022-03-21 | Bourbon | Kansas | 20011 | 4383 | 48 |
2324688 | 2324688 | 2022-03-20 | Allen | Kansas | 20001 | 3952 | 48 |
2324693 | 2324693 | 2022-03-20 | Bourbon | Kansas | 20011 | 4381 | 48 |
2321434 | 2321434 | 2022-03-19 | Allen | Kansas | 20001 | 3952 | 48 |
2321439 | 2321439 | 2022-03-19 | Bourbon | Kansas | 20011 | 4381 | 48 |
2318180 | 2318180 | 2022-03-18 | Allen | Kansas | 20001 | 3952 | 48 |
2318185 | 2318185 | 2022-03-18 | Bourbon | Kansas | 20011 | 4381 | 48 |
2314932 | 2314932 | 2022-03-17 | Bourbon | Kansas | 20011 | 4383 | 48 |
2311679 | 2311679 | 2022-03-16 | Bourbon | Kansas | 20011 | 4383 | 48 |
2308426 | 2308426 | 2022-03-15 | Bourbon | Kansas | 20011 | 4383 | 48 |
2305175 | 2305175 | 2022-03-14 | Bourbon | Kansas | 20011 | 4383 | 48 |
2220635 | 2220635 | 2022-02-16 | Brown | Kansas | 20013 | 2664 | 48 |
2217384 | 2217384 | 2022-02-15 | Brown | Kansas | 20013 | 2660 | 48 |
2214133 | 2214133 | 2022-02-14 | Brown | Kansas | 20013 | 2660 | 48 |
2210881 | 2210881 | 2022-02-13 | Brown | Kansas | 20013 | 2645 | 48 |
2207628 | 2207628 | 2022-02-12 | Brown | Kansas | 20013 | 2645 | 48 |
2204375 | 2204375 | 2022-02-11 | Brown | Kansas | 20013 | 2645 | 48 |
2201122 | 2201122 | 2022-02-10 | Brown | Kansas | 20013 | 2645 | 48 |
2197868 | 2197868 | 2022-02-09 | Brown | Kansas | 20013 | 2645 | 48 |
2194614 | 2194614 | 2022-02-08 | Brown | Kansas | 20013 | 2627 | 48 |
2191360 | 2191360 | 2022-02-07 | Brown | Kansas | 20013 | 2627 | 48 |
2188107 | 2188107 | 2022-02-06 | Brown | Kansas | 20013 | 2620 | 48 |
2184854 | 2184854 | 2022-02-05 | Brown | Kansas | 20013 | 2620 | 48 |
2181602 | 2181602 | 2022-02-04 | Brown | Kansas | 20013 | 2620 | 48 |
2126359 | 2126359 | 2022-01-18 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2123107 | 2123107 | 2022-01-17 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2119855 | 2119855 | 2022-01-16 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2116603 | 2116603 | 2022-01-15 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2113352 | 2113352 | 2022-01-14 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2110100 | 2110100 | 2022-01-13 | Pottawatomie | Kansas | 20149 | 4228 | 48 |
2106849 | 2106849 | 2022-01-12 | Pottawatomie | Kansas | 20149 | 4228 | 48 |
2103598 | 2103598 | 2022-01-11 | Pottawatomie | Kansas | 20149 | 4022 | 48 |
2100347 | 2100347 | 2022-01-10 | Pottawatomie | Kansas | 20149 | 4022 | 48 |
2097096 | 2097096 | 2022-01-09 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2093844 | 2093844 | 2022-01-08 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
2090592 | 2090592 | 2022-01-07 | Pottawatomie | Kansas | 20149 | 3942 | 48 |
1856589 | 1856589 | 2021-10-27 | Seward | Kansas | 20175 | 4768 | 48 |
1778588 | 1778588 | 2021-10-03 | Neosho | Kansas | 20133 | 2451 | 48 |
1775338 | 1775338 | 2021-10-02 | Neosho | Kansas | 20133 | 2451 | 48 |
1772088 | 1772088 | 2021-10-01 | Neosho | Kansas | 20133 | 2451 | 48 |
1694084 | 1694084 | 2021-09-07 | Geary | Kansas | 20061 | 4318 | 48 |
1690835 | 1690835 | 2021-09-06 | Geary | Kansas | 20061 | 4318 | 48 |
1687585 | 1687585 | 2021-09-05 | Geary | Kansas | 20061 | 4318 | 48 |
1684335 | 1684335 | 2021-09-04 | Geary | Kansas | 20061 | 4318 | 48 |
1681084 | 1681084 | 2021-09-03 | Geary | Kansas | 20061 | 4318 | 48 |
1677836 | 1677836 | 2021-09-02 | Geary | Kansas | 20061 | 4278 | 48 |
1677866 | 1677866 | 2021-09-02 | Miami | Kansas | 20121 | 3443 | 48 |
1674589 | 1674589 | 2021-09-01 | Geary | Kansas | 20061 | 4278 | 48 |
1674619 | 1674619 | 2021-09-01 | Miami | Kansas | 20121 | 3443 | 48 |
1671340 | 1671340 | 2021-08-31 | Geary | Kansas | 20061 | 4234 | 48 |
1671370 | 1671370 | 2021-08-31 | Miami | Kansas | 20121 | 3353 | 48 |
1668093 | 1668093 | 2021-08-30 | Geary | Kansas | 20061 | 4234 | 48 |
1668123 | 1668123 | 2021-08-30 | Miami | Kansas | 20121 | 3353 | 48 |
1664846 | 1664846 | 2021-08-29 | Geary | Kansas | 20061 | 4209 | 48 |
1661598 | 1661598 | 2021-08-28 | Geary | Kansas | 20061 | 4209 | 48 |
1658350 | 1658350 | 2021-08-27 | Geary | Kansas | 20061 | 4209 | 48 |
1655102 | 1655102 | 2021-08-26 | Geary | Kansas | 20061 | 4183 | 48 |
1651855 | 1651855 | 2021-08-25 | Geary | Kansas | 20061 | 4183 | 48 |
1603118 | 1603118 | 2021-08-10 | Dickinson | Kansas | 20041 | 2023 | 48 |
1599869 | 1599869 | 2021-08-09 | Dickinson | Kansas | 20041 | 2023 | 48 |
1307661 | 1307661 | 2021-05-11 | Barton | Kansas | 20009 | 2614 | 48 |
1304415 | 1304415 | 2021-05-10 | Barton | Kansas | 20009 | 2614 | 48 |
1301168 | 1301168 | 2021-05-09 | Barton | Kansas | 20009 | 2612 | 48 |
1297921 | 1297921 | 2021-05-08 | Barton | Kansas | 20009 | 2612 | 48 |
1294675 | 1294675 | 2021-05-07 | Barton | Kansas | 20009 | 2612 | 48 |
1119368 | 1119368 | 2021-03-14 | Labette | Kansas | 20099 | 2632 | 48 |
1116121 | 1116121 | 2021-03-13 | Labette | Kansas | 20099 | 2632 | 48 |
1112875 | 1112875 | 2021-03-12 | Labette | Kansas | 20099 | 2632 | 48 |
1109629 | 1109629 | 2021-03-11 | Labette | Kansas | 20099 | 2625 | 48 |
1106383 | 1106383 | 2021-03-10 | Labette | Kansas | 20099 | 2625 | 48 |
1103137 | 1103137 | 2021-03-09 | Labette | Kansas | 20099 | 2623 | 48 |
1099891 | 1099891 | 2021-03-08 | Labette | Kansas | 20099 | 2623 | 48 |
1096643 | 1096643 | 2021-03-07 | Labette | Kansas | 20099 | 2621 | 48 |
1093397 | 1093397 | 2021-03-06 | Labette | Kansas | 20099 | 2621 | 48 |
1090151 | 1090151 | 2021-03-05 | Labette | Kansas | 20099 | 2621 | 48 |
1086906 | 1086906 | 2021-03-04 | Labette | Kansas | 20099 | 2616 | 48 |
1083660 | 1083660 | 2021-03-03 | Labette | Kansas | 20099 | 2616 | 48 |
1080414 | 1080414 | 2021-03-02 | Labette | Kansas | 20099 | 2608 | 48 |
1077169 | 1077169 | 2021-03-01 | Labette | Kansas | 20099 | 2608 | 48 |
1073901 | 1073901 | 2021-02-28 | Finney | Kansas | 20055 | 5982 | 48 |
1070655 | 1070655 | 2021-02-27 | Finney | Kansas | 20055 | 5982 | 48 |
1067410 | 1067410 | 2021-02-26 | Finney | Kansas | 20055 | 5982 | 48 |
1064165 | 1064165 | 2021-02-25 | Finney | Kansas | 20055 | 5979 | 48 |
1060920 | 1060920 | 2021-02-24 | Finney | Kansas | 20055 | 5978 | 48 |
1057674 | 1057674 | 2021-02-23 | Finney | Kansas | 20055 | 5977 | 48 |
1054428 | 1054428 | 2021-02-22 | Finney | Kansas | 20055 | 5977 | 48 |
1051181 | 1051181 | 2021-02-21 | Finney | Kansas | 20055 | 5971 | 48 |
1047934 | 1047934 | 2021-02-20 | Finney | Kansas | 20055 | 5971 | 48 |
1044689 | 1044689 | 2021-02-19 | Finney | Kansas | 20055 | 5971 | 48 |
1041444 | 1041444 | 2021-02-18 | Finney | Kansas | 20055 | 5961 | 48 |
1041468 | 1041468 | 2021-02-18 | Leavenworth | Kansas | 20103 | 6632 | 48 |
1038199 | 1038199 | 2021-02-17 | Finney | Kansas | 20055 | 5958 | 48 |
1038223 | 1038223 | 2021-02-17 | Leavenworth | Kansas | 20103 | 6632 | 48 |
1034954 | 1034954 | 2021-02-16 | Finney | Kansas | 20055 | 5946 | 48 |
1034978 | 1034978 | 2021-02-16 | Leavenworth | Kansas | 20103 | 6601 | 48 |
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);