ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
722 rows where fips = 20033 and state = "Kansas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
167209 | 167209 | 2020-05-22 | Comanche | Kansas | 20033 | 1 | 0 |
170247 | 170247 | 2020-05-23 | Comanche | Kansas | 20033 | 1 | 0 |
173288 | 173288 | 2020-05-24 | Comanche | Kansas | 20033 | 1 | 0 |
176332 | 176332 | 2020-05-25 | Comanche | Kansas | 20033 | 1 | 0 |
179376 | 179376 | 2020-05-26 | Comanche | Kansas | 20033 | 1 | 0 |
182421 | 182421 | 2020-05-27 | Comanche | Kansas | 20033 | 1 | 0 |
185475 | 185475 | 2020-05-28 | Comanche | Kansas | 20033 | 1 | 0 |
188533 | 188533 | 2020-05-29 | Comanche | Kansas | 20033 | 2 | 0 |
191597 | 191597 | 2020-05-30 | Comanche | Kansas | 20033 | 2 | 0 |
194665 | 194665 | 2020-05-31 | Comanche | Kansas | 20033 | 2 | 0 |
197735 | 197735 | 2020-06-01 | Comanche | Kansas | 20033 | 2 | 0 |
200807 | 200807 | 2020-06-02 | Comanche | Kansas | 20033 | 2 | 0 |
203883 | 203883 | 2020-06-03 | Comanche | Kansas | 20033 | 2 | 0 |
206964 | 206964 | 2020-06-04 | Comanche | Kansas | 20033 | 2 | 0 |
210045 | 210045 | 2020-06-05 | Comanche | Kansas | 20033 | 2 | 0 |
213130 | 213130 | 2020-06-06 | Comanche | Kansas | 20033 | 2 | 0 |
216217 | 216217 | 2020-06-07 | Comanche | Kansas | 20033 | 2 | 0 |
219309 | 219309 | 2020-06-08 | Comanche | Kansas | 20033 | 2 | 0 |
222404 | 222404 | 2020-06-09 | Comanche | Kansas | 20033 | 2 | 0 |
225499 | 225499 | 2020-06-10 | Comanche | Kansas | 20033 | 2 | 0 |
228601 | 228601 | 2020-06-11 | Comanche | Kansas | 20033 | 2 | 0 |
231704 | 231704 | 2020-06-12 | Comanche | Kansas | 20033 | 2 | 0 |
234810 | 234810 | 2020-06-13 | Comanche | Kansas | 20033 | 2 | 0 |
237917 | 237917 | 2020-06-14 | Comanche | Kansas | 20033 | 2 | 0 |
241026 | 241026 | 2020-06-15 | Comanche | Kansas | 20033 | 2 | 0 |
244137 | 244137 | 2020-06-16 | Comanche | Kansas | 20033 | 2 | 0 |
247250 | 247250 | 2020-06-17 | Comanche | Kansas | 20033 | 2 | 0 |
250362 | 250362 | 2020-06-18 | Comanche | Kansas | 20033 | 2 | 0 |
253477 | 253477 | 2020-06-19 | Comanche | Kansas | 20033 | 2 | 0 |
256597 | 256597 | 2020-06-20 | Comanche | Kansas | 20033 | 2 | 0 |
259723 | 259723 | 2020-06-21 | Comanche | Kansas | 20033 | 2 | 0 |
262850 | 262850 | 2020-06-22 | Comanche | Kansas | 20033 | 2 | 0 |
265978 | 265978 | 2020-06-23 | Comanche | Kansas | 20033 | 2 | 0 |
269108 | 269108 | 2020-06-24 | Comanche | Kansas | 20033 | 2 | 0 |
272245 | 272245 | 2020-06-25 | Comanche | Kansas | 20033 | 2 | 0 |
275387 | 275387 | 2020-06-26 | Comanche | Kansas | 20033 | 2 | 0 |
278535 | 278535 | 2020-06-27 | Comanche | Kansas | 20033 | 2 | 0 |
281683 | 281683 | 2020-06-28 | Comanche | Kansas | 20033 | 2 | 0 |
284828 | 284828 | 2020-06-29 | Comanche | Kansas | 20033 | 2 | 0 |
287977 | 287977 | 2020-06-30 | Comanche | Kansas | 20033 | 2 | 0 |
291127 | 291127 | 2020-07-01 | Comanche | Kansas | 20033 | 2 | 0 |
294281 | 294281 | 2020-07-02 | Comanche | Kansas | 20033 | 2 | 0 |
297439 | 297439 | 2020-07-03 | Comanche | Kansas | 20033 | 2 | 0 |
300601 | 300601 | 2020-07-04 | Comanche | Kansas | 20033 | 2 | 0 |
303765 | 303765 | 2020-07-05 | Comanche | Kansas | 20033 | 2 | 0 |
306930 | 306930 | 2020-07-06 | Comanche | Kansas | 20033 | 3 | 0 |
310098 | 310098 | 2020-07-07 | Comanche | Kansas | 20033 | 3 | 0 |
313268 | 313268 | 2020-07-08 | Comanche | Kansas | 20033 | 3 | 0 |
316442 | 316442 | 2020-07-09 | Comanche | Kansas | 20033 | 3 | 0 |
319615 | 319615 | 2020-07-10 | Comanche | Kansas | 20033 | 3 | 0 |
322794 | 322794 | 2020-07-11 | Comanche | Kansas | 20033 | 3 | 0 |
325975 | 325975 | 2020-07-12 | Comanche | Kansas | 20033 | 3 | 0 |
329161 | 329161 | 2020-07-13 | Comanche | Kansas | 20033 | 3 | 0 |
332348 | 332348 | 2020-07-14 | Comanche | Kansas | 20033 | 3 | 0 |
335541 | 335541 | 2020-07-15 | Comanche | Kansas | 20033 | 3 | 0 |
338737 | 338737 | 2020-07-16 | Comanche | Kansas | 20033 | 3 | 0 |
341933 | 341933 | 2020-07-17 | Comanche | Kansas | 20033 | 3 | 0 |
345133 | 345133 | 2020-07-18 | Comanche | Kansas | 20033 | 3 | 0 |
348334 | 348334 | 2020-07-19 | Comanche | Kansas | 20033 | 3 | 0 |
351534 | 351534 | 2020-07-20 | Comanche | Kansas | 20033 | 3 | 0 |
354736 | 354736 | 2020-07-21 | Comanche | Kansas | 20033 | 3 | 0 |
357938 | 357938 | 2020-07-22 | Comanche | Kansas | 20033 | 3 | 0 |
361143 | 361143 | 2020-07-23 | Comanche | Kansas | 20033 | 3 | 0 |
364350 | 364350 | 2020-07-24 | Comanche | Kansas | 20033 | 3 | 0 |
367557 | 367557 | 2020-07-25 | Comanche | Kansas | 20033 | 3 | 0 |
370767 | 370767 | 2020-07-26 | Comanche | Kansas | 20033 | 3 | 0 |
373979 | 373979 | 2020-07-27 | Comanche | Kansas | 20033 | 3 | 0 |
377194 | 377194 | 2020-07-28 | Comanche | Kansas | 20033 | 3 | 0 |
380411 | 380411 | 2020-07-29 | Comanche | Kansas | 20033 | 3 | 0 |
383628 | 383628 | 2020-07-30 | Comanche | Kansas | 20033 | 3 | 0 |
386846 | 386846 | 2020-07-31 | Comanche | Kansas | 20033 | 3 | 0 |
390063 | 390063 | 2020-08-01 | Comanche | Kansas | 20033 | 3 | 0 |
393280 | 393280 | 2020-08-02 | Comanche | Kansas | 20033 | 3 | 0 |
396496 | 396496 | 2020-08-03 | Comanche | Kansas | 20033 | 3 | 0 |
399711 | 399711 | 2020-08-04 | Comanche | Kansas | 20033 | 3 | 0 |
402928 | 402928 | 2020-08-05 | Comanche | Kansas | 20033 | 3 | 0 |
406146 | 406146 | 2020-08-06 | Comanche | Kansas | 20033 | 3 | 0 |
409365 | 409365 | 2020-08-07 | Comanche | Kansas | 20033 | 5 | 0 |
412585 | 412585 | 2020-08-08 | Comanche | Kansas | 20033 | 5 | 0 |
415805 | 415805 | 2020-08-09 | Comanche | Kansas | 20033 | 5 | 0 |
419026 | 419026 | 2020-08-10 | Comanche | Kansas | 20033 | 6 | 0 |
422249 | 422249 | 2020-08-11 | Comanche | Kansas | 20033 | 6 | 0 |
425470 | 425470 | 2020-08-12 | Comanche | Kansas | 20033 | 7 | 0 |
428694 | 428694 | 2020-08-13 | Comanche | Kansas | 20033 | 7 | 0 |
431922 | 431922 | 2020-08-14 | Comanche | Kansas | 20033 | 9 | 0 |
435147 | 435147 | 2020-08-15 | Comanche | Kansas | 20033 | 9 | 0 |
438372 | 438372 | 2020-08-16 | Comanche | Kansas | 20033 | 9 | 0 |
441599 | 441599 | 2020-08-17 | Comanche | Kansas | 20033 | 9 | 0 |
444825 | 444825 | 2020-08-18 | Comanche | Kansas | 20033 | 9 | 0 |
448052 | 448052 | 2020-08-19 | Comanche | Kansas | 20033 | 9 | 0 |
451280 | 451280 | 2020-08-20 | Comanche | Kansas | 20033 | 9 | 0 |
454508 | 454508 | 2020-08-21 | Comanche | Kansas | 20033 | 9 | 0 |
457736 | 457736 | 2020-08-22 | Comanche | Kansas | 20033 | 9 | 0 |
460963 | 460963 | 2020-08-23 | Comanche | Kansas | 20033 | 9 | 0 |
464192 | 464192 | 2020-08-24 | Comanche | Kansas | 20033 | 9 | 0 |
467421 | 467421 | 2020-08-25 | Comanche | Kansas | 20033 | 9 | 0 |
470650 | 470650 | 2020-08-26 | Comanche | Kansas | 20033 | 9 | 0 |
473882 | 473882 | 2020-08-27 | Comanche | Kansas | 20033 | 9 | 0 |
477115 | 477115 | 2020-08-28 | Comanche | Kansas | 20033 | 9 | 0 |
480348 | 480348 | 2020-08-29 | Comanche | Kansas | 20033 | 9 | 0 |
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);