ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 20, fips = 20189 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500567 | 2500567 | 2022-05-13 | Stevens | Kansas | 20189 | 1465 | 20 |
2497309 | 2497309 | 2022-05-12 | Stevens | Kansas | 20189 | 1464 | 20 |
2494051 | 2494051 | 2022-05-11 | Stevens | Kansas | 20189 | 1464 | 20 |
2490793 | 2490793 | 2022-05-10 | Stevens | Kansas | 20189 | 1464 | 20 |
2487536 | 2487536 | 2022-05-09 | Stevens | Kansas | 20189 | 1464 | 20 |
2484278 | 2484278 | 2022-05-08 | Stevens | Kansas | 20189 | 1464 | 20 |
2481020 | 2481020 | 2022-05-07 | Stevens | Kansas | 20189 | 1464 | 20 |
2477762 | 2477762 | 2022-05-06 | Stevens | Kansas | 20189 | 1464 | 20 |
2474504 | 2474504 | 2022-05-05 | Stevens | Kansas | 20189 | 1464 | 20 |
2471247 | 2471247 | 2022-05-04 | Stevens | Kansas | 20189 | 1464 | 20 |
2467991 | 2467991 | 2022-05-03 | Stevens | Kansas | 20189 | 1464 | 20 |
2464736 | 2464736 | 2022-05-02 | Stevens | Kansas | 20189 | 1464 | 20 |
2461480 | 2461480 | 2022-05-01 | Stevens | Kansas | 20189 | 1464 | 20 |
2458224 | 2458224 | 2022-04-30 | Stevens | Kansas | 20189 | 1464 | 20 |
2454968 | 2454968 | 2022-04-29 | Stevens | Kansas | 20189 | 1464 | 20 |
2451712 | 2451712 | 2022-04-28 | Stevens | Kansas | 20189 | 1463 | 20 |
2448456 | 2448456 | 2022-04-27 | Stevens | Kansas | 20189 | 1463 | 20 |
2445200 | 2445200 | 2022-04-26 | Stevens | Kansas | 20189 | 1463 | 20 |
2441944 | 2441944 | 2022-04-25 | Stevens | Kansas | 20189 | 1463 | 20 |
2438688 | 2438688 | 2022-04-24 | Stevens | Kansas | 20189 | 1463 | 20 |
2435432 | 2435432 | 2022-04-23 | Stevens | Kansas | 20189 | 1463 | 20 |
2432176 | 2432176 | 2022-04-22 | Stevens | Kansas | 20189 | 1463 | 20 |
2428920 | 2428920 | 2022-04-21 | Stevens | Kansas | 20189 | 1463 | 20 |
2425664 | 2425664 | 2022-04-20 | Stevens | Kansas | 20189 | 1463 | 20 |
2422408 | 2422408 | 2022-04-19 | Stevens | Kansas | 20189 | 1463 | 20 |
2419152 | 2419152 | 2022-04-18 | Stevens | Kansas | 20189 | 1463 | 20 |
2415896 | 2415896 | 2022-04-17 | Stevens | Kansas | 20189 | 1463 | 20 |
2412640 | 2412640 | 2022-04-16 | Stevens | Kansas | 20189 | 1463 | 20 |
2409384 | 2409384 | 2022-04-15 | Stevens | Kansas | 20189 | 1463 | 20 |
2406128 | 2406128 | 2022-04-14 | Stevens | Kansas | 20189 | 1463 | 20 |
2402872 | 2402872 | 2022-04-13 | Stevens | Kansas | 20189 | 1463 | 20 |
2399618 | 2399618 | 2022-04-12 | Stevens | Kansas | 20189 | 1463 | 20 |
2396362 | 2396362 | 2022-04-11 | Stevens | Kansas | 20189 | 1463 | 20 |
2393107 | 2393107 | 2022-04-10 | Stevens | Kansas | 20189 | 1463 | 20 |
2389851 | 2389851 | 2022-04-09 | Stevens | Kansas | 20189 | 1463 | 20 |
2386595 | 2386595 | 2022-04-08 | Stevens | Kansas | 20189 | 1463 | 20 |
2383341 | 2383341 | 2022-04-07 | Stevens | Kansas | 20189 | 1461 | 20 |
2380086 | 2380086 | 2022-04-06 | Stevens | Kansas | 20189 | 1461 | 20 |
2376831 | 2376831 | 2022-04-05 | Stevens | Kansas | 20189 | 1461 | 20 |
2373579 | 2373579 | 2022-04-04 | Stevens | Kansas | 20189 | 1461 | 20 |
2370326 | 2370326 | 2022-04-03 | Stevens | Kansas | 20189 | 1461 | 20 |
2367073 | 2367073 | 2022-04-02 | Stevens | Kansas | 20189 | 1461 | 20 |
2363820 | 2363820 | 2022-04-01 | Stevens | Kansas | 20189 | 1461 | 20 |
2360566 | 2360566 | 2022-03-31 | Stevens | Kansas | 20189 | 1462 | 20 |
2357312 | 2357312 | 2022-03-30 | Stevens | Kansas | 20189 | 1462 | 20 |
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);