ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Saline" and state = "Kansas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20333 | 20333 | 2020-03-30 | Saline | Kansas | 20169 | 1 | 0 |
22432 | 22432 | 2020-03-31 | Saline | Kansas | 20169 | 1 | 0 |
24608 | 24608 | 2020-04-01 | Saline | Kansas | 20169 | 1 | 0 |
26852 | 26852 | 2020-04-02 | Saline | Kansas | 20169 | 3 | 0 |
29168 | 29168 | 2020-04-03 | Saline | Kansas | 20169 | 4 | 0 |
31542 | 31542 | 2020-04-04 | Saline | Kansas | 20169 | 4 | 0 |
33957 | 33957 | 2020-04-05 | Saline | Kansas | 20169 | 5 | 1 |
36415 | 36415 | 2020-04-06 | Saline | Kansas | 20169 | 7 | 1 |
38918 | 38918 | 2020-04-07 | Saline | Kansas | 20169 | 7 | 1 |
41465 | 41465 | 2020-04-08 | Saline | Kansas | 20169 | 7 | 1 |
44041 | 44041 | 2020-04-09 | Saline | Kansas | 20169 | 8 | 1 |
46648 | 46648 | 2020-04-10 | Saline | Kansas | 20169 | 8 | 1 |
49285 | 49285 | 2020-04-11 | Saline | Kansas | 20169 | 8 | 1 |
51950 | 51950 | 2020-04-12 | Saline | Kansas | 20169 | 9 | 1 |
54632 | 54632 | 2020-04-13 | Saline | Kansas | 20169 | 10 | 2 |
57326 | 57326 | 2020-04-14 | Saline | Kansas | 20169 | 13 | 2 |
60034 | 60034 | 2020-04-15 | Saline | Kansas | 20169 | 13 | 2 |
62755 | 62755 | 2020-04-16 | Saline | Kansas | 20169 | 15 | 2 |
65491 | 65491 | 2020-04-17 | Saline | Kansas | 20169 | 15 | 2 |
68240 | 68240 | 2020-04-18 | Saline | Kansas | 20169 | 15 | 2 |
71001 | 71001 | 2020-04-19 | Saline | Kansas | 20169 | 15 | 2 |
73773 | 73773 | 2020-04-20 | Saline | Kansas | 20169 | 17 | 2 |
76553 | 76553 | 2020-04-21 | Saline | Kansas | 20169 | 17 | 2 |
79338 | 79338 | 2020-04-22 | Saline | Kansas | 20169 | 17 | 2 |
82134 | 82134 | 2020-04-23 | Saline | Kansas | 20169 | 17 | 2 |
84937 | 84937 | 2020-04-24 | Saline | Kansas | 20169 | 18 | 2 |
87746 | 87746 | 2020-04-25 | Saline | Kansas | 20169 | 19 | 2 |
90562 | 90562 | 2020-04-26 | Saline | Kansas | 20169 | 19 | 2 |
93383 | 93383 | 2020-04-27 | Saline | Kansas | 20169 | 19 | 2 |
96216 | 96216 | 2020-04-28 | Saline | Kansas | 20169 | 20 | 2 |
99062 | 99062 | 2020-04-29 | Saline | Kansas | 20169 | 20 | 2 |
101914 | 101914 | 2020-04-30 | Saline | Kansas | 20169 | 21 | 2 |
104775 | 104775 | 2020-05-01 | Saline | Kansas | 20169 | 21 | 2 |
107640 | 107640 | 2020-05-02 | Saline | Kansas | 20169 | 21 | 2 |
110511 | 110511 | 2020-05-03 | Saline | Kansas | 20169 | 21 | 2 |
113388 | 113388 | 2020-05-04 | Saline | Kansas | 20169 | 21 | 2 |
116270 | 116270 | 2020-05-05 | Saline | Kansas | 20169 | 21 | 2 |
119231 | 119231 | 2020-05-06 | Saline | Kansas | 20169 | 21 | 2 |
122201 | 122201 | 2020-05-07 | Saline | Kansas | 20169 | 23 | 2 |
125183 | 125183 | 2020-05-08 | Saline | Kansas | 20169 | 23 | 2 |
128171 | 128171 | 2020-05-09 | Saline | Kansas | 20169 | 23 | 2 |
131161 | 131161 | 2020-05-10 | Saline | Kansas | 20169 | 23 | 2 |
134152 | 134152 | 2020-05-11 | Saline | Kansas | 20169 | 25 | 2 |
137142 | 137142 | 2020-05-12 | Saline | Kansas | 20169 | 27 | 2 |
140135 | 140135 | 2020-05-13 | Saline | Kansas | 20169 | 27 | 2 |
143131 | 143131 | 2020-05-14 | Saline | Kansas | 20169 | 27 | 2 |
146131 | 146131 | 2020-05-15 | Saline | Kansas | 20169 | 28 | 2 |
149135 | 149135 | 2020-05-16 | Saline | Kansas | 20169 | 28 | 2 |
152146 | 152146 | 2020-05-17 | Saline | Kansas | 20169 | 28 | 2 |
155159 | 155159 | 2020-05-18 | Saline | Kansas | 20169 | 28 | 2 |
158176 | 158176 | 2020-05-19 | Saline | Kansas | 20169 | 28 | 2 |
161201 | 161201 | 2020-05-20 | Saline | Kansas | 20169 | 28 | 2 |
164230 | 164230 | 2020-05-21 | Saline | Kansas | 20169 | 28 | 2 |
167265 | 167265 | 2020-05-22 | Saline | Kansas | 20169 | 28 | 2 |
170303 | 170303 | 2020-05-23 | Saline | Kansas | 20169 | 28 | 2 |
173344 | 173344 | 2020-05-24 | Saline | Kansas | 20169 | 28 | 2 |
176388 | 176388 | 2020-05-25 | Saline | Kansas | 20169 | 28 | 2 |
179432 | 179432 | 2020-05-26 | Saline | Kansas | 20169 | 28 | 2 |
182477 | 182477 | 2020-05-27 | Saline | Kansas | 20169 | 28 | 2 |
185531 | 185531 | 2020-05-28 | Saline | Kansas | 20169 | 29 | 2 |
188589 | 188589 | 2020-05-29 | Saline | Kansas | 20169 | 29 | 2 |
191653 | 191653 | 2020-05-30 | Saline | Kansas | 20169 | 29 | 2 |
194721 | 194721 | 2020-05-31 | Saline | Kansas | 20169 | 29 | 2 |
197791 | 197791 | 2020-06-01 | Saline | Kansas | 20169 | 29 | 2 |
200863 | 200863 | 2020-06-02 | Saline | Kansas | 20169 | 30 | 2 |
203940 | 203940 | 2020-06-03 | Saline | Kansas | 20169 | 30 | 2 |
207021 | 207021 | 2020-06-04 | Saline | Kansas | 20169 | 30 | 2 |
210102 | 210102 | 2020-06-05 | Saline | Kansas | 20169 | 31 | 2 |
213187 | 213187 | 2020-06-06 | Saline | Kansas | 20169 | 31 | 2 |
216274 | 216274 | 2020-06-07 | Saline | Kansas | 20169 | 31 | 2 |
219366 | 219366 | 2020-06-08 | Saline | Kansas | 20169 | 31 | 2 |
222461 | 222461 | 2020-06-09 | Saline | Kansas | 20169 | 31 | 2 |
225556 | 225556 | 2020-06-10 | Saline | Kansas | 20169 | 32 | 2 |
228658 | 228658 | 2020-06-11 | Saline | Kansas | 20169 | 32 | 2 |
231761 | 231761 | 2020-06-12 | Saline | Kansas | 20169 | 33 | 2 |
234867 | 234867 | 2020-06-13 | Saline | Kansas | 20169 | 33 | 2 |
237974 | 237974 | 2020-06-14 | Saline | Kansas | 20169 | 33 | 2 |
241083 | 241083 | 2020-06-15 | Saline | Kansas | 20169 | 37 | 2 |
244194 | 244194 | 2020-06-16 | Saline | Kansas | 20169 | 37 | 2 |
247307 | 247307 | 2020-06-17 | Saline | Kansas | 20169 | 38 | 2 |
250419 | 250419 | 2020-06-18 | Saline | Kansas | 20169 | 38 | 2 |
253534 | 253534 | 2020-06-19 | Saline | Kansas | 20169 | 45 | 2 |
256654 | 256654 | 2020-06-20 | Saline | Kansas | 20169 | 45 | 2 |
259780 | 259780 | 2020-06-21 | Saline | Kansas | 20169 | 45 | 2 |
262907 | 262907 | 2020-06-22 | Saline | Kansas | 20169 | 50 | 2 |
266035 | 266035 | 2020-06-23 | Saline | Kansas | 20169 | 55 | 2 |
269167 | 269167 | 2020-06-24 | Saline | Kansas | 20169 | 77 | 2 |
272304 | 272304 | 2020-06-25 | Saline | Kansas | 20169 | 77 | 2 |
275447 | 275447 | 2020-06-26 | Saline | Kansas | 20169 | 98 | 2 |
278595 | 278595 | 2020-06-27 | Saline | Kansas | 20169 | 98 | 2 |
281743 | 281743 | 2020-06-28 | Saline | Kansas | 20169 | 98 | 2 |
284889 | 284889 | 2020-06-29 | Saline | Kansas | 20169 | 110 | 2 |
288038 | 288038 | 2020-06-30 | Saline | Kansas | 20169 | 110 | 2 |
291188 | 291188 | 2020-07-01 | Saline | Kansas | 20169 | 110 | 2 |
294342 | 294342 | 2020-07-02 | Saline | Kansas | 20169 | 110 | 2 |
297500 | 297500 | 2020-07-03 | Saline | Kansas | 20169 | 130 | 2 |
300662 | 300662 | 2020-07-04 | Saline | Kansas | 20169 | 145 | 2 |
303826 | 303826 | 2020-07-05 | Saline | Kansas | 20169 | 145 | 2 |
306993 | 306993 | 2020-07-06 | Saline | Kansas | 20169 | 173 | 2 |
310161 | 310161 | 2020-07-07 | Saline | Kansas | 20169 | 173 | 2 |
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);