ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where county = "Washington" and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
225570 | 225570 | 2020-06-10 | Washington | Kansas | 20201 | 1 | 0 |
228672 | 228672 | 2020-06-11 | Washington | Kansas | 20201 | 1 | 0 |
231776 | 231776 | 2020-06-12 | Washington | Kansas | 20201 | 1 | 0 |
234881 | 234881 | 2020-06-13 | Washington | Kansas | 20201 | 1 | 0 |
237988 | 237988 | 2020-06-14 | Washington | Kansas | 20201 | 1 | 0 |
241097 | 241097 | 2020-06-15 | Washington | Kansas | 20201 | 1 | 0 |
244208 | 244208 | 2020-06-16 | Washington | Kansas | 20201 | 1 | 0 |
247321 | 247321 | 2020-06-17 | Washington | Kansas | 20201 | 1 | 0 |
250433 | 250433 | 2020-06-18 | Washington | Kansas | 20201 | 1 | 0 |
253548 | 253548 | 2020-06-19 | Washington | Kansas | 20201 | 1 | 0 |
256668 | 256668 | 2020-06-20 | Washington | Kansas | 20201 | 1 | 0 |
259794 | 259794 | 2020-06-21 | Washington | Kansas | 20201 | 1 | 0 |
262923 | 262923 | 2020-06-22 | Washington | Kansas | 20201 | 1 | 0 |
266050 | 266050 | 2020-06-23 | Washington | Kansas | 20201 | 1 | 0 |
269183 | 269183 | 2020-06-24 | Washington | Kansas | 20201 | 1 | 0 |
272319 | 272319 | 2020-06-25 | Washington | Kansas | 20201 | 1 | 0 |
275462 | 275462 | 2020-06-26 | Washington | Kansas | 20201 | 1 | 0 |
278610 | 278610 | 2020-06-27 | Washington | Kansas | 20201 | 1 | 0 |
281758 | 281758 | 2020-06-28 | Washington | Kansas | 20201 | 1 | 0 |
284904 | 284904 | 2020-06-29 | Washington | Kansas | 20201 | 1 | 0 |
288053 | 288053 | 2020-06-30 | Washington | Kansas | 20201 | 1 | 0 |
291203 | 291203 | 2020-07-01 | Washington | Kansas | 20201 | 1 | 0 |
294357 | 294357 | 2020-07-02 | Washington | Kansas | 20201 | 1 | 0 |
297515 | 297515 | 2020-07-03 | Washington | Kansas | 20201 | 1 | 0 |
300677 | 300677 | 2020-07-04 | Washington | Kansas | 20201 | 1 | 0 |
303841 | 303841 | 2020-07-05 | Washington | Kansas | 20201 | 1 | 0 |
307008 | 307008 | 2020-07-06 | Washington | Kansas | 20201 | 1 | 0 |
310176 | 310176 | 2020-07-07 | Washington | Kansas | 20201 | 1 | 0 |
313346 | 313346 | 2020-07-08 | Washington | Kansas | 20201 | 1 | 0 |
316520 | 316520 | 2020-07-09 | Washington | Kansas | 20201 | 1 | 0 |
319695 | 319695 | 2020-07-10 | Washington | Kansas | 20201 | 1 | 0 |
322874 | 322874 | 2020-07-11 | Washington | Kansas | 20201 | 1 | 0 |
326057 | 326057 | 2020-07-12 | Washington | Kansas | 20201 | 1 | 0 |
329243 | 329243 | 2020-07-13 | Washington | Kansas | 20201 | 1 | 0 |
332430 | 332430 | 2020-07-14 | Washington | Kansas | 20201 | 1 | 0 |
335623 | 335623 | 2020-07-15 | Washington | Kansas | 20201 | 1 | 0 |
338819 | 338819 | 2020-07-16 | Washington | Kansas | 20201 | 1 | 0 |
342015 | 342015 | 2020-07-17 | Washington | Kansas | 20201 | 2 | 0 |
345215 | 345215 | 2020-07-18 | Washington | Kansas | 20201 | 2 | 0 |
348416 | 348416 | 2020-07-19 | Washington | Kansas | 20201 | 2 | 0 |
351616 | 351616 | 2020-07-20 | Washington | Kansas | 20201 | 2 | 0 |
354818 | 354818 | 2020-07-21 | Washington | Kansas | 20201 | 2 | 0 |
358020 | 358020 | 2020-07-22 | Washington | Kansas | 20201 | 2 | 0 |
361225 | 361225 | 2020-07-23 | Washington | Kansas | 20201 | 2 | 0 |
364432 | 364432 | 2020-07-24 | Washington | Kansas | 20201 | 2 | 0 |
367639 | 367639 | 2020-07-25 | Washington | Kansas | 20201 | 2 | 0 |
370849 | 370849 | 2020-07-26 | Washington | Kansas | 20201 | 2 | 0 |
374061 | 374061 | 2020-07-27 | Washington | Kansas | 20201 | 2 | 0 |
377276 | 377276 | 2020-07-28 | Washington | Kansas | 20201 | 2 | 0 |
380493 | 380493 | 2020-07-29 | Washington | Kansas | 20201 | 2 | 0 |
383710 | 383710 | 2020-07-30 | Washington | Kansas | 20201 | 2 | 0 |
386928 | 386928 | 2020-07-31 | Washington | Kansas | 20201 | 2 | 0 |
390145 | 390145 | 2020-08-01 | Washington | Kansas | 20201 | 2 | 0 |
393362 | 393362 | 2020-08-02 | Washington | Kansas | 20201 | 2 | 0 |
396578 | 396578 | 2020-08-03 | Washington | Kansas | 20201 | 2 | 0 |
399793 | 399793 | 2020-08-04 | Washington | Kansas | 20201 | 2 | 0 |
409448 | 409448 | 2020-08-07 | Washington | Kansas | 20201 | 2 | 0 |
412668 | 412668 | 2020-08-08 | Washington | Kansas | 20201 | 2 | 0 |
415888 | 415888 | 2020-08-09 | Washington | Kansas | 20201 | 2 | 0 |
419109 | 419109 | 2020-08-10 | Washington | Kansas | 20201 | 2 | 0 |
422331 | 422331 | 2020-08-11 | Washington | Kansas | 20201 | 2 | 0 |
425552 | 425552 | 2020-08-12 | Washington | Kansas | 20201 | 2 | 0 |
428776 | 428776 | 2020-08-13 | Washington | Kansas | 20201 | 2 | 0 |
432004 | 432004 | 2020-08-14 | Washington | Kansas | 20201 | 2 | 0 |
435229 | 435229 | 2020-08-15 | Washington | Kansas | 20201 | 2 | 0 |
438454 | 438454 | 2020-08-16 | Washington | Kansas | 20201 | 2 | 0 |
441681 | 441681 | 2020-08-17 | Washington | Kansas | 20201 | 2 | 0 |
444907 | 444907 | 2020-08-18 | Washington | Kansas | 20201 | 2 | 0 |
448134 | 448134 | 2020-08-19 | Washington | Kansas | 20201 | 2 | 0 |
451362 | 451362 | 2020-08-20 | Washington | Kansas | 20201 | 2 | 0 |
454590 | 454590 | 2020-08-21 | Washington | Kansas | 20201 | 2 | 0 |
457818 | 457818 | 2020-08-22 | Washington | Kansas | 20201 | 2 | 0 |
461045 | 461045 | 2020-08-23 | Washington | Kansas | 20201 | 2 | 0 |
464276 | 464276 | 2020-08-24 | Washington | Kansas | 20201 | 2 | 0 |
467505 | 467505 | 2020-08-25 | Washington | Kansas | 20201 | 2 | 0 |
403010 | 403010 | 2020-08-05 | Washington | Kansas | 20201 | 3 | 0 |
406228 | 406228 | 2020-08-06 | Washington | Kansas | 20201 | 3 | 0 |
470734 | 470734 | 2020-08-26 | Washington | Kansas | 20201 | 3 | 0 |
473966 | 473966 | 2020-08-27 | Washington | Kansas | 20201 | 3 | 0 |
477199 | 477199 | 2020-08-28 | Washington | Kansas | 20201 | 5 | 0 |
480432 | 480432 | 2020-08-29 | Washington | Kansas | 20201 | 5 | 0 |
483666 | 483666 | 2020-08-30 | Washington | Kansas | 20201 | 5 | 0 |
486901 | 486901 | 2020-08-31 | Washington | Kansas | 20201 | 9 | 0 |
490134 | 490134 | 2020-09-01 | Washington | Kansas | 20201 | 9 | 0 |
493368 | 493368 | 2020-09-02 | Washington | Kansas | 20201 | 12 | 0 |
496601 | 496601 | 2020-09-03 | Washington | Kansas | 20201 | 12 | 0 |
499835 | 499835 | 2020-09-04 | Washington | Kansas | 20201 | 13 | 0 |
503068 | 503068 | 2020-09-05 | Washington | Kansas | 20201 | 13 | 0 |
506302 | 506302 | 2020-09-06 | Washington | Kansas | 20201 | 13 | 0 |
509535 | 509535 | 2020-09-07 | Washington | Kansas | 20201 | 14 | 0 |
512767 | 512767 | 2020-09-08 | Washington | Kansas | 20201 | 14 | 0 |
516000 | 516000 | 2020-09-09 | Washington | Kansas | 20201 | 14 | 0 |
519235 | 519235 | 2020-09-10 | Washington | Kansas | 20201 | 14 | 0 |
522472 | 522472 | 2020-09-11 | Washington | Kansas | 20201 | 16 | 0 |
525708 | 525708 | 2020-09-12 | Washington | Kansas | 20201 | 16 | 0 |
528944 | 528944 | 2020-09-13 | Washington | Kansas | 20201 | 16 | 0 |
532181 | 532181 | 2020-09-14 | Washington | Kansas | 20201 | 16 | 0 |
535416 | 535416 | 2020-09-15 | Washington | Kansas | 20201 | 16 | 0 |
538653 | 538653 | 2020-09-16 | Washington | Kansas | 20201 | 16 | 0 |
541889 | 541889 | 2020-09-17 | Washington | Kansas | 20201 | 16 | 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);