ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29169 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536002 | 536002 | 2020-09-15 | Pulaski | Missouri | 29169 | 489 | 4 |
532767 | 532767 | 2020-09-14 | Pulaski | Missouri | 29169 | 475 | 3 |
529531 | 529531 | 2020-09-13 | Pulaski | Missouri | 29169 | 460 | 3 |
526295 | 526295 | 2020-09-12 | Pulaski | Missouri | 29169 | 451 | 3 |
523059 | 523059 | 2020-09-11 | Pulaski | Missouri | 29169 | 446 | 2 |
519822 | 519822 | 2020-09-10 | Pulaski | Missouri | 29169 | 435 | 2 |
516587 | 516587 | 2020-09-09 | Pulaski | Missouri | 29169 | 435 | 2 |
513353 | 513353 | 2020-09-08 | Pulaski | Missouri | 29169 | 427 | 2 |
510121 | 510121 | 2020-09-07 | Pulaski | Missouri | 29169 | 415 | 2 |
506888 | 506888 | 2020-09-06 | Pulaski | Missouri | 29169 | 423 | 2 |
503655 | 503655 | 2020-09-05 | Pulaski | Missouri | 29169 | 419 | 2 |
500421 | 500421 | 2020-09-04 | Pulaski | Missouri | 29169 | 411 | 2 |
497187 | 497187 | 2020-09-03 | Pulaski | Missouri | 29169 | 402 | 2 |
493954 | 493954 | 2020-09-02 | Pulaski | Missouri | 29169 | 400 | 2 |
490720 | 490720 | 2020-09-01 | Pulaski | Missouri | 29169 | 389 | 2 |
487487 | 487487 | 2020-08-31 | Pulaski | Missouri | 29169 | 392 | 2 |
484253 | 484253 | 2020-08-30 | Pulaski | Missouri | 29169 | 385 | 2 |
481018 | 481018 | 2020-08-29 | Pulaski | Missouri | 29169 | 383 | 1 |
477786 | 477786 | 2020-08-28 | Pulaski | Missouri | 29169 | 374 | 1 |
474553 | 474553 | 2020-08-27 | Pulaski | Missouri | 29169 | 366 | 1 |
471321 | 471321 | 2020-08-26 | Pulaski | Missouri | 29169 | 360 | 1 |
468091 | 468091 | 2020-08-25 | Pulaski | Missouri | 29169 | 336 | 1 |
464862 | 464862 | 2020-08-24 | Pulaski | Missouri | 29169 | 330 | 1 |
461631 | 461631 | 2020-08-23 | Pulaski | Missouri | 29169 | 331 | 1 |
458404 | 458404 | 2020-08-22 | Pulaski | Missouri | 29169 | 329 | 1 |
455176 | 455176 | 2020-08-21 | Pulaski | Missouri | 29169 | 324 | 1 |
451948 | 451948 | 2020-08-20 | Pulaski | Missouri | 29169 | 304 | 1 |
448720 | 448720 | 2020-08-19 | Pulaski | Missouri | 29169 | 291 | 1 |
445494 | 445494 | 2020-08-18 | Pulaski | Missouri | 29169 | 275 | 1 |
442268 | 442268 | 2020-08-17 | Pulaski | Missouri | 29169 | 275 | 1 |
439041 | 439041 | 2020-08-16 | Pulaski | Missouri | 29169 | 273 | 1 |
435816 | 435816 | 2020-08-15 | Pulaski | Missouri | 29169 | 271 | 1 |
432590 | 432590 | 2020-08-14 | Pulaski | Missouri | 29169 | 262 | 1 |
429363 | 429363 | 2020-08-13 | Pulaski | Missouri | 29169 | 254 | 1 |
426139 | 426139 | 2020-08-12 | Pulaski | Missouri | 29169 | 249 | 1 |
422917 | 422917 | 2020-08-11 | Pulaski | Missouri | 29169 | 230 | 1 |
419695 | 419695 | 2020-08-10 | Pulaski | Missouri | 29169 | 226 | 1 |
416474 | 416474 | 2020-08-09 | Pulaski | Missouri | 29169 | 224 | 1 |
413254 | 413254 | 2020-08-08 | Pulaski | Missouri | 29169 | 197 | 1 |
410034 | 410034 | 2020-08-07 | Pulaski | Missouri | 29169 | 197 | 1 |
406814 | 406814 | 2020-08-06 | Pulaski | Missouri | 29169 | 195 | 1 |
403596 | 403596 | 2020-08-05 | Pulaski | Missouri | 29169 | 192 | 1 |
400379 | 400379 | 2020-08-04 | Pulaski | Missouri | 29169 | 187 | 1 |
397165 | 397165 | 2020-08-03 | Pulaski | Missouri | 29169 | 183 | 1 |
393949 | 393949 | 2020-08-02 | Pulaski | Missouri | 29169 | 180 | 1 |
390732 | 390732 | 2020-08-01 | Pulaski | Missouri | 29169 | 179 | 1 |
387515 | 387515 | 2020-07-31 | Pulaski | Missouri | 29169 | 178 | 1 |
384297 | 384297 | 2020-07-30 | Pulaski | Missouri | 29169 | 176 | 1 |
381081 | 381081 | 2020-07-29 | Pulaski | Missouri | 29169 | 174 | 1 |
377864 | 377864 | 2020-07-28 | Pulaski | Missouri | 29169 | 174 | 1 |
374649 | 374649 | 2020-07-27 | Pulaski | Missouri | 29169 | 172 | 1 |
371437 | 371437 | 2020-07-26 | Pulaski | Missouri | 29169 | 171 | 1 |
368226 | 368226 | 2020-07-25 | Pulaski | Missouri | 29169 | 170 | 1 |
365018 | 365018 | 2020-07-24 | Pulaski | Missouri | 29169 | 167 | 1 |
361811 | 361811 | 2020-07-23 | Pulaski | Missouri | 29169 | 164 | 1 |
358606 | 358606 | 2020-07-22 | Pulaski | Missouri | 29169 | 162 | 1 |
355403 | 355403 | 2020-07-21 | Pulaski | Missouri | 29169 | 157 | 1 |
352201 | 352201 | 2020-07-20 | Pulaski | Missouri | 29169 | 155 | 1 |
349001 | 349001 | 2020-07-19 | Pulaski | Missouri | 29169 | 155 | 1 |
345800 | 345800 | 2020-07-18 | Pulaski | Missouri | 29169 | 155 | 1 |
342600 | 342600 | 2020-07-17 | Pulaski | Missouri | 29169 | 146 | 1 |
339404 | 339404 | 2020-07-16 | Pulaski | Missouri | 29169 | 146 | 1 |
336208 | 336208 | 2020-07-15 | Pulaski | Missouri | 29169 | 146 | 1 |
333015 | 333015 | 2020-07-14 | Pulaski | Missouri | 29169 | 145 | 1 |
329828 | 329828 | 2020-07-13 | Pulaski | Missouri | 29169 | 141 | 1 |
326642 | 326642 | 2020-07-12 | Pulaski | Missouri | 29169 | 143 | 1 |
323459 | 323459 | 2020-07-11 | Pulaski | Missouri | 29169 | 140 | 1 |
320280 | 320280 | 2020-07-10 | Pulaski | Missouri | 29169 | 137 | 1 |
317105 | 317105 | 2020-07-09 | Pulaski | Missouri | 29169 | 134 | 1 |
313931 | 313931 | 2020-07-08 | Pulaski | Missouri | 29169 | 134 | 1 |
310760 | 310760 | 2020-07-07 | Pulaski | Missouri | 29169 | 130 | 1 |
307592 | 307592 | 2020-07-06 | Pulaski | Missouri | 29169 | 129 | 1 |
304425 | 304425 | 2020-07-05 | Pulaski | Missouri | 29169 | 128 | 1 |
301261 | 301261 | 2020-07-04 | Pulaski | Missouri | 29169 | 128 | 1 |
298098 | 298098 | 2020-07-03 | Pulaski | Missouri | 29169 | 127 | 1 |
294940 | 294940 | 2020-07-02 | Pulaski | Missouri | 29169 | 128 | 1 |
291786 | 291786 | 2020-07-01 | Pulaski | Missouri | 29169 | 125 | 1 |
288635 | 288635 | 2020-06-30 | Pulaski | Missouri | 29169 | 125 | 1 |
285485 | 285485 | 2020-06-29 | Pulaski | Missouri | 29169 | 120 | 1 |
282340 | 282340 | 2020-06-28 | Pulaski | Missouri | 29169 | 120 | 1 |
279192 | 279192 | 2020-06-27 | Pulaski | Missouri | 29169 | 120 | 1 |
276044 | 276044 | 2020-06-26 | Pulaski | Missouri | 29169 | 117 | 1 |
272901 | 272901 | 2020-06-25 | Pulaski | Missouri | 29169 | 116 | 1 |
269762 | 269762 | 2020-06-24 | Pulaski | Missouri | 29169 | 115 | 1 |
266629 | 266629 | 2020-06-23 | Pulaski | Missouri | 29169 | 106 | 1 |
263503 | 263503 | 2020-06-22 | Pulaski | Missouri | 29169 | 106 | 1 |
260375 | 260375 | 2020-06-21 | Pulaski | Missouri | 29169 | 106 | 1 |
257249 | 257249 | 2020-06-20 | Pulaski | Missouri | 29169 | 106 | 1 |
254128 | 254128 | 2020-06-19 | Pulaski | Missouri | 29169 | 106 | 1 |
251013 | 251013 | 2020-06-18 | Pulaski | Missouri | 29169 | 106 | 1 |
247900 | 247900 | 2020-06-17 | Pulaski | Missouri | 29169 | 106 | 1 |
244787 | 244787 | 2020-06-16 | Pulaski | Missouri | 29169 | 106 | 1 |
241676 | 241676 | 2020-06-15 | Pulaski | Missouri | 29169 | 106 | 1 |
238566 | 238566 | 2020-06-14 | Pulaski | Missouri | 29169 | 106 | 1 |
235459 | 235459 | 2020-06-13 | Pulaski | Missouri | 29169 | 106 | 1 |
232353 | 232353 | 2020-06-12 | Pulaski | Missouri | 29169 | 106 | 1 |
229249 | 229249 | 2020-06-11 | Pulaski | Missouri | 29169 | 106 | 1 |
226146 | 226146 | 2020-06-10 | Pulaski | Missouri | 29169 | 106 | 1 |
223047 | 223047 | 2020-06-09 | Pulaski | Missouri | 29169 | 39 | 1 |
219952 | 219952 | 2020-06-08 | Pulaski | Missouri | 29169 | 39 | 1 |
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);