ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,476 rows where county = "Barton" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
272233 | 272233 | 2020-06-25 | Barton | Kansas | 20009 | 55 | 2 |
272821 | 272821 | 2020-06-25 | Barton | Missouri | 29011 | 21 | 0 |
275375 | 275375 | 2020-06-26 | Barton | Kansas | 20009 | 55 | 2 |
275964 | 275964 | 2020-06-26 | Barton | Missouri | 29011 | 21 | 0 |
278523 | 278523 | 2020-06-27 | Barton | Kansas | 20009 | 55 | 2 |
279112 | 279112 | 2020-06-27 | Barton | Missouri | 29011 | 21 | 0 |
281671 | 281671 | 2020-06-28 | Barton | Kansas | 20009 | 55 | 2 |
282260 | 282260 | 2020-06-28 | Barton | Missouri | 29011 | 22 | 0 |
284816 | 284816 | 2020-06-29 | Barton | Kansas | 20009 | 56 | 2 |
285405 | 285405 | 2020-06-29 | Barton | Missouri | 29011 | 24 | 0 |
287965 | 287965 | 2020-06-30 | Barton | Kansas | 20009 | 56 | 2 |
288555 | 288555 | 2020-06-30 | Barton | Missouri | 29011 | 25 | 0 |
291115 | 291115 | 2020-07-01 | Barton | Kansas | 20009 | 57 | 2 |
291706 | 291706 | 2020-07-01 | Barton | Missouri | 29011 | 26 | 0 |
294269 | 294269 | 2020-07-02 | Barton | Kansas | 20009 | 57 | 2 |
294860 | 294860 | 2020-07-02 | Barton | Missouri | 29011 | 26 | 0 |
297427 | 297427 | 2020-07-03 | Barton | Kansas | 20009 | 57 | 2 |
298018 | 298018 | 2020-07-03 | Barton | Missouri | 29011 | 26 | 0 |
300589 | 300589 | 2020-07-04 | Barton | Kansas | 20009 | 57 | 2 |
301181 | 301181 | 2020-07-04 | Barton | Missouri | 29011 | 28 | 0 |
303753 | 303753 | 2020-07-05 | Barton | Kansas | 20009 | 57 | 2 |
304345 | 304345 | 2020-07-05 | Barton | Missouri | 29011 | 28 | 0 |
306918 | 306918 | 2020-07-06 | Barton | Kansas | 20009 | 57 | 2 |
307512 | 307512 | 2020-07-06 | Barton | Missouri | 29011 | 29 | 0 |
310086 | 310086 | 2020-07-07 | Barton | Kansas | 20009 | 57 | 2 |
310680 | 310680 | 2020-07-07 | Barton | Missouri | 29011 | 30 | 0 |
313256 | 313256 | 2020-07-08 | Barton | Kansas | 20009 | 58 | 2 |
313850 | 313850 | 2020-07-08 | Barton | Missouri | 29011 | 31 | 0 |
316430 | 316430 | 2020-07-09 | Barton | Kansas | 20009 | 62 | 2 |
317024 | 317024 | 2020-07-09 | Barton | Missouri | 29011 | 31 | 0 |
319603 | 319603 | 2020-07-10 | Barton | Kansas | 20009 | 63 | 2 |
320199 | 320199 | 2020-07-10 | Barton | Missouri | 29011 | 31 | 0 |
322782 | 322782 | 2020-07-11 | Barton | Kansas | 20009 | 63 | 2 |
323378 | 323378 | 2020-07-11 | Barton | Missouri | 29011 | 33 | 0 |
325963 | 325963 | 2020-07-12 | Barton | Kansas | 20009 | 63 | 2 |
326561 | 326561 | 2020-07-12 | Barton | Missouri | 29011 | 34 | 0 |
329149 | 329149 | 2020-07-13 | Barton | Kansas | 20009 | 63 | 2 |
329747 | 329747 | 2020-07-13 | Barton | Missouri | 29011 | 34 | 0 |
332336 | 332336 | 2020-07-14 | Barton | Kansas | 20009 | 63 | 2 |
332934 | 332934 | 2020-07-14 | Barton | Missouri | 29011 | 37 | 0 |
335529 | 335529 | 2020-07-15 | Barton | Kansas | 20009 | 66 | 2 |
336127 | 336127 | 2020-07-15 | Barton | Missouri | 29011 | 41 | 0 |
338725 | 338725 | 2020-07-16 | Barton | Kansas | 20009 | 68 | 2 |
339323 | 339323 | 2020-07-16 | Barton | Missouri | 29011 | 41 | 0 |
341921 | 341921 | 2020-07-17 | Barton | Kansas | 20009 | 74 | 2 |
342519 | 342519 | 2020-07-17 | Barton | Missouri | 29011 | 42 | 0 |
345121 | 345121 | 2020-07-18 | Barton | Kansas | 20009 | 75 | 3 |
345719 | 345719 | 2020-07-18 | Barton | Missouri | 29011 | 45 | 0 |
348322 | 348322 | 2020-07-19 | Barton | Kansas | 20009 | 75 | 3 |
348920 | 348920 | 2020-07-19 | Barton | Missouri | 29011 | 48 | 0 |
351522 | 351522 | 2020-07-20 | Barton | Kansas | 20009 | 77 | 3 |
352120 | 352120 | 2020-07-20 | Barton | Missouri | 29011 | 51 | 0 |
354724 | 354724 | 2020-07-21 | Barton | Kansas | 20009 | 79 | 3 |
355322 | 355322 | 2020-07-21 | Barton | Missouri | 29011 | 51 | 0 |
357926 | 357926 | 2020-07-22 | Barton | Kansas | 20009 | 81 | 3 |
358525 | 358525 | 2020-07-22 | Barton | Missouri | 29011 | 51 | 0 |
361131 | 361131 | 2020-07-23 | Barton | Kansas | 20009 | 86 | 3 |
361730 | 361730 | 2020-07-23 | Barton | Missouri | 29011 | 52 | 0 |
364338 | 364338 | 2020-07-24 | Barton | Kansas | 20009 | 88 | 3 |
364937 | 364937 | 2020-07-24 | Barton | Missouri | 29011 | 53 | 0 |
367545 | 367545 | 2020-07-25 | Barton | Kansas | 20009 | 92 | 3 |
368145 | 368145 | 2020-07-25 | Barton | Missouri | 29011 | 52 | 0 |
370755 | 370755 | 2020-07-26 | Barton | Kansas | 20009 | 95 | 3 |
371356 | 371356 | 2020-07-26 | Barton | Missouri | 29011 | 53 | 0 |
373967 | 373967 | 2020-07-27 | Barton | Kansas | 20009 | 95 | 3 |
374568 | 374568 | 2020-07-27 | Barton | Missouri | 29011 | 55 | 0 |
377182 | 377182 | 2020-07-28 | Barton | Kansas | 20009 | 97 | 3 |
377783 | 377783 | 2020-07-28 | Barton | Missouri | 29011 | 62 | 0 |
380399 | 380399 | 2020-07-29 | Barton | Kansas | 20009 | 99 | 3 |
381000 | 381000 | 2020-07-29 | Barton | Missouri | 29011 | 62 | 0 |
383616 | 383616 | 2020-07-30 | Barton | Kansas | 20009 | 104 | 3 |
384216 | 384216 | 2020-07-30 | Barton | Missouri | 29011 | 64 | 0 |
386834 | 386834 | 2020-07-31 | Barton | Kansas | 20009 | 109 | 3 |
387434 | 387434 | 2020-07-31 | Barton | Missouri | 29011 | 65 | 0 |
390051 | 390051 | 2020-08-01 | Barton | Kansas | 20009 | 114 | 3 |
390651 | 390651 | 2020-08-01 | Barton | Missouri | 29011 | 65 | 0 |
393268 | 393268 | 2020-08-02 | Barton | Kansas | 20009 | 116 | 3 |
393868 | 393868 | 2020-08-02 | Barton | Missouri | 29011 | 65 | 0 |
396484 | 396484 | 2020-08-03 | Barton | Kansas | 20009 | 116 | 3 |
397084 | 397084 | 2020-08-03 | Barton | Missouri | 29011 | 65 | 0 |
399699 | 399699 | 2020-08-04 | Barton | Kansas | 20009 | 123 | 3 |
400298 | 400298 | 2020-08-04 | Barton | Missouri | 29011 | 66 | 0 |
402916 | 402916 | 2020-08-05 | Barton | Kansas | 20009 | 126 | 3 |
403515 | 403515 | 2020-08-05 | Barton | Missouri | 29011 | 66 | 0 |
406134 | 406134 | 2020-08-06 | Barton | Kansas | 20009 | 131 | 3 |
406733 | 406733 | 2020-08-06 | Barton | Missouri | 29011 | 66 | 0 |
409353 | 409353 | 2020-08-07 | Barton | Kansas | 20009 | 133 | 3 |
409953 | 409953 | 2020-08-07 | Barton | Missouri | 29011 | 69 | 0 |
412573 | 412573 | 2020-08-08 | Barton | Kansas | 20009 | 139 | 3 |
413173 | 413173 | 2020-08-08 | Barton | Missouri | 29011 | 69 | 0 |
415793 | 415793 | 2020-08-09 | Barton | Kansas | 20009 | 139 | 3 |
416393 | 416393 | 2020-08-09 | Barton | Missouri | 29011 | 68 | 0 |
419014 | 419014 | 2020-08-10 | Barton | Kansas | 20009 | 139 | 3 |
419614 | 419614 | 2020-08-10 | Barton | Missouri | 29011 | 69 | 0 |
422237 | 422237 | 2020-08-11 | Barton | Kansas | 20009 | 152 | 3 |
422836 | 422836 | 2020-08-11 | Barton | Missouri | 29011 | 70 | 0 |
425458 | 425458 | 2020-08-12 | Barton | Kansas | 20009 | 157 | 3 |
426058 | 426058 | 2020-08-12 | Barton | Missouri | 29011 | 70 | 0 |
428682 | 428682 | 2020-08-13 | Barton | Kansas | 20009 | 157 | 3 |
429282 | 429282 | 2020-08-13 | Barton | Missouri | 29011 | 71 | 0 |
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);