ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 623 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Kansas · 29 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500525 | 2500525 | 2022-05-13 | Lincoln | Kansas | 20105 | 623 | 10 |
2497267 | 2497267 | 2022-05-12 | Lincoln | Kansas | 20105 | 623 | 10 |
2494009 | 2494009 | 2022-05-11 | Lincoln | Kansas | 20105 | 623 | 10 |
2490751 | 2490751 | 2022-05-10 | Lincoln | Kansas | 20105 | 623 | 10 |
2487494 | 2487494 | 2022-05-09 | Lincoln | Kansas | 20105 | 623 | 10 |
2484236 | 2484236 | 2022-05-08 | Lincoln | Kansas | 20105 | 623 | 10 |
2480978 | 2480978 | 2022-05-07 | Lincoln | Kansas | 20105 | 623 | 10 |
2477720 | 2477720 | 2022-05-06 | Lincoln | Kansas | 20105 | 623 | 10 |
2474462 | 2474462 | 2022-05-05 | Lincoln | Kansas | 20105 | 623 | 10 |
2471205 | 2471205 | 2022-05-04 | Lincoln | Kansas | 20105 | 623 | 10 |
2467949 | 2467949 | 2022-05-03 | Lincoln | Kansas | 20105 | 623 | 10 |
2464694 | 2464694 | 2022-05-02 | Lincoln | Kansas | 20105 | 623 | 10 |
2461438 | 2461438 | 2022-05-01 | Lincoln | Kansas | 20105 | 623 | 10 |
2458182 | 2458182 | 2022-04-30 | Lincoln | Kansas | 20105 | 623 | 10 |
2454926 | 2454926 | 2022-04-29 | Lincoln | Kansas | 20105 | 623 | 10 |
2269460 | 2269460 | 2022-03-03 | Morton | Kansas | 20129 | 623 | 11 |
2266207 | 2266207 | 2022-03-02 | Morton | Kansas | 20129 | 623 | 11 |
1892335 | 1892335 | 2021-11-07 | Stafford | Kansas | 20185 | 623 | 16 |
1889085 | 1889085 | 2021-11-06 | Stafford | Kansas | 20185 | 623 | 16 |
1885835 | 1885835 | 2021-11-05 | Stafford | Kansas | 20185 | 623 | 16 |
1694115 | 1694115 | 2021-09-07 | Mitchell | Kansas | 20123 | 623 | 18 |
1690866 | 1690866 | 2021-09-06 | Mitchell | Kansas | 20123 | 623 | 18 |
1687616 | 1687616 | 2021-09-05 | Mitchell | Kansas | 20123 | 623 | 18 |
1684366 | 1684366 | 2021-09-04 | Mitchell | Kansas | 20123 | 623 | 18 |
1681115 | 1681115 | 2021-09-03 | Mitchell | Kansas | 20123 | 623 | 18 |
1609681 | 1609681 | 2021-08-12 | Scott | Kansas | 20171 | 623 | 25 |
1606432 | 1606432 | 2021-08-11 | Scott | Kansas | 20171 | 623 | 25 |
944095 | 944095 | 2021-01-19 | Kingman | Kansas | 20095 | 623 | 10 |
940850 | 940850 | 2021-01-18 | Kingman | Kansas | 20095 | 623 | 10 |
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);