ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 91 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
785098 | 785098 | 2020-12-01 | Osborne | Kansas | 20141 | 91 | 0 |
781853 | 781853 | 2020-11-30 | Osborne | Kansas | 20141 | 91 | 0 |
739599 | 739599 | 2020-11-17 | Clark | Kansas | 20025 | 91 | 4 |
736355 | 736355 | 2020-11-16 | Clark | Kansas | 20025 | 91 | 4 |
733158 | 733158 | 2020-11-15 | Mitchell | Kansas | 20123 | 91 | 0 |
729913 | 729913 | 2020-11-14 | Mitchell | Kansas | 20123 | 91 | 0 |
726670 | 726670 | 2020-11-13 | Mitchell | Kansas | 20123 | 91 | 0 |
710455 | 710455 | 2020-11-08 | Morris | Kansas | 20127 | 91 | 0 |
707211 | 707211 | 2020-11-07 | Morris | Kansas | 20127 | 91 | 0 |
703968 | 703968 | 2020-11-06 | Morris | Kansas | 20127 | 91 | 0 |
694255 | 694255 | 2020-11-03 | Republic | Kansas | 20157 | 91 | 1 |
691012 | 691012 | 2020-11-02 | Republic | Kansas | 20157 | 91 | 1 |
665084 | 665084 | 2020-10-25 | Trego | Kansas | 20195 | 91 | 3 |
661839 | 661839 | 2020-10-24 | Trego | Kansas | 20195 | 91 | 3 |
658595 | 658595 | 2020-10-23 | Trego | Kansas | 20195 | 91 | 3 |
642280 | 642280 | 2020-10-18 | Chase | Kansas | 20017 | 91 | 1 |
639033 | 639033 | 2020-10-17 | Chase | Kansas | 20017 | 91 | 1 |
635787 | 635787 | 2020-10-16 | Chase | Kansas | 20017 | 91 | 1 |
619631 | 619631 | 2020-10-11 | Ottawa | Kansas | 20143 | 91 | 0 |
616389 | 616389 | 2020-10-10 | Ottawa | Kansas | 20143 | 91 | 0 |
613148 | 613148 | 2020-10-09 | Ottawa | Kansas | 20143 | 91 | 0 |
551508 | 551508 | 2020-09-20 | Brown | Kansas | 20013 | 91 | 3 |
551523 | 551523 | 2020-09-20 | Doniphan | Kansas | 20043 | 91 | 0 |
548269 | 548269 | 2020-09-19 | Brown | Kansas | 20013 | 91 | 3 |
548284 | 548284 | 2020-09-19 | Doniphan | Kansas | 20043 | 91 | 0 |
545031 | 545031 | 2020-09-18 | Brown | Kansas | 20013 | 91 | 3 |
545046 | 545046 | 2020-09-18 | Doniphan | Kansas | 20043 | 91 | 0 |
541809 | 541809 | 2020-09-17 | Dickinson | Kansas | 20041 | 91 | 1 |
538572 | 538572 | 2020-09-16 | Dickinson | Kansas | 20041 | 91 | 1 |
473951 | 473951 | 2020-08-27 | Scott | Kansas | 20171 | 91 | 1 |
470719 | 470719 | 2020-08-26 | Scott | Kansas | 20171 | 91 | 1 |
438399 | 438399 | 2020-08-16 | Jefferson | Kansas | 20087 | 91 | 0 |
435174 | 435174 | 2020-08-15 | Jefferson | Kansas | 20087 | 91 | 0 |
431949 | 431949 | 2020-08-14 | Jefferson | Kansas | 20087 | 91 | 0 |
250417 | 250417 | 2020-06-18 | Riley | Kansas | 20161 | 91 | 3 |
247305 | 247305 | 2020-06-17 | Riley | Kansas | 20161 | 91 | 3 |
73777 | 73777 | 2020-04-20 | Shawnee | Kansas | 20177 | 91 | 5 |
71005 | 71005 | 2020-04-19 | Shawnee | Kansas | 20177 | 91 | 5 |
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);