ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Shelby" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537019 | 537019 | 2020-09-15 | Shelby | Tennessee | 47157 | 29330 | 433 |
533783 | 533783 | 2020-09-14 | Shelby | Tennessee | 47157 | 29117 | 428 |
530548 | 530548 | 2020-09-13 | Shelby | Tennessee | 47157 | 28890 | 427 |
527311 | 527311 | 2020-09-12 | Shelby | Tennessee | 47157 | 28890 | 421 |
524075 | 524075 | 2020-09-11 | Shelby | Tennessee | 47157 | 28754 | 417 |
520839 | 520839 | 2020-09-10 | Shelby | Tennessee | 47157 | 28754 | 412 |
517603 | 517603 | 2020-09-09 | Shelby | Tennessee | 47157 | 28547 | 406 |
514368 | 514368 | 2020-09-08 | Shelby | Tennessee | 47157 | 28478 | 407 |
511135 | 511135 | 2020-09-07 | Shelby | Tennessee | 47157 | 28332 | 402 |
507902 | 507902 | 2020-09-06 | Shelby | Tennessee | 47157 | 28207 | 402 |
504670 | 504670 | 2020-09-05 | Shelby | Tennessee | 47157 | 28067 | 400 |
501436 | 501436 | 2020-09-04 | Shelby | Tennessee | 47157 | 27975 | 398 |
498202 | 498202 | 2020-09-03 | Shelby | Tennessee | 47157 | 27865 | 393 |
494969 | 494969 | 2020-09-02 | Shelby | Tennessee | 47157 | 27779 | 389 |
491735 | 491735 | 2020-09-01 | Shelby | Tennessee | 47157 | 27697 | 387 |
488502 | 488502 | 2020-08-31 | Shelby | Tennessee | 47157 | 27697 | 387 |
485269 | 485269 | 2020-08-30 | Shelby | Tennessee | 47157 | 27467 | 385 |
482034 | 482034 | 2020-08-29 | Shelby | Tennessee | 47157 | 27273 | 380 |
478800 | 478800 | 2020-08-28 | Shelby | Tennessee | 47157 | 27052 | 378 |
475567 | 475567 | 2020-08-27 | Shelby | Tennessee | 47157 | 26903 | 377 |
472334 | 472334 | 2020-08-26 | Shelby | Tennessee | 47157 | 26656 | 374 |
469102 | 469102 | 2020-08-25 | Shelby | Tennessee | 47157 | 26528 | 370 |
465873 | 465873 | 2020-08-24 | Shelby | Tennessee | 47157 | 26406 | 380 |
462644 | 462644 | 2020-08-23 | Shelby | Tennessee | 47157 | 26117 | 369 |
459416 | 459416 | 2020-08-22 | Shelby | Tennessee | 47157 | 26030 | 364 |
456188 | 456188 | 2020-08-21 | Shelby | Tennessee | 47157 | 25811 | 360 |
452960 | 452960 | 2020-08-20 | Shelby | Tennessee | 47157 | 25664 | 346 |
449732 | 449732 | 2020-08-19 | Shelby | Tennessee | 47157 | 25507 | 341 |
446504 | 446504 | 2020-08-18 | Shelby | Tennessee | 47157 | 25364 | 340 |
443278 | 443278 | 2020-08-17 | Shelby | Tennessee | 47157 | 25275 | 334 |
440051 | 440051 | 2020-08-16 | Shelby | Tennessee | 47157 | 25046 | 327 |
436826 | 436826 | 2020-08-15 | Shelby | Tennessee | 47157 | 24803 | 323 |
433599 | 433599 | 2020-08-14 | Shelby | Tennessee | 47157 | 24547 | 321 |
430374 | 430374 | 2020-08-13 | Shelby | Tennessee | 47157 | 24347 | 319 |
427147 | 427147 | 2020-08-12 | Shelby | Tennessee | 47157 | 24176 | 315 |
423924 | 423924 | 2020-08-11 | Shelby | Tennessee | 47157 | 24057 | 314 |
420702 | 420702 | 2020-08-10 | Shelby | Tennessee | 47157 | 23810 | 308 |
417481 | 417481 | 2020-08-09 | Shelby | Tennessee | 47157 | 23529 | 304 |
414260 | 414260 | 2020-08-08 | Shelby | Tennessee | 47157 | 23192 | 302 |
411040 | 411040 | 2020-08-07 | Shelby | Tennessee | 47157 | 23192 | 302 |
407821 | 407821 | 2020-08-06 | Shelby | Tennessee | 47157 | 22552 | 300 |
404601 | 404601 | 2020-08-05 | Shelby | Tennessee | 47157 | 22317 | 298 |
401383 | 401383 | 2020-08-04 | Shelby | Tennessee | 47157 | 22120 | 293 |
398168 | 398168 | 2020-08-03 | Shelby | Tennessee | 47157 | 21913 | 288 |
394951 | 394951 | 2020-08-02 | Shelby | Tennessee | 47157 | 21655 | 285 |
391735 | 391735 | 2020-08-01 | Shelby | Tennessee | 47157 | 21461 | 284 |
388518 | 388518 | 2020-07-31 | Shelby | Tennessee | 47157 | 20797 | 279 |
385301 | 385301 | 2020-07-30 | Shelby | Tennessee | 47157 | 20380 | 275 |
382083 | 382083 | 2020-07-29 | Shelby | Tennessee | 47157 | 20056 | 273 |
378866 | 378866 | 2020-07-28 | Shelby | Tennessee | 47157 | 19694 | 269 |
375650 | 375650 | 2020-07-27 | Shelby | Tennessee | 47157 | 19166 | 264 |
372437 | 372437 | 2020-07-26 | Shelby | Tennessee | 47157 | 18764 | 267 |
369225 | 369225 | 2020-07-25 | Shelby | Tennessee | 47157 | 18488 | 265 |
366016 | 366016 | 2020-07-24 | Shelby | Tennessee | 47157 | 18058 | 263 |
362810 | 362810 | 2020-07-23 | Shelby | Tennessee | 47157 | 17684 | 260 |
359603 | 359603 | 2020-07-22 | Shelby | Tennessee | 47157 | 17255 | 257 |
356399 | 356399 | 2020-07-21 | Shelby | Tennessee | 47157 | 16978 | 252 |
353196 | 353196 | 2020-07-20 | Shelby | Tennessee | 47157 | 16767 | 245 |
349993 | 349993 | 2020-07-19 | Shelby | Tennessee | 47157 | 16468 | 245 |
346793 | 346793 | 2020-07-18 | Shelby | Tennessee | 47157 | 16224 | 241 |
343593 | 343593 | 2020-07-17 | Shelby | Tennessee | 47157 | 15678 | 235 |
340395 | 340395 | 2020-07-16 | Shelby | Tennessee | 47157 | 15324 | 233 |
337198 | 337198 | 2020-07-15 | Shelby | Tennessee | 47157 | 14891 | 233 |
334004 | 334004 | 2020-07-14 | Shelby | Tennessee | 47157 | 14555 | 229 |
330812 | 330812 | 2020-07-13 | Shelby | Tennessee | 47157 | 14163 | 224 |
327626 | 327626 | 2020-07-12 | Shelby | Tennessee | 47157 | 13702 | 224 |
324441 | 324441 | 2020-07-11 | Shelby | Tennessee | 47157 | 13452 | 223 |
321260 | 321260 | 2020-07-10 | Shelby | Tennessee | 47157 | 13135 | 219 |
318082 | 318082 | 2020-07-09 | Shelby | Tennessee | 47157 | 12842 | 214 |
314909 | 314909 | 2020-07-08 | Shelby | Tennessee | 47157 | 12549 | 208 |
311735 | 311735 | 2020-07-07 | Shelby | Tennessee | 47157 | 12176 | 202 |
308566 | 308566 | 2020-07-06 | Shelby | Tennessee | 47157 | 12019 | 201 |
305398 | 305398 | 2020-07-05 | Shelby | Tennessee | 47157 | 11829 | 200 |
302235 | 302235 | 2020-07-04 | Shelby | Tennessee | 47157 | 11560 | 198 |
299071 | 299071 | 2020-07-03 | Shelby | Tennessee | 47157 | 11145 | 197 |
295911 | 295911 | 2020-07-02 | Shelby | Tennessee | 47157 | 10765 | 195 |
292755 | 292755 | 2020-07-01 | Shelby | Tennessee | 47157 | 10344 | 193 |
289603 | 289603 | 2020-06-30 | Shelby | Tennessee | 47157 | 10028 | 192 |
286452 | 286452 | 2020-06-29 | Shelby | Tennessee | 47157 | 9671 | 186 |
283307 | 283307 | 2020-06-28 | Shelby | Tennessee | 47157 | 9139 | 182 |
280161 | 280161 | 2020-06-27 | Shelby | Tennessee | 47157 | 9139 | 182 |
277013 | 277013 | 2020-06-26 | Shelby | Tennessee | 47157 | 8988 | 181 |
273866 | 273866 | 2020-06-25 | Shelby | Tennessee | 47157 | 8643 | 175 |
270727 | 270727 | 2020-06-24 | Shelby | Tennessee | 47157 | 8490 | 170 |
267593 | 267593 | 2020-06-23 | Shelby | Tennessee | 47157 | 8268 | 166 |
264465 | 264465 | 2020-06-22 | Shelby | Tennessee | 47157 | 8064 | 165 |
261337 | 261337 | 2020-06-21 | Shelby | Tennessee | 47157 | 7916 | 163 |
258210 | 258210 | 2020-06-20 | Shelby | Tennessee | 47157 | 7737 | 163 |
255084 | 255084 | 2020-06-19 | Shelby | Tennessee | 47157 | 7623 | 160 |
251969 | 251969 | 2020-06-18 | Shelby | Tennessee | 47157 | 7290 | 158 |
248854 | 248854 | 2020-06-17 | Shelby | Tennessee | 47157 | 7244 | 154 |
245741 | 245741 | 2020-06-16 | Shelby | Tennessee | 47157 | 7104 | 155 |
242629 | 242629 | 2020-06-15 | Shelby | Tennessee | 47157 | 6954 | 153 |
239519 | 239519 | 2020-06-14 | Shelby | Tennessee | 47157 | 6773 | 151 |
236411 | 236411 | 2020-06-13 | Shelby | Tennessee | 47157 | 6556 | 151 |
233305 | 233305 | 2020-06-12 | Shelby | Tennessee | 47157 | 6451 | 151 |
230200 | 230200 | 2020-06-11 | Shelby | Tennessee | 47157 | 6365 | 136 |
227096 | 227096 | 2020-06-10 | Shelby | Tennessee | 47157 | 6220 | 136 |
223996 | 223996 | 2020-06-09 | Shelby | Tennessee | 47157 | 6125 | 135 |
220901 | 220901 | 2020-06-08 | Shelby | Tennessee | 47157 | 6005 | 133 |
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);