ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,009 rows where county = "Scott" sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

fips

county

  • Scott · 1,009
Link rowid date ▲ county state fips cases deaths
291931 2020-07-03 Scott Arkansas 5127 12 0
292435 2020-07-03 Scott Illinois 17171 1 0
292524 2020-07-03 Scott Indiana 18143 164 8
292627 2020-07-03 Scott Iowa 19163 748 10
292724 2020-07-03 Scott Kansas 20171 16 0
292846 2020-07-03 Scott Kentucky 21209 99 0
293134 2020-07-03 Scott Minnesota 27139 700 4
293215 2020-07-03 Scott Mississippi 28123 762 15
293331 2020-07-03 Scott Missouri 29201 172 11
294213 2020-07-03 Scott Tennessee 47151 18 0
294633 2020-07-03 Scott Virginia 51169 10 2
288854 2020-07-02 Scott Arkansas 5127 12 0
289445 2020-07-02 Scott Indiana 18143 159 8
289548 2020-07-02 Scott Iowa 19163 704 10
289645 2020-07-02 Scott Kansas 20171 16 0
289767 2020-07-02 Scott Kentucky 21209 97 0
290055 2020-07-02 Scott Minnesota 27139 684 4
290136 2020-07-02 Scott Mississippi 28123 757 15
290252 2020-07-02 Scott Missouri 29201 170 11
291132 2020-07-02 Scott Tennessee 47151 15 0
291550 2020-07-02 Scott Virginia 51169 10 2
285779 2020-07-01 Scott Arkansas 5127 12 0
286370 2020-07-01 Scott Indiana 18143 158 8
286473 2020-07-01 Scott Iowa 19163 673 10
286570 2020-07-01 Scott Kansas 20171 16 0
286692 2020-07-01 Scott Kentucky 21209 91 0
286980 2020-07-01 Scott Minnesota 27139 671 4
287061 2020-07-01 Scott Mississippi 28123 750 15
287177 2020-07-01 Scott Missouri 29201 169 11
288055 2020-07-01 Scott Tennessee 47151 15 0
288474 2020-07-01 Scott Virginia 51169 10 2
282706 2020-06-30 Scott Arkansas 5127 11 0
283298 2020-06-30 Scott Indiana 18143 158 8
283401 2020-06-30 Scott Iowa 19163 639 10
283499 2020-06-30 Scott Kansas 20171 17 0
283620 2020-06-30 Scott Kentucky 21209 87 0
283908 2020-06-30 Scott Minnesota 27139 658 4
283989 2020-06-30 Scott Mississippi 28123 742 15
284105 2020-06-30 Scott Missouri 29201 168 11
284982 2020-06-30 Scott Tennessee 47151 14 0
285400 2020-06-30 Scott Virginia 51169 10 2
279637 2020-06-29 Scott Arkansas 5127 11 0
280226 2020-06-29 Scott Indiana 18143 157 7
280329 2020-06-29 Scott Iowa 19163 618 10
280427 2020-06-29 Scott Kansas 20171 17 0
280548 2020-06-29 Scott Kentucky 21209 83 0
280835 2020-06-29 Scott Minnesota 27139 641 4
280916 2020-06-29 Scott Mississippi 28123 733 15
281032 2020-06-29 Scott Missouri 29201 164 11
281908 2020-06-29 Scott Tennessee 47151 14 0
282327 2020-06-29 Scott Virginia 51169 10 2
276569 2020-06-28 Scott Arkansas 5127 10 0
277159 2020-06-28 Scott Indiana 18143 157 7
277262 2020-06-28 Scott Iowa 19163 598 10
277358 2020-06-28 Scott Kansas 20171 16 0
277479 2020-06-28 Scott Kentucky 21209 82 0
277767 2020-06-28 Scott Minnesota 27139 637 4
277848 2020-06-28 Scott Mississippi 28123 726 14
277964 2020-06-28 Scott Missouri 29201 162 11
278840 2020-06-28 Scott Tennessee 47151 14 0
279258 2020-06-28 Scott Virginia 51169 10 2
273500 2020-06-27 Scott Arkansas 5127 10 0
274089 2020-06-27 Scott Indiana 18143 157 7
274192 2020-06-27 Scott Iowa 19163 580 10
274288 2020-06-27 Scott Kansas 20171 16 0
274409 2020-06-27 Scott Kentucky 21209 82 0
274697 2020-06-27 Scott Minnesota 27139 627 4
274778 2020-06-27 Scott Mississippi 28123 725 14
274894 2020-06-27 Scott Missouri 29201 161 11
275772 2020-06-27 Scott Tennessee 47151 14 0
276190 2020-06-27 Scott Virginia 51169 9 2
270431 2020-06-26 Scott Arkansas 5127 9 0
271020 2020-06-26 Scott Indiana 18143 156 7
271123 2020-06-26 Scott Iowa 19163 561 10
271219 2020-06-26 Scott Kansas 20171 16 0
271340 2020-06-26 Scott Kentucky 21209 83 0
271628 2020-06-26 Scott Minnesota 27139 616 4
271709 2020-06-26 Scott Mississippi 28123 723 14
271825 2020-06-26 Scott Missouri 29201 161 11
272703 2020-06-26 Scott Tennessee 47151 14 0
273121 2020-06-26 Scott Virginia 51169 9 2
267370 2020-06-25 Scott Arkansas 5127 8 0
267957 2020-06-25 Scott Indiana 18143 157 7
268060 2020-06-25 Scott Iowa 19163 516 10
268155 2020-06-25 Scott Kansas 20171 16 0
268276 2020-06-25 Scott Kentucky 21209 79 0
268564 2020-06-25 Scott Minnesota 27139 609 4
268645 2020-06-25 Scott Mississippi 28123 721 14
268761 2020-06-25 Scott Missouri 29201 159 11
269635 2020-06-25 Scott Tennessee 47151 14 0
270052 2020-06-25 Scott Virginia 51169 9 2
264314 2020-06-24 Scott Arkansas 5127 8 0
264899 2020-06-24 Scott Indiana 18143 154 7
265002 2020-06-24 Scott Iowa 19163 488 10
265097 2020-06-24 Scott Kansas 20171 16 0
265219 2020-06-24 Scott Kentucky 21209 76 0
265506 2020-06-24 Scott Minnesota 27139 603 4
265586 2020-06-24 Scott Mississippi 28123 709 14
265701 2020-06-24 Scott Missouri 29201 159 11
266576 2020-06-24 Scott Tennessee 47151 14 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 905.019ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette