ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
526 rows where deaths = 34 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500475 | 2500475 | 2022-05-13 | Atchison | Kansas | 20005 | 4323 | 34 |
2500494 | 2500494 | 2022-05-13 | Doniphan | Kansas | 20043 | 2456 | 34 |
2500558 | 2500558 | 2022-05-13 | Scott | Kansas | 20171 | 1277 | 34 |
2497217 | 2497217 | 2022-05-12 | Atchison | Kansas | 20005 | 4306 | 34 |
2497236 | 2497236 | 2022-05-12 | Doniphan | Kansas | 20043 | 2451 | 34 |
2497300 | 2497300 | 2022-05-12 | Scott | Kansas | 20171 | 1275 | 34 |
2493959 | 2493959 | 2022-05-11 | Atchison | Kansas | 20005 | 4306 | 34 |
2493978 | 2493978 | 2022-05-11 | Doniphan | Kansas | 20043 | 2451 | 34 |
2494042 | 2494042 | 2022-05-11 | Scott | Kansas | 20171 | 1275 | 34 |
2490701 | 2490701 | 2022-05-10 | Atchison | Kansas | 20005 | 4306 | 34 |
2490720 | 2490720 | 2022-05-10 | Doniphan | Kansas | 20043 | 2451 | 34 |
2490784 | 2490784 | 2022-05-10 | Scott | Kansas | 20171 | 1275 | 34 |
2487444 | 2487444 | 2022-05-09 | Atchison | Kansas | 20005 | 4306 | 34 |
2487463 | 2487463 | 2022-05-09 | Doniphan | Kansas | 20043 | 2451 | 34 |
2487527 | 2487527 | 2022-05-09 | Scott | Kansas | 20171 | 1275 | 34 |
2484186 | 2484186 | 2022-05-08 | Atchison | Kansas | 20005 | 4306 | 34 |
2484205 | 2484205 | 2022-05-08 | Doniphan | Kansas | 20043 | 2451 | 34 |
2484269 | 2484269 | 2022-05-08 | Scott | Kansas | 20171 | 1275 | 34 |
2480928 | 2480928 | 2022-05-07 | Atchison | Kansas | 20005 | 4306 | 34 |
2480947 | 2480947 | 2022-05-07 | Doniphan | Kansas | 20043 | 2451 | 34 |
2481011 | 2481011 | 2022-05-07 | Scott | Kansas | 20171 | 1275 | 34 |
2477670 | 2477670 | 2022-05-06 | Atchison | Kansas | 20005 | 4306 | 34 |
2477689 | 2477689 | 2022-05-06 | Doniphan | Kansas | 20043 | 2451 | 34 |
2477753 | 2477753 | 2022-05-06 | Scott | Kansas | 20171 | 1275 | 34 |
2474412 | 2474412 | 2022-05-05 | Atchison | Kansas | 20005 | 4297 | 34 |
2474431 | 2474431 | 2022-05-05 | Doniphan | Kansas | 20043 | 2447 | 34 |
2474495 | 2474495 | 2022-05-05 | Scott | Kansas | 20171 | 1275 | 34 |
2471155 | 2471155 | 2022-05-04 | Atchison | Kansas | 20005 | 4297 | 34 |
2471174 | 2471174 | 2022-05-04 | Doniphan | Kansas | 20043 | 2447 | 34 |
2471238 | 2471238 | 2022-05-04 | Scott | Kansas | 20171 | 1275 | 34 |
2467899 | 2467899 | 2022-05-03 | Atchison | Kansas | 20005 | 4297 | 34 |
2467918 | 2467918 | 2022-05-03 | Doniphan | Kansas | 20043 | 2447 | 34 |
2467982 | 2467982 | 2022-05-03 | Scott | Kansas | 20171 | 1275 | 34 |
2464644 | 2464644 | 2022-05-02 | Atchison | Kansas | 20005 | 4297 | 34 |
2464663 | 2464663 | 2022-05-02 | Doniphan | Kansas | 20043 | 2447 | 34 |
2464727 | 2464727 | 2022-05-02 | Scott | Kansas | 20171 | 1275 | 34 |
2461388 | 2461388 | 2022-05-01 | Atchison | Kansas | 20005 | 4297 | 34 |
2461407 | 2461407 | 2022-05-01 | Doniphan | Kansas | 20043 | 2447 | 34 |
2461471 | 2461471 | 2022-05-01 | Scott | Kansas | 20171 | 1275 | 34 |
2458132 | 2458132 | 2022-04-30 | Atchison | Kansas | 20005 | 4297 | 34 |
2458151 | 2458151 | 2022-04-30 | Doniphan | Kansas | 20043 | 2447 | 34 |
2458215 | 2458215 | 2022-04-30 | Scott | Kansas | 20171 | 1275 | 34 |
2454876 | 2454876 | 2022-04-29 | Atchison | Kansas | 20005 | 4297 | 34 |
2454895 | 2454895 | 2022-04-29 | Doniphan | Kansas | 20043 | 2447 | 34 |
2454959 | 2454959 | 2022-04-29 | Scott | Kansas | 20171 | 1275 | 34 |
2451620 | 2451620 | 2022-04-28 | Atchison | Kansas | 20005 | 4289 | 34 |
2451639 | 2451639 | 2022-04-28 | Doniphan | Kansas | 20043 | 2445 | 34 |
2451703 | 2451703 | 2022-04-28 | Scott | Kansas | 20171 | 1274 | 34 |
2448364 | 2448364 | 2022-04-27 | Atchison | Kansas | 20005 | 4289 | 34 |
2448383 | 2448383 | 2022-04-27 | Doniphan | Kansas | 20043 | 2445 | 34 |
2448447 | 2448447 | 2022-04-27 | Scott | Kansas | 20171 | 1274 | 34 |
2445108 | 2445108 | 2022-04-26 | Atchison | Kansas | 20005 | 4289 | 34 |
2445127 | 2445127 | 2022-04-26 | Doniphan | Kansas | 20043 | 2445 | 34 |
2445191 | 2445191 | 2022-04-26 | Scott | Kansas | 20171 | 1274 | 34 |
2441852 | 2441852 | 2022-04-25 | Atchison | Kansas | 20005 | 4289 | 34 |
2441871 | 2441871 | 2022-04-25 | Doniphan | Kansas | 20043 | 2445 | 34 |
2441935 | 2441935 | 2022-04-25 | Scott | Kansas | 20171 | 1274 | 34 |
2438596 | 2438596 | 2022-04-24 | Atchison | Kansas | 20005 | 4289 | 34 |
2438615 | 2438615 | 2022-04-24 | Doniphan | Kansas | 20043 | 2445 | 34 |
2438679 | 2438679 | 2022-04-24 | Scott | Kansas | 20171 | 1274 | 34 |
2435340 | 2435340 | 2022-04-23 | Atchison | Kansas | 20005 | 4289 | 34 |
2435359 | 2435359 | 2022-04-23 | Doniphan | Kansas | 20043 | 2445 | 34 |
2435423 | 2435423 | 2022-04-23 | Scott | Kansas | 20171 | 1274 | 34 |
2432084 | 2432084 | 2022-04-22 | Atchison | Kansas | 20005 | 4289 | 34 |
2432103 | 2432103 | 2022-04-22 | Doniphan | Kansas | 20043 | 2445 | 34 |
2432167 | 2432167 | 2022-04-22 | Scott | Kansas | 20171 | 1274 | 34 |
2428828 | 2428828 | 2022-04-21 | Atchison | Kansas | 20005 | 4283 | 34 |
2428847 | 2428847 | 2022-04-21 | Doniphan | Kansas | 20043 | 2443 | 34 |
2428911 | 2428911 | 2022-04-21 | Scott | Kansas | 20171 | 1273 | 34 |
2425572 | 2425572 | 2022-04-20 | Atchison | Kansas | 20005 | 4283 | 34 |
2425591 | 2425591 | 2022-04-20 | Doniphan | Kansas | 20043 | 2443 | 34 |
2425655 | 2425655 | 2022-04-20 | Scott | Kansas | 20171 | 1273 | 34 |
2422316 | 2422316 | 2022-04-19 | Atchison | Kansas | 20005 | 4283 | 34 |
2422335 | 2422335 | 2022-04-19 | Doniphan | Kansas | 20043 | 2443 | 34 |
2422399 | 2422399 | 2022-04-19 | Scott | Kansas | 20171 | 1273 | 34 |
2419060 | 2419060 | 2022-04-18 | Atchison | Kansas | 20005 | 4283 | 34 |
2419079 | 2419079 | 2022-04-18 | Doniphan | Kansas | 20043 | 2443 | 34 |
2419143 | 2419143 | 2022-04-18 | Scott | Kansas | 20171 | 1273 | 34 |
2415804 | 2415804 | 2022-04-17 | Atchison | Kansas | 20005 | 4283 | 34 |
2415823 | 2415823 | 2022-04-17 | Doniphan | Kansas | 20043 | 2443 | 34 |
2415887 | 2415887 | 2022-04-17 | Scott | Kansas | 20171 | 1273 | 34 |
2412548 | 2412548 | 2022-04-16 | Atchison | Kansas | 20005 | 4283 | 34 |
2412567 | 2412567 | 2022-04-16 | Doniphan | Kansas | 20043 | 2443 | 34 |
2412631 | 2412631 | 2022-04-16 | Scott | Kansas | 20171 | 1273 | 34 |
2409292 | 2409292 | 2022-04-15 | Atchison | Kansas | 20005 | 4283 | 34 |
2409311 | 2409311 | 2022-04-15 | Doniphan | Kansas | 20043 | 2443 | 34 |
2409375 | 2409375 | 2022-04-15 | Scott | Kansas | 20171 | 1273 | 34 |
2406036 | 2406036 | 2022-04-14 | Atchison | Kansas | 20005 | 4278 | 34 |
2406055 | 2406055 | 2022-04-14 | Doniphan | Kansas | 20043 | 2441 | 34 |
2406119 | 2406119 | 2022-04-14 | Scott | Kansas | 20171 | 1272 | 34 |
2402780 | 2402780 | 2022-04-13 | Atchison | Kansas | 20005 | 4278 | 34 |
2402799 | 2402799 | 2022-04-13 | Doniphan | Kansas | 20043 | 2441 | 34 |
2402863 | 2402863 | 2022-04-13 | Scott | Kansas | 20171 | 1272 | 34 |
2399526 | 2399526 | 2022-04-12 | Atchison | Kansas | 20005 | 4278 | 34 |
2399545 | 2399545 | 2022-04-12 | Doniphan | Kansas | 20043 | 2441 | 34 |
2399609 | 2399609 | 2022-04-12 | Scott | Kansas | 20171 | 1272 | 34 |
2396270 | 2396270 | 2022-04-11 | Atchison | Kansas | 20005 | 4278 | 34 |
2396289 | 2396289 | 2022-04-11 | Doniphan | Kansas | 20043 | 2441 | 34 |
2396353 | 2396353 | 2022-04-11 | Scott | Kansas | 20171 | 1272 | 34 |
2393015 | 2393015 | 2022-04-10 | Atchison | Kansas | 20005 | 4278 | 34 |
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);