ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 1070 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
state 1
- Kansas · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2142626 | 2142626 | 2022-01-23 | Ottawa | Kansas | 20143 | 1070 | 16 |
2139371 | 2139371 | 2022-01-22 | Ottawa | Kansas | 20143 | 1070 | 16 |
2136115 | 2136115 | 2022-01-21 | Ottawa | Kansas | 20143 | 1070 | 16 |
2074354 | 2074354 | 2022-01-02 | Stevens | Kansas | 20189 | 1070 | 17 |
2071103 | 2071103 | 2022-01-01 | Stevens | Kansas | 20189 | 1070 | 17 |
2067852 | 2067852 | 2021-12-31 | Stevens | Kansas | 20189 | 1070 | 17 |
2064601 | 2064601 | 2021-12-30 | Stevens | Kansas | 20189 | 1070 | 17 |
2061351 | 2061351 | 2021-12-29 | Stevens | Kansas | 20189 | 1070 | 17 |
1807812 | 1807812 | 2021-10-12 | Kingman | Kansas | 20095 | 1070 | 20 |
1804561 | 1804561 | 2021-10-11 | Kingman | Kansas | 20095 | 1070 | 20 |
1262283 | 1262283 | 2021-04-27 | Rice | Kansas | 20159 | 1070 | 12 |
1259036 | 1259036 | 2021-04-26 | Rice | Kansas | 20159 | 1070 | 12 |
1255789 | 1255789 | 2021-04-25 | Rice | Kansas | 20159 | 1070 | 12 |
1252542 | 1252542 | 2021-04-24 | Rice | Kansas | 20159 | 1070 | 12 |
1249295 | 1249295 | 2021-04-23 | Rice | Kansas | 20159 | 1070 | 12 |
1057704 | 1057704 | 2021-02-23 | Marshall | Kansas | 20117 | 1070 | 23 |
1054458 | 1054458 | 2021-02-22 | Marshall | Kansas | 20117 | 1070 | 23 |
1051211 | 1051211 | 2021-02-21 | Marshall | Kansas | 20117 | 1070 | 23 |
1047964 | 1047964 | 2021-02-20 | Marshall | Kansas | 20117 | 1070 | 23 |
1044719 | 1044719 | 2021-02-19 | Marshall | Kansas | 20117 | 1070 | 23 |
1041474 | 1041474 | 2021-02-18 | Marshall | Kansas | 20117 | 1070 | 23 |
1038229 | 1038229 | 2021-02-17 | Marshall | Kansas | 20117 | 1070 | 23 |
1034984 | 1034984 | 2021-02-16 | Marshall | Kansas | 20117 | 1070 | 23 |
778605 | 778605 | 2020-11-29 | Norton | Kansas | 20137 | 1070 | 23 |
775360 | 775360 | 2020-11-28 | Norton | Kansas | 20137 | 1070 | 23 |
772115 | 772115 | 2020-11-27 | Norton | Kansas | 20137 | 1070 | 23 |
768870 | 768870 | 2020-11-26 | Norton | Kansas | 20137 | 1070 | 23 |
765624 | 765624 | 2020-11-25 | Norton | Kansas | 20137 | 1070 | 23 |
762321 | 762321 | 2020-11-24 | Cherokee | Kansas | 20021 | 1070 | 9 |
759076 | 759076 | 2020-11-23 | Cherokee | Kansas | 20021 | 1070 | 9 |
580680 | 580680 | 2020-09-29 | Crawford | Kansas | 20037 | 1070 | 8 |
577439 | 577439 | 2020-09-28 | Crawford | Kansas | 20037 | 1070 | 8 |
179406 | 179406 | 2020-05-26 | Leavenworth | Kansas | 20103 | 1070 | 7 |
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);