ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 29037 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535934 | 535934 | 2020-09-15 | Cass | Missouri | 29037 | 1366 | 18 |
532699 | 532699 | 2020-09-14 | Cass | Missouri | 29037 | 1348 | 18 |
529463 | 529463 | 2020-09-13 | Cass | Missouri | 29037 | 1331 | 18 |
526227 | 526227 | 2020-09-12 | Cass | Missouri | 29037 | 1318 | 17 |
522991 | 522991 | 2020-09-11 | Cass | Missouri | 29037 | 1306 | 17 |
519754 | 519754 | 2020-09-10 | Cass | Missouri | 29037 | 1281 | 17 |
516519 | 516519 | 2020-09-09 | Cass | Missouri | 29037 | 1262 | 17 |
513285 | 513285 | 2020-09-08 | Cass | Missouri | 29037 | 1248 | 17 |
510053 | 510053 | 2020-09-07 | Cass | Missouri | 29037 | 1238 | 17 |
506820 | 506820 | 2020-09-06 | Cass | Missouri | 29037 | 1226 | 17 |
503587 | 503587 | 2020-09-05 | Cass | Missouri | 29037 | 1217 | 17 |
500353 | 500353 | 2020-09-04 | Cass | Missouri | 29037 | 1206 | 17 |
497119 | 497119 | 2020-09-03 | Cass | Missouri | 29037 | 1185 | 17 |
493886 | 493886 | 2020-09-02 | Cass | Missouri | 29037 | 1174 | 17 |
490652 | 490652 | 2020-09-01 | Cass | Missouri | 29037 | 1153 | 17 |
487419 | 487419 | 2020-08-31 | Cass | Missouri | 29037 | 1140 | 16 |
484185 | 484185 | 2020-08-30 | Cass | Missouri | 29037 | 1129 | 16 |
480950 | 480950 | 2020-08-29 | Cass | Missouri | 29037 | 1117 | 16 |
477718 | 477718 | 2020-08-28 | Cass | Missouri | 29037 | 1096 | 16 |
474485 | 474485 | 2020-08-27 | Cass | Missouri | 29037 | 1077 | 16 |
471253 | 471253 | 2020-08-26 | Cass | Missouri | 29037 | 1060 | 16 |
468023 | 468023 | 2020-08-25 | Cass | Missouri | 29037 | 1044 | 16 |
464794 | 464794 | 2020-08-24 | Cass | Missouri | 29037 | 1031 | 16 |
461563 | 461563 | 2020-08-23 | Cass | Missouri | 29037 | 1021 | 16 |
458336 | 458336 | 2020-08-22 | Cass | Missouri | 29037 | 1010 | 16 |
455108 | 455108 | 2020-08-21 | Cass | Missouri | 29037 | 992 | 16 |
451880 | 451880 | 2020-08-20 | Cass | Missouri | 29037 | 968 | 16 |
448652 | 448652 | 2020-08-19 | Cass | Missouri | 29037 | 952 | 16 |
445426 | 445426 | 2020-08-18 | Cass | Missouri | 29037 | 937 | 16 |
442200 | 442200 | 2020-08-17 | Cass | Missouri | 29037 | 931 | 16 |
438973 | 438973 | 2020-08-16 | Cass | Missouri | 29037 | 921 | 14 |
435748 | 435748 | 2020-08-15 | Cass | Missouri | 29037 | 909 | 14 |
432522 | 432522 | 2020-08-14 | Cass | Missouri | 29037 | 880 | 14 |
429295 | 429295 | 2020-08-13 | Cass | Missouri | 29037 | 847 | 14 |
426071 | 426071 | 2020-08-12 | Cass | Missouri | 29037 | 824 | 14 |
422849 | 422849 | 2020-08-11 | Cass | Missouri | 29037 | 811 | 14 |
419627 | 419627 | 2020-08-10 | Cass | Missouri | 29037 | 796 | 14 |
416406 | 416406 | 2020-08-09 | Cass | Missouri | 29037 | 783 | 14 |
413186 | 413186 | 2020-08-08 | Cass | Missouri | 29037 | 772 | 14 |
409966 | 409966 | 2020-08-07 | Cass | Missouri | 29037 | 768 | 14 |
406746 | 406746 | 2020-08-06 | Cass | Missouri | 29037 | 716 | 14 |
403528 | 403528 | 2020-08-05 | Cass | Missouri | 29037 | 716 | 14 |
400311 | 400311 | 2020-08-04 | Cass | Missouri | 29037 | 701 | 12 |
397097 | 397097 | 2020-08-03 | Cass | Missouri | 29037 | 687 | 12 |
393881 | 393881 | 2020-08-02 | Cass | Missouri | 29037 | 667 | 12 |
390664 | 390664 | 2020-08-01 | Cass | Missouri | 29037 | 661 | 12 |
387447 | 387447 | 2020-07-31 | Cass | Missouri | 29037 | 643 | 12 |
384229 | 384229 | 2020-07-30 | Cass | Missouri | 29037 | 602 | 12 |
381013 | 381013 | 2020-07-29 | Cass | Missouri | 29037 | 594 | 11 |
377796 | 377796 | 2020-07-28 | Cass | Missouri | 29037 | 578 | 10 |
374581 | 374581 | 2020-07-27 | Cass | Missouri | 29037 | 555 | 9 |
371369 | 371369 | 2020-07-26 | Cass | Missouri | 29037 | 543 | 9 |
368158 | 368158 | 2020-07-25 | Cass | Missouri | 29037 | 517 | 9 |
364950 | 364950 | 2020-07-24 | Cass | Missouri | 29037 | 468 | 9 |
361743 | 361743 | 2020-07-23 | Cass | Missouri | 29037 | 468 | 9 |
358538 | 358538 | 2020-07-22 | Cass | Missouri | 29037 | 440 | 9 |
355335 | 355335 | 2020-07-21 | Cass | Missouri | 29037 | 420 | 9 |
352133 | 352133 | 2020-07-20 | Cass | Missouri | 29037 | 410 | 9 |
348933 | 348933 | 2020-07-19 | Cass | Missouri | 29037 | 401 | 9 |
345732 | 345732 | 2020-07-18 | Cass | Missouri | 29037 | 386 | 9 |
342532 | 342532 | 2020-07-17 | Cass | Missouri | 29037 | 364 | 9 |
339336 | 339336 | 2020-07-16 | Cass | Missouri | 29037 | 341 | 9 |
336140 | 336140 | 2020-07-15 | Cass | Missouri | 29037 | 316 | 9 |
332947 | 332947 | 2020-07-14 | Cass | Missouri | 29037 | 300 | 9 |
329760 | 329760 | 2020-07-13 | Cass | Missouri | 29037 | 267 | 9 |
326574 | 326574 | 2020-07-12 | Cass | Missouri | 29037 | 250 | 9 |
323391 | 323391 | 2020-07-11 | Cass | Missouri | 29037 | 239 | 9 |
320212 | 320212 | 2020-07-10 | Cass | Missouri | 29037 | 227 | 9 |
317037 | 317037 | 2020-07-09 | Cass | Missouri | 29037 | 214 | 9 |
313863 | 313863 | 2020-07-08 | Cass | Missouri | 29037 | 203 | 9 |
310693 | 310693 | 2020-07-07 | Cass | Missouri | 29037 | 191 | 9 |
307525 | 307525 | 2020-07-06 | Cass | Missouri | 29037 | 185 | 9 |
304358 | 304358 | 2020-07-05 | Cass | Missouri | 29037 | 171 | 9 |
301194 | 301194 | 2020-07-04 | Cass | Missouri | 29037 | 166 | 9 |
298031 | 298031 | 2020-07-03 | Cass | Missouri | 29037 | 162 | 9 |
294873 | 294873 | 2020-07-02 | Cass | Missouri | 29037 | 156 | 9 |
291719 | 291719 | 2020-07-01 | Cass | Missouri | 29037 | 147 | 9 |
288568 | 288568 | 2020-06-30 | Cass | Missouri | 29037 | 143 | 9 |
285418 | 285418 | 2020-06-29 | Cass | Missouri | 29037 | 137 | 9 |
282273 | 282273 | 2020-06-28 | Cass | Missouri | 29037 | 134 | 9 |
279125 | 279125 | 2020-06-27 | Cass | Missouri | 29037 | 134 | 9 |
275977 | 275977 | 2020-06-26 | Cass | Missouri | 29037 | 127 | 9 |
272834 | 272834 | 2020-06-25 | Cass | Missouri | 29037 | 123 | 8 |
269696 | 269696 | 2020-06-24 | Cass | Missouri | 29037 | 119 | 8 |
266563 | 266563 | 2020-06-23 | Cass | Missouri | 29037 | 117 | 8 |
263437 | 263437 | 2020-06-22 | Cass | Missouri | 29037 | 116 | 8 |
260309 | 260309 | 2020-06-21 | Cass | Missouri | 29037 | 116 | 8 |
257183 | 257183 | 2020-06-20 | Cass | Missouri | 29037 | 116 | 8 |
254063 | 254063 | 2020-06-19 | Cass | Missouri | 29037 | 115 | 8 |
250948 | 250948 | 2020-06-18 | Cass | Missouri | 29037 | 114 | 8 |
247835 | 247835 | 2020-06-17 | Cass | Missouri | 29037 | 111 | 8 |
244722 | 244722 | 2020-06-16 | Cass | Missouri | 29037 | 115 | 8 |
241611 | 241611 | 2020-06-15 | Cass | Missouri | 29037 | 114 | 8 |
238502 | 238502 | 2020-06-14 | Cass | Missouri | 29037 | 111 | 8 |
235395 | 235395 | 2020-06-13 | Cass | Missouri | 29037 | 111 | 8 |
232289 | 232289 | 2020-06-12 | Cass | Missouri | 29037 | 111 | 8 |
229185 | 229185 | 2020-06-11 | Cass | Missouri | 29037 | 110 | 8 |
226082 | 226082 | 2020-06-10 | Cass | Missouri | 29037 | 108 | 8 |
222984 | 222984 | 2020-06-09 | Cass | Missouri | 29037 | 105 | 8 |
219889 | 219889 | 2020-06-08 | Cass | Missouri | 29037 | 104 | 8 |
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);