ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 712 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Kansas · 37 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2155664 | 2155664 | 2022-01-27 | Trego | Kansas | 20195 | 712 | 9 |
2152411 | 2152411 | 2022-01-26 | Trego | Kansas | 20195 | 712 | 9 |
1785115 | 1785115 | 2021-10-05 | Stevens | Kansas | 20189 | 712 | 12 |
1781866 | 1781866 | 2021-10-04 | Stevens | Kansas | 20189 | 712 | 12 |
1710359 | 1710359 | 2021-09-12 | Morris | Kansas | 20127 | 712 | 23 |
1707112 | 1707112 | 2021-09-11 | Morris | Kansas | 20127 | 712 | 23 |
1703864 | 1703864 | 2021-09-10 | Morris | Kansas | 20127 | 712 | 23 |
1177839 | 1177839 | 2021-04-01 | Phillips | Kansas | 20147 | 712 | 19 |
1174592 | 1174592 | 2021-03-31 | Phillips | Kansas | 20147 | 712 | 19 |
1171345 | 1171345 | 2021-03-30 | Phillips | Kansas | 20147 | 712 | 19 |
1168097 | 1168097 | 2021-03-29 | Phillips | Kansas | 20147 | 712 | 19 |
1164849 | 1164849 | 2021-03-28 | Phillips | Kansas | 20147 | 712 | 19 |
1161601 | 1161601 | 2021-03-27 | Phillips | Kansas | 20147 | 712 | 19 |
1158353 | 1158353 | 2021-03-26 | Phillips | Kansas | 20147 | 712 | 19 |
1155106 | 1155106 | 2021-03-25 | Phillips | Kansas | 20147 | 712 | 19 |
1151859 | 1151859 | 2021-03-24 | Phillips | Kansas | 20147 | 712 | 19 |
1148612 | 1148612 | 2021-03-23 | Phillips | Kansas | 20147 | 712 | 19 |
1145365 | 1145365 | 2021-03-22 | Phillips | Kansas | 20147 | 712 | 19 |
1142118 | 1142118 | 2021-03-21 | Phillips | Kansas | 20147 | 712 | 19 |
1138872 | 1138872 | 2021-03-20 | Phillips | Kansas | 20147 | 712 | 19 |
1135626 | 1135626 | 2021-03-19 | Phillips | Kansas | 20147 | 712 | 19 |
1132379 | 1132379 | 2021-03-18 | Phillips | Kansas | 20147 | 712 | 19 |
1129131 | 1129131 | 2021-03-17 | Phillips | Kansas | 20147 | 712 | 19 |
1103103 | 1103103 | 2021-03-09 | Coffey | Kansas | 20031 | 712 | 14 |
1099857 | 1099857 | 2021-03-08 | Coffey | Kansas | 20031 | 712 | 14 |
1096609 | 1096609 | 2021-03-07 | Coffey | Kansas | 20031 | 712 | 14 |
1093363 | 1093363 | 2021-03-06 | Coffey | Kansas | 20031 | 712 | 14 |
1090117 | 1090117 | 2021-03-05 | Coffey | Kansas | 20031 | 712 | 14 |
1080380 | 1080380 | 2021-03-02 | Coffey | Kansas | 20031 | 712 | 14 |
1077135 | 1077135 | 2021-03-01 | Coffey | Kansas | 20031 | 712 | 14 |
739589 | 739589 | 2020-11-17 | Atchison | Kansas | 20005 | 712 | 9 |
736345 | 736345 | 2020-11-16 | Atchison | Kansas | 20005 | 712 | 9 |
723426 | 723426 | 2020-11-12 | Miami | Kansas | 20121 | 712 | 2 |
720183 | 720183 | 2020-11-11 | Miami | Kansas | 20121 | 712 | 2 |
528851 | 528851 | 2020-09-13 | Butler | Kansas | 20015 | 712 | 4 |
525615 | 525615 | 2020-09-12 | Butler | Kansas | 20015 | 712 | 4 |
522379 | 522379 | 2020-09-11 | Butler | Kansas | 20015 | 712 | 4 |
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);