ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
751 rows where county = "Clark" and fips = 20025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535328 | 535328 | 2020-09-15 | Clark | Kansas | 20025 | 50 | 1 |
532093 | 532093 | 2020-09-14 | Clark | Kansas | 20025 | 50 | 1 |
528856 | 528856 | 2020-09-13 | Clark | Kansas | 20025 | 49 | 1 |
525620 | 525620 | 2020-09-12 | Clark | Kansas | 20025 | 49 | 1 |
522384 | 522384 | 2020-09-11 | Clark | Kansas | 20025 | 49 | 1 |
519147 | 519147 | 2020-09-10 | Clark | Kansas | 20025 | 49 | 1 |
515912 | 515912 | 2020-09-09 | Clark | Kansas | 20025 | 49 | 1 |
512679 | 512679 | 2020-09-08 | Clark | Kansas | 20025 | 48 | 1 |
509446 | 509446 | 2020-09-07 | Clark | Kansas | 20025 | 48 | 1 |
506214 | 506214 | 2020-09-06 | Clark | Kansas | 20025 | 47 | 1 |
502980 | 502980 | 2020-09-05 | Clark | Kansas | 20025 | 47 | 1 |
499746 | 499746 | 2020-09-04 | Clark | Kansas | 20025 | 47 | 1 |
496513 | 496513 | 2020-09-03 | Clark | Kansas | 20025 | 47 | 1 |
493279 | 493279 | 2020-09-02 | Clark | Kansas | 20025 | 47 | 1 |
490046 | 490046 | 2020-09-01 | Clark | Kansas | 20025 | 47 | 1 |
486813 | 486813 | 2020-08-31 | Clark | Kansas | 20025 | 47 | 1 |
483578 | 483578 | 2020-08-30 | Clark | Kansas | 20025 | 47 | 1 |
480344 | 480344 | 2020-08-29 | Clark | Kansas | 20025 | 47 | 1 |
477111 | 477111 | 2020-08-28 | Clark | Kansas | 20025 | 47 | 1 |
473878 | 473878 | 2020-08-27 | Clark | Kansas | 20025 | 47 | 1 |
470646 | 470646 | 2020-08-26 | Clark | Kansas | 20025 | 47 | 1 |
467417 | 467417 | 2020-08-25 | Clark | Kansas | 20025 | 46 | 1 |
464188 | 464188 | 2020-08-24 | Clark | Kansas | 20025 | 46 | 1 |
460959 | 460959 | 2020-08-23 | Clark | Kansas | 20025 | 46 | 1 |
457732 | 457732 | 2020-08-22 | Clark | Kansas | 20025 | 46 | 1 |
454504 | 454504 | 2020-08-21 | Clark | Kansas | 20025 | 46 | 1 |
451276 | 451276 | 2020-08-20 | Clark | Kansas | 20025 | 46 | 1 |
448048 | 448048 | 2020-08-19 | Clark | Kansas | 20025 | 46 | 1 |
444821 | 444821 | 2020-08-18 | Clark | Kansas | 20025 | 46 | 1 |
441595 | 441595 | 2020-08-17 | Clark | Kansas | 20025 | 46 | 1 |
438368 | 438368 | 2020-08-16 | Clark | Kansas | 20025 | 45 | 1 |
435143 | 435143 | 2020-08-15 | Clark | Kansas | 20025 | 45 | 1 |
431918 | 431918 | 2020-08-14 | Clark | Kansas | 20025 | 45 | 1 |
428690 | 428690 | 2020-08-13 | Clark | Kansas | 20025 | 45 | 1 |
425466 | 425466 | 2020-08-12 | Clark | Kansas | 20025 | 45 | 1 |
422245 | 422245 | 2020-08-11 | Clark | Kansas | 20025 | 45 | 1 |
419022 | 419022 | 2020-08-10 | Clark | Kansas | 20025 | 45 | 1 |
415801 | 415801 | 2020-08-09 | Clark | Kansas | 20025 | 45 | 1 |
412581 | 412581 | 2020-08-08 | Clark | Kansas | 20025 | 45 | 1 |
409361 | 409361 | 2020-08-07 | Clark | Kansas | 20025 | 45 | 1 |
406142 | 406142 | 2020-08-06 | Clark | Kansas | 20025 | 46 | 1 |
402924 | 402924 | 2020-08-05 | Clark | Kansas | 20025 | 46 | 1 |
399707 | 399707 | 2020-08-04 | Clark | Kansas | 20025 | 44 | 1 |
396492 | 396492 | 2020-08-03 | Clark | Kansas | 20025 | 44 | 1 |
393276 | 393276 | 2020-08-02 | Clark | Kansas | 20025 | 44 | 1 |
390059 | 390059 | 2020-08-01 | Clark | Kansas | 20025 | 44 | 1 |
386842 | 386842 | 2020-07-31 | Clark | Kansas | 20025 | 44 | 1 |
383624 | 383624 | 2020-07-30 | Clark | Kansas | 20025 | 42 | 1 |
380407 | 380407 | 2020-07-29 | Clark | Kansas | 20025 | 42 | 1 |
377190 | 377190 | 2020-07-28 | Clark | Kansas | 20025 | 41 | 1 |
373975 | 373975 | 2020-07-27 | Clark | Kansas | 20025 | 41 | 1 |
370763 | 370763 | 2020-07-26 | Clark | Kansas | 20025 | 40 | 1 |
367553 | 367553 | 2020-07-25 | Clark | Kansas | 20025 | 40 | 1 |
364346 | 364346 | 2020-07-24 | Clark | Kansas | 20025 | 40 | 1 |
361139 | 361139 | 2020-07-23 | Clark | Kansas | 20025 | 38 | 1 |
357934 | 357934 | 2020-07-22 | Clark | Kansas | 20025 | 38 | 1 |
354732 | 354732 | 2020-07-21 | Clark | Kansas | 20025 | 38 | 1 |
351530 | 351530 | 2020-07-20 | Clark | Kansas | 20025 | 38 | 1 |
348330 | 348330 | 2020-07-19 | Clark | Kansas | 20025 | 36 | 1 |
345129 | 345129 | 2020-07-18 | Clark | Kansas | 20025 | 36 | 1 |
341929 | 341929 | 2020-07-17 | Clark | Kansas | 20025 | 36 | 1 |
338733 | 338733 | 2020-07-16 | Clark | Kansas | 20025 | 34 | 1 |
335537 | 335537 | 2020-07-15 | Clark | Kansas | 20025 | 34 | 1 |
332344 | 332344 | 2020-07-14 | Clark | Kansas | 20025 | 34 | 1 |
329157 | 329157 | 2020-07-13 | Clark | Kansas | 20025 | 34 | 1 |
325971 | 325971 | 2020-07-12 | Clark | Kansas | 20025 | 34 | 1 |
322790 | 322790 | 2020-07-11 | Clark | Kansas | 20025 | 34 | 1 |
319611 | 319611 | 2020-07-10 | Clark | Kansas | 20025 | 34 | 1 |
316438 | 316438 | 2020-07-09 | Clark | Kansas | 20025 | 34 | 1 |
313264 | 313264 | 2020-07-08 | Clark | Kansas | 20025 | 34 | 1 |
310094 | 310094 | 2020-07-07 | Clark | Kansas | 20025 | 34 | 1 |
306926 | 306926 | 2020-07-06 | Clark | Kansas | 20025 | 34 | 1 |
303761 | 303761 | 2020-07-05 | Clark | Kansas | 20025 | 34 | 1 |
300597 | 300597 | 2020-07-04 | Clark | Kansas | 20025 | 34 | 0 |
297435 | 297435 | 2020-07-03 | Clark | Kansas | 20025 | 34 | 0 |
294277 | 294277 | 2020-07-02 | Clark | Kansas | 20025 | 34 | 0 |
291123 | 291123 | 2020-07-01 | Clark | Kansas | 20025 | 34 | 0 |
287973 | 287973 | 2020-06-30 | Clark | Kansas | 20025 | 34 | 0 |
284824 | 284824 | 2020-06-29 | Clark | Kansas | 20025 | 34 | 0 |
281679 | 281679 | 2020-06-28 | Clark | Kansas | 20025 | 34 | 0 |
278531 | 278531 | 2020-06-27 | Clark | Kansas | 20025 | 34 | 0 |
275383 | 275383 | 2020-06-26 | Clark | Kansas | 20025 | 34 | 0 |
272241 | 272241 | 2020-06-25 | Clark | Kansas | 20025 | 34 | 0 |
269104 | 269104 | 2020-06-24 | Clark | Kansas | 20025 | 34 | 0 |
265974 | 265974 | 2020-06-23 | Clark | Kansas | 20025 | 34 | 0 |
262846 | 262846 | 2020-06-22 | Clark | Kansas | 20025 | 34 | 0 |
259719 | 259719 | 2020-06-21 | Clark | Kansas | 20025 | 34 | 0 |
256593 | 256593 | 2020-06-20 | Clark | Kansas | 20025 | 34 | 0 |
253473 | 253473 | 2020-06-19 | Clark | Kansas | 20025 | 34 | 0 |
250358 | 250358 | 2020-06-18 | Clark | Kansas | 20025 | 34 | 0 |
247246 | 247246 | 2020-06-17 | Clark | Kansas | 20025 | 34 | 0 |
244133 | 244133 | 2020-06-16 | Clark | Kansas | 20025 | 34 | 0 |
241022 | 241022 | 2020-06-15 | Clark | Kansas | 20025 | 34 | 0 |
237913 | 237913 | 2020-06-14 | Clark | Kansas | 20025 | 33 | 0 |
234806 | 234806 | 2020-06-13 | Clark | Kansas | 20025 | 33 | 0 |
231700 | 231700 | 2020-06-12 | Clark | Kansas | 20025 | 33 | 0 |
228597 | 228597 | 2020-06-11 | Clark | Kansas | 20025 | 33 | 0 |
225495 | 225495 | 2020-06-10 | Clark | Kansas | 20025 | 33 | 0 |
222400 | 222400 | 2020-06-09 | Clark | Kansas | 20025 | 33 | 0 |
219305 | 219305 | 2020-06-08 | Clark | Kansas | 20025 | 33 | 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);