ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384260 | 384260 | 2020-07-30 | Jefferson | Missouri | 29099 | 1370 | 25 |
381044 | 381044 | 2020-07-29 | Jefferson | Missouri | 29099 | 1291 | 25 |
377827 | 377827 | 2020-07-28 | Jefferson | Missouri | 29099 | 1248 | 25 |
374612 | 374612 | 2020-07-27 | Jefferson | Missouri | 29099 | 1211 | 25 |
371400 | 371400 | 2020-07-26 | Jefferson | Missouri | 29099 | 1155 | 25 |
368189 | 368189 | 2020-07-25 | Jefferson | Missouri | 29099 | 1122 | 25 |
364981 | 364981 | 2020-07-24 | Jefferson | Missouri | 29099 | 1122 | 25 |
361774 | 361774 | 2020-07-23 | Jefferson | Missouri | 29099 | 1101 | 25 |
358569 | 358569 | 2020-07-22 | Jefferson | Missouri | 29099 | 1018 | 25 |
355366 | 355366 | 2020-07-21 | Jefferson | Missouri | 29099 | 1007 | 25 |
352164 | 352164 | 2020-07-20 | Jefferson | Missouri | 29099 | 969 | 25 |
348964 | 348964 | 2020-07-19 | Jefferson | Missouri | 29099 | 873 | 25 |
345763 | 345763 | 2020-07-18 | Jefferson | Missouri | 29099 | 873 | 25 |
342563 | 342563 | 2020-07-17 | Jefferson | Missouri | 29099 | 873 | 25 |
339367 | 339367 | 2020-07-16 | Jefferson | Missouri | 29099 | 857 | 25 |
336171 | 336171 | 2020-07-15 | Jefferson | Missouri | 29099 | 834 | 23 |
332978 | 332978 | 2020-07-14 | Jefferson | Missouri | 29099 | 814 | 23 |
329791 | 329791 | 2020-07-13 | Jefferson | Missouri | 29099 | 769 | 23 |
326605 | 326605 | 2020-07-12 | Jefferson | Missouri | 29099 | 743 | 23 |
323422 | 323422 | 2020-07-11 | Jefferson | Missouri | 29099 | 666 | 23 |
320243 | 320243 | 2020-07-10 | Jefferson | Missouri | 29099 | 666 | 23 |
317068 | 317068 | 2020-07-09 | Jefferson | Missouri | 29099 | 666 | 23 |
313894 | 313894 | 2020-07-08 | Jefferson | Missouri | 29099 | 631 | 23 |
310723 | 310723 | 2020-07-07 | Jefferson | Missouri | 29099 | 604 | 23 |
307555 | 307555 | 2020-07-06 | Jefferson | Missouri | 29099 | 582 | 23 |
304388 | 304388 | 2020-07-05 | Jefferson | Missouri | 29099 | 551 | 23 |
301224 | 301224 | 2020-07-04 | Jefferson | Missouri | 29099 | 551 | 23 |
298061 | 298061 | 2020-07-03 | Jefferson | Missouri | 29099 | 551 | 23 |
294903 | 294903 | 2020-07-02 | Jefferson | Missouri | 29099 | 551 | 23 |
291749 | 291749 | 2020-07-01 | Jefferson | Missouri | 29099 | 540 | 23 |
288598 | 288598 | 2020-06-30 | Jefferson | Missouri | 29099 | 539 | 21 |
285448 | 285448 | 2020-06-29 | Jefferson | Missouri | 29099 | 535 | 21 |
282303 | 282303 | 2020-06-28 | Jefferson | Missouri | 29099 | 519 | 21 |
279155 | 279155 | 2020-06-27 | Jefferson | Missouri | 29099 | 519 | 21 |
276007 | 276007 | 2020-06-26 | Jefferson | Missouri | 29099 | 519 | 21 |
272864 | 272864 | 2020-06-25 | Jefferson | Missouri | 29099 | 506 | 21 |
269726 | 269726 | 2020-06-24 | Jefferson | Missouri | 29099 | 501 | 21 |
266593 | 266593 | 2020-06-23 | Jefferson | Missouri | 29099 | 473 | 21 |
263467 | 263467 | 2020-06-22 | Jefferson | Missouri | 29099 | 465 | 21 |
260339 | 260339 | 2020-06-21 | Jefferson | Missouri | 29099 | 461 | 20 |
257213 | 257213 | 2020-06-20 | Jefferson | Missouri | 29099 | 461 | 20 |
254093 | 254093 | 2020-06-19 | Jefferson | Missouri | 29099 | 461 | 20 |
250978 | 250978 | 2020-06-18 | Jefferson | Missouri | 29099 | 456 | 20 |
247865 | 247865 | 2020-06-17 | Jefferson | Missouri | 29099 | 445 | 20 |
244752 | 244752 | 2020-06-16 | Jefferson | Missouri | 29099 | 439 | 20 |
241641 | 241641 | 2020-06-15 | Jefferson | Missouri | 29099 | 432 | 20 |
238531 | 238531 | 2020-06-14 | Jefferson | Missouri | 29099 | 428 | 20 |
235424 | 235424 | 2020-06-13 | Jefferson | Missouri | 29099 | 428 | 20 |
232318 | 232318 | 2020-06-12 | Jefferson | Missouri | 29099 | 428 | 20 |
229214 | 229214 | 2020-06-11 | Jefferson | Missouri | 29099 | 427 | 20 |
226111 | 226111 | 2020-06-10 | Jefferson | Missouri | 29099 | 411 | 20 |
223013 | 223013 | 2020-06-09 | Jefferson | Missouri | 29099 | 411 | 20 |
219918 | 219918 | 2020-06-08 | Jefferson | Missouri | 29099 | 407 | 19 |
216826 | 216826 | 2020-06-07 | Jefferson | Missouri | 29099 | 398 | 18 |
213738 | 213738 | 2020-06-06 | Jefferson | Missouri | 29099 | 398 | 18 |
210654 | 210654 | 2020-06-05 | Jefferson | Missouri | 29099 | 398 | 18 |
207573 | 207573 | 2020-06-04 | Jefferson | Missouri | 29099 | 396 | 18 |
204492 | 204492 | 2020-06-03 | Jefferson | Missouri | 29099 | 395 | 18 |
201415 | 201415 | 2020-06-02 | Jefferson | Missouri | 29099 | 390 | 18 |
198342 | 198342 | 2020-06-01 | Jefferson | Missouri | 29099 | 363 | 17 |
195271 | 195271 | 2020-05-31 | Jefferson | Missouri | 29099 | 349 | 17 |
192202 | 192202 | 2020-05-30 | Jefferson | Missouri | 29099 | 349 | 17 |
189138 | 189138 | 2020-05-29 | Jefferson | Missouri | 29099 | 349 | 16 |
186080 | 186080 | 2020-05-28 | Jefferson | Missouri | 29099 | 348 | 16 |
183024 | 183024 | 2020-05-27 | Jefferson | Missouri | 29099 | 345 | 16 |
179978 | 179978 | 2020-05-26 | Jefferson | Missouri | 29099 | 344 | 16 |
176934 | 176934 | 2020-05-25 | Jefferson | Missouri | 29099 | 337 | 16 |
173891 | 173891 | 2020-05-24 | Jefferson | Missouri | 29099 | 337 | 16 |
170849 | 170849 | 2020-05-23 | Jefferson | Missouri | 29099 | 337 | 15 |
167810 | 167810 | 2020-05-22 | Jefferson | Missouri | 29099 | 334 | 15 |
164774 | 164774 | 2020-05-21 | Jefferson | Missouri | 29099 | 333 | 15 |
161745 | 161745 | 2020-05-20 | Jefferson | Missouri | 29099 | 331 | 14 |
158719 | 158719 | 2020-05-19 | Jefferson | Missouri | 29099 | 331 | 14 |
155701 | 155701 | 2020-05-18 | Jefferson | Missouri | 29099 | 330 | 14 |
152687 | 152687 | 2020-05-17 | Jefferson | Missouri | 29099 | 328 | 14 |
149676 | 149676 | 2020-05-16 | Jefferson | Missouri | 29099 | 326 | 14 |
146671 | 146671 | 2020-05-15 | Jefferson | Missouri | 29099 | 318 | 14 |
143670 | 143670 | 2020-05-14 | Jefferson | Missouri | 29099 | 316 | 13 |
140675 | 140675 | 2020-05-13 | Jefferson | Missouri | 29099 | 314 | 13 |
137681 | 137681 | 2020-05-12 | Jefferson | Missouri | 29099 | 310 | 12 |
134691 | 134691 | 2020-05-11 | Jefferson | Missouri | 29099 | 309 | 12 |
131700 | 131700 | 2020-05-10 | Jefferson | Missouri | 29099 | 292 | 12 |
128710 | 128710 | 2020-05-09 | Jefferson | Missouri | 29099 | 292 | 12 |
125723 | 125723 | 2020-05-08 | Jefferson | Missouri | 29099 | 289 | 10 |
122741 | 122741 | 2020-05-07 | Jefferson | Missouri | 29099 | 289 | 10 |
119767 | 119767 | 2020-05-06 | Jefferson | Missouri | 29099 | 286 | 10 |
116807 | 116807 | 2020-05-05 | Jefferson | Missouri | 29099 | 278 | 10 |
113925 | 113925 | 2020-05-04 | Jefferson | Missouri | 29099 | 279 | 10 |
111046 | 111046 | 2020-05-03 | Jefferson | Missouri | 29099 | 271 | 8 |
108175 | 108175 | 2020-05-02 | Jefferson | Missouri | 29099 | 265 | 8 |
105310 | 105310 | 2020-05-01 | Jefferson | Missouri | 29099 | 261 | 8 |
102449 | 102449 | 2020-04-30 | Jefferson | Missouri | 29099 | 260 | 8 |
99597 | 99597 | 2020-04-29 | Jefferson | Missouri | 29099 | 256 | 4 |
96751 | 96751 | 2020-04-28 | Jefferson | Missouri | 29099 | 255 | 3 |
93915 | 93915 | 2020-04-27 | Jefferson | Missouri | 29099 | 249 | 3 |
91094 | 91094 | 2020-04-26 | Jefferson | Missouri | 29099 | 250 | 3 |
88278 | 88278 | 2020-04-25 | Jefferson | Missouri | 29099 | 251 | 3 |
85468 | 85468 | 2020-04-24 | Jefferson | Missouri | 29099 | 251 | 3 |
82664 | 82664 | 2020-04-23 | Jefferson | Missouri | 29099 | 240 | 3 |
79868 | 79868 | 2020-04-22 | Jefferson | Missouri | 29099 | 238 | 3 |
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);