ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Saline" and fips = 29195 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
29635 | 29635 | 2020-04-03 | Saline | Missouri | 29195 | 2 | 0 |
32016 | 32016 | 2020-04-04 | Saline | Missouri | 29195 | 2 | 0 |
34444 | 34444 | 2020-04-05 | Saline | Missouri | 29195 | 3 | 0 |
36910 | 36910 | 2020-04-06 | Saline | Missouri | 29195 | 3 | 0 |
39425 | 39425 | 2020-04-07 | Saline | Missouri | 29195 | 5 | 0 |
41979 | 41979 | 2020-04-08 | Saline | Missouri | 29195 | 7 | 0 |
44556 | 44556 | 2020-04-09 | Saline | Missouri | 29195 | 11 | 0 |
47165 | 47165 | 2020-04-10 | Saline | Missouri | 29195 | 18 | 0 |
49813 | 49813 | 2020-04-11 | Saline | Missouri | 29195 | 22 | 0 |
52486 | 52486 | 2020-04-12 | Saline | Missouri | 29195 | 22 | 0 |
55168 | 55168 | 2020-04-13 | Saline | Missouri | 29195 | 23 | 0 |
57866 | 57866 | 2020-04-14 | Saline | Missouri | 29195 | 35 | 0 |
60580 | 60580 | 2020-04-15 | Saline | Missouri | 29195 | 44 | 0 |
63302 | 63302 | 2020-04-16 | Saline | Missouri | 29195 | 49 | 0 |
66042 | 66042 | 2020-04-17 | Saline | Missouri | 29195 | 51 | 0 |
68796 | 68796 | 2020-04-18 | Saline | Missouri | 29195 | 51 | 0 |
71563 | 71563 | 2020-04-19 | Saline | Missouri | 29195 | 54 | 0 |
74336 | 74336 | 2020-04-20 | Saline | Missouri | 29195 | 54 | 0 |
77117 | 77117 | 2020-04-21 | Saline | Missouri | 29195 | 54 | 0 |
79904 | 79904 | 2020-04-22 | Saline | Missouri | 29195 | 55 | 0 |
82700 | 82700 | 2020-04-23 | Saline | Missouri | 29195 | 81 | 0 |
85504 | 85504 | 2020-04-24 | Saline | Missouri | 29195 | 139 | 0 |
88314 | 88314 | 2020-04-25 | Saline | Missouri | 29195 | 143 | 0 |
91130 | 91130 | 2020-04-26 | Saline | Missouri | 29195 | 159 | 0 |
93951 | 93951 | 2020-04-27 | Saline | Missouri | 29195 | 168 | 0 |
96787 | 96787 | 2020-04-28 | Saline | Missouri | 29195 | 170 | 0 |
99633 | 99633 | 2020-04-29 | Saline | Missouri | 29195 | 182 | 0 |
102485 | 102485 | 2020-04-30 | Saline | Missouri | 29195 | 184 | 0 |
105346 | 105346 | 2020-05-01 | Saline | Missouri | 29195 | 190 | 0 |
108211 | 108211 | 2020-05-02 | Saline | Missouri | 29195 | 193 | 0 |
111083 | 111083 | 2020-05-03 | Saline | Missouri | 29195 | 199 | 0 |
113962 | 113962 | 2020-05-04 | Saline | Missouri | 29195 | 204 | 0 |
116844 | 116844 | 2020-05-05 | Saline | Missouri | 29195 | 205 | 0 |
119804 | 119804 | 2020-05-06 | Saline | Missouri | 29195 | 208 | 0 |
122778 | 122778 | 2020-05-07 | Saline | Missouri | 29195 | 208 | 0 |
125760 | 125760 | 2020-05-08 | Saline | Missouri | 29195 | 214 | 0 |
128748 | 128748 | 2020-05-09 | Saline | Missouri | 29195 | 215 | 0 |
131738 | 131738 | 2020-05-10 | Saline | Missouri | 29195 | 219 | 0 |
134729 | 134729 | 2020-05-11 | Saline | Missouri | 29195 | 219 | 0 |
137719 | 137719 | 2020-05-12 | Saline | Missouri | 29195 | 219 | 0 |
140713 | 140713 | 2020-05-13 | Saline | Missouri | 29195 | 224 | 0 |
143708 | 143708 | 2020-05-14 | Saline | Missouri | 29195 | 224 | 0 |
146709 | 146709 | 2020-05-15 | Saline | Missouri | 29195 | 225 | 0 |
149714 | 149714 | 2020-05-16 | Saline | Missouri | 29195 | 241 | 0 |
152725 | 152725 | 2020-05-17 | Saline | Missouri | 29195 | 246 | 0 |
155739 | 155739 | 2020-05-18 | Saline | Missouri | 29195 | 249 | 0 |
158757 | 158757 | 2020-05-19 | Saline | Missouri | 29195 | 253 | 0 |
161783 | 161783 | 2020-05-20 | Saline | Missouri | 29195 | 256 | 0 |
164812 | 164812 | 2020-05-21 | Saline | Missouri | 29195 | 256 | 0 |
167848 | 167848 | 2020-05-22 | Saline | Missouri | 29195 | 260 | 0 |
170887 | 170887 | 2020-05-23 | Saline | Missouri | 29195 | 263 | 0 |
173929 | 173929 | 2020-05-24 | Saline | Missouri | 29195 | 265 | 0 |
176972 | 176972 | 2020-05-25 | Saline | Missouri | 29195 | 267 | 0 |
180016 | 180016 | 2020-05-26 | Saline | Missouri | 29195 | 267 | 0 |
183063 | 183063 | 2020-05-27 | Saline | Missouri | 29195 | 267 | 0 |
186119 | 186119 | 2020-05-28 | Saline | Missouri | 29195 | 267 | 2 |
189177 | 189177 | 2020-05-29 | Saline | Missouri | 29195 | 267 | 2 |
192241 | 192241 | 2020-05-30 | Saline | Missouri | 29195 | 267 | 2 |
195311 | 195311 | 2020-05-31 | Saline | Missouri | 29195 | 267 | 2 |
198382 | 198382 | 2020-06-01 | Saline | Missouri | 29195 | 268 | 2 |
201455 | 201455 | 2020-06-02 | Saline | Missouri | 29195 | 268 | 2 |
204532 | 204532 | 2020-06-03 | Saline | Missouri | 29195 | 268 | 2 |
207613 | 207613 | 2020-06-04 | Saline | Missouri | 29195 | 268 | 2 |
210694 | 210694 | 2020-06-05 | Saline | Missouri | 29195 | 268 | 2 |
213778 | 213778 | 2020-06-06 | Saline | Missouri | 29195 | 268 | 2 |
216867 | 216867 | 2020-06-07 | Saline | Missouri | 29195 | 269 | 2 |
219959 | 219959 | 2020-06-08 | Saline | Missouri | 29195 | 270 | 2 |
223054 | 223054 | 2020-06-09 | Saline | Missouri | 29195 | 270 | 3 |
226153 | 226153 | 2020-06-10 | Saline | Missouri | 29195 | 270 | 3 |
229256 | 229256 | 2020-06-11 | Saline | Missouri | 29195 | 270 | 3 |
232360 | 232360 | 2020-06-12 | Saline | Missouri | 29195 | 270 | 3 |
235466 | 235466 | 2020-06-13 | Saline | Missouri | 29195 | 271 | 4 |
238573 | 238573 | 2020-06-14 | Saline | Missouri | 29195 | 271 | 4 |
241683 | 241683 | 2020-06-15 | Saline | Missouri | 29195 | 270 | 4 |
244794 | 244794 | 2020-06-16 | Saline | Missouri | 29195 | 272 | 4 |
247907 | 247907 | 2020-06-17 | Saline | Missouri | 29195 | 274 | 4 |
251020 | 251020 | 2020-06-18 | Saline | Missouri | 29195 | 277 | 4 |
254135 | 254135 | 2020-06-19 | Saline | Missouri | 29195 | 278 | 4 |
257256 | 257256 | 2020-06-20 | Saline | Missouri | 29195 | 278 | 4 |
260382 | 260382 | 2020-06-21 | Saline | Missouri | 29195 | 278 | 4 |
263510 | 263510 | 2020-06-22 | Saline | Missouri | 29195 | 278 | 4 |
266636 | 266636 | 2020-06-23 | Saline | Missouri | 29195 | 278 | 4 |
269769 | 269769 | 2020-06-24 | Saline | Missouri | 29195 | 278 | 4 |
272908 | 272908 | 2020-06-25 | Saline | Missouri | 29195 | 282 | 4 |
276051 | 276051 | 2020-06-26 | Saline | Missouri | 29195 | 282 | 4 |
279199 | 279199 | 2020-06-27 | Saline | Missouri | 29195 | 282 | 4 |
282347 | 282347 | 2020-06-28 | Saline | Missouri | 29195 | 283 | 4 |
285492 | 285492 | 2020-06-29 | Saline | Missouri | 29195 | 283 | 4 |
288642 | 288642 | 2020-06-30 | Saline | Missouri | 29195 | 283 | 4 |
291793 | 291793 | 2020-07-01 | Saline | Missouri | 29195 | 283 | 4 |
294947 | 294947 | 2020-07-02 | Saline | Missouri | 29195 | 283 | 4 |
298105 | 298105 | 2020-07-03 | Saline | Missouri | 29195 | 284 | 4 |
301268 | 301268 | 2020-07-04 | Saline | Missouri | 29195 | 284 | 4 |
304432 | 304432 | 2020-07-05 | Saline | Missouri | 29195 | 284 | 4 |
307599 | 307599 | 2020-07-06 | Saline | Missouri | 29195 | 287 | 4 |
310767 | 310767 | 2020-07-07 | Saline | Missouri | 29195 | 290 | 4 |
313938 | 313938 | 2020-07-08 | Saline | Missouri | 29195 | 295 | 4 |
317112 | 317112 | 2020-07-09 | Saline | Missouri | 29195 | 299 | 5 |
320287 | 320287 | 2020-07-10 | Saline | Missouri | 29195 | 307 | 5 |
323466 | 323466 | 2020-07-11 | Saline | Missouri | 29195 | 309 | 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);