ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,559 rows where county = "Hopkins" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12154 | 12154 | 2020-03-25 | Hopkins | Texas | 48223 | 1 | 0 |
12922 | 12922 | 2020-03-26 | Hopkins | Kentucky | 21107 | 1 | 0 |
13783 | 13783 | 2020-03-26 | Hopkins | Texas | 48223 | 1 | 0 |
14627 | 14627 | 2020-03-27 | Hopkins | Kentucky | 21107 | 1 | 1 |
15539 | 15539 | 2020-03-27 | Hopkins | Texas | 48223 | 1 | 0 |
16442 | 16442 | 2020-03-28 | Hopkins | Kentucky | 21107 | 2 | 1 |
17408 | 17408 | 2020-03-28 | Hopkins | Texas | 48223 | 1 | 0 |
18352 | 18352 | 2020-03-29 | Hopkins | Kentucky | 21107 | 7 | 1 |
19362 | 19362 | 2020-03-29 | Hopkins | Texas | 48223 | 1 | 0 |
20366 | 20366 | 2020-03-30 | Hopkins | Kentucky | 21107 | 11 | 1 |
21422 | 21422 | 2020-03-30 | Hopkins | Texas | 48223 | 2 | 0 |
22470 | 22470 | 2020-03-31 | Hopkins | Kentucky | 21107 | 21 | 1 |
23561 | 23561 | 2020-03-31 | Hopkins | Texas | 48223 | 3 | 0 |
24646 | 24646 | 2020-04-01 | Hopkins | Kentucky | 21107 | 21 | 2 |
25771 | 25771 | 2020-04-01 | Hopkins | Texas | 48223 | 3 | 0 |
26893 | 26893 | 2020-04-02 | Hopkins | Kentucky | 21107 | 21 | 2 |
28054 | 28054 | 2020-04-02 | Hopkins | Texas | 48223 | 3 | 0 |
29209 | 29209 | 2020-04-03 | Hopkins | Kentucky | 21107 | 21 | 2 |
30389 | 30389 | 2020-04-03 | Hopkins | Texas | 48223 | 3 | 0 |
31585 | 31585 | 2020-04-04 | Hopkins | Kentucky | 21107 | 26 | 2 |
32783 | 32783 | 2020-04-04 | Hopkins | Texas | 48223 | 3 | 0 |
34004 | 34004 | 2020-04-05 | Hopkins | Kentucky | 21107 | 33 | 3 |
35221 | 35221 | 2020-04-05 | Hopkins | Texas | 48223 | 4 | 0 |
36462 | 36462 | 2020-04-06 | Hopkins | Kentucky | 21107 | 33 | 3 |
37697 | 37697 | 2020-04-06 | Hopkins | Texas | 48223 | 4 | 0 |
38969 | 38969 | 2020-04-07 | Hopkins | Kentucky | 21107 | 38 | 3 |
40224 | 40224 | 2020-04-07 | Hopkins | Texas | 48223 | 4 | 0 |
41518 | 41518 | 2020-04-08 | Hopkins | Kentucky | 21107 | 57 | 3 |
42791 | 42791 | 2020-04-08 | Hopkins | Texas | 48223 | 4 | 0 |
44093 | 44093 | 2020-04-09 | Hopkins | Kentucky | 21107 | 78 | 7 |
45380 | 45380 | 2020-04-09 | Hopkins | Texas | 48223 | 4 | 0 |
46701 | 46701 | 2020-04-10 | Hopkins | Kentucky | 21107 | 84 | 8 |
48000 | 48000 | 2020-04-10 | Hopkins | Texas | 48223 | 4 | 0 |
49340 | 49340 | 2020-04-11 | Hopkins | Kentucky | 21107 | 88 | 8 |
50658 | 50658 | 2020-04-11 | Hopkins | Texas | 48223 | 4 | 0 |
52006 | 52006 | 2020-04-12 | Hopkins | Kentucky | 21107 | 86 | 9 |
53333 | 53333 | 2020-04-12 | Hopkins | Texas | 48223 | 4 | 0 |
54687 | 54687 | 2020-04-13 | Hopkins | Kentucky | 21107 | 88 | 9 |
56021 | 56021 | 2020-04-13 | Hopkins | Texas | 48223 | 4 | 0 |
57384 | 57384 | 2020-04-14 | Hopkins | Kentucky | 21107 | 92 | 9 |
58726 | 58726 | 2020-04-14 | Hopkins | Texas | 48223 | 4 | 0 |
60093 | 60093 | 2020-04-15 | Hopkins | Kentucky | 21107 | 102 | 10 |
61444 | 61444 | 2020-04-15 | Hopkins | Texas | 48223 | 4 | 0 |
62813 | 62813 | 2020-04-16 | Hopkins | Kentucky | 21107 | 111 | 10 |
64171 | 64171 | 2020-04-16 | Hopkins | Texas | 48223 | 4 | 0 |
65552 | 65552 | 2020-04-17 | Hopkins | Kentucky | 21107 | 117 | 10 |
66918 | 66918 | 2020-04-17 | Hopkins | Texas | 48223 | 4 | 0 |
68301 | 68301 | 2020-04-18 | Hopkins | Kentucky | 21107 | 117 | 10 |
69678 | 69678 | 2020-04-18 | Hopkins | Texas | 48223 | 4 | 0 |
71064 | 71064 | 2020-04-19 | Hopkins | Kentucky | 21107 | 118 | 11 |
72446 | 72446 | 2020-04-19 | Hopkins | Texas | 48223 | 4 | 0 |
73836 | 73836 | 2020-04-20 | Hopkins | Kentucky | 21107 | 118 | 12 |
75222 | 75222 | 2020-04-20 | Hopkins | Texas | 48223 | 4 | 0 |
76617 | 76617 | 2020-04-21 | Hopkins | Kentucky | 21107 | 159 | 18 |
78004 | 78004 | 2020-04-21 | Hopkins | Texas | 48223 | 4 | 0 |
79402 | 79402 | 2020-04-22 | Hopkins | Kentucky | 21107 | 159 | 18 |
80795 | 80795 | 2020-04-22 | Hopkins | Texas | 48223 | 4 | 0 |
82199 | 82199 | 2020-04-23 | Hopkins | Kentucky | 21107 | 170 | 18 |
83595 | 83595 | 2020-04-23 | Hopkins | Texas | 48223 | 4 | 0 |
85002 | 85002 | 2020-04-24 | Hopkins | Kentucky | 21107 | 171 | 20 |
86400 | 86400 | 2020-04-24 | Hopkins | Texas | 48223 | 4 | 0 |
87811 | 87811 | 2020-04-25 | Hopkins | Kentucky | 21107 | 175 | 20 |
89215 | 89215 | 2020-04-25 | Hopkins | Texas | 48223 | 4 | 0 |
90627 | 90627 | 2020-04-26 | Hopkins | Kentucky | 21107 | 184 | 20 |
92032 | 92032 | 2020-04-26 | Hopkins | Texas | 48223 | 4 | 0 |
93448 | 93448 | 2020-04-27 | Hopkins | Kentucky | 21107 | 188 | 22 |
94861 | 94861 | 2020-04-27 | Hopkins | Texas | 48223 | 4 | 0 |
96281 | 96281 | 2020-04-28 | Hopkins | Kentucky | 21107 | 192 | 24 |
97701 | 97701 | 2020-04-28 | Hopkins | Texas | 48223 | 4 | 0 |
99127 | 99127 | 2020-04-29 | Hopkins | Kentucky | 21107 | 193 | 23 |
100551 | 100551 | 2020-04-29 | Hopkins | Texas | 48223 | 4 | 0 |
101979 | 101979 | 2020-04-30 | Hopkins | Kentucky | 21107 | 197 | 23 |
103406 | 103406 | 2020-04-30 | Hopkins | Texas | 48223 | 4 | 0 |
104840 | 104840 | 2020-05-01 | Hopkins | Kentucky | 21107 | 201 | 23 |
106270 | 106270 | 2020-05-01 | Hopkins | Texas | 48223 | 4 | 0 |
107705 | 107705 | 2020-05-02 | Hopkins | Kentucky | 21107 | 201 | 23 |
109139 | 109139 | 2020-05-02 | Hopkins | Texas | 48223 | 6 | 0 |
110576 | 110576 | 2020-05-03 | Hopkins | Kentucky | 21107 | 207 | 23 |
112013 | 112013 | 2020-05-03 | Hopkins | Texas | 48223 | 6 | 0 |
113453 | 113453 | 2020-05-04 | Hopkins | Kentucky | 21107 | 207 | 23 |
114895 | 114895 | 2020-05-04 | Hopkins | Texas | 48223 | 6 | 0 |
116335 | 116335 | 2020-05-05 | Hopkins | Kentucky | 21107 | 207 | 24 |
117854 | 117854 | 2020-05-05 | Hopkins | Texas | 48223 | 6 | 0 |
119296 | 119296 | 2020-05-06 | Hopkins | Kentucky | 21107 | 211 | 24 |
120818 | 120818 | 2020-05-06 | Hopkins | Texas | 48223 | 6 | 0 |
122267 | 122267 | 2020-05-07 | Hopkins | Kentucky | 21107 | 212 | 24 |
123797 | 123797 | 2020-05-07 | Hopkins | Texas | 48223 | 7 | 0 |
125249 | 125249 | 2020-05-08 | Hopkins | Kentucky | 21107 | 213 | 25 |
126780 | 126780 | 2020-05-08 | Hopkins | Texas | 48223 | 7 | 0 |
128237 | 128237 | 2020-05-09 | Hopkins | Kentucky | 21107 | 214 | 25 |
129769 | 129769 | 2020-05-09 | Hopkins | Texas | 48223 | 7 | 0 |
131227 | 131227 | 2020-05-10 | Hopkins | Kentucky | 21107 | 214 | 25 |
132759 | 132759 | 2020-05-10 | Hopkins | Texas | 48223 | 8 | 0 |
134218 | 134218 | 2020-05-11 | Hopkins | Kentucky | 21107 | 215 | 27 |
135750 | 135750 | 2020-05-11 | Hopkins | Texas | 48223 | 8 | 0 |
137208 | 137208 | 2020-05-12 | Hopkins | Kentucky | 21107 | 216 | 28 |
138740 | 138740 | 2020-05-12 | Hopkins | Texas | 48223 | 8 | 0 |
140201 | 140201 | 2020-05-13 | Hopkins | Kentucky | 21107 | 217 | 28 |
141736 | 141736 | 2020-05-13 | Hopkins | Texas | 48223 | 8 | 0 |
143197 | 143197 | 2020-05-14 | Hopkins | Kentucky | 21107 | 218 | 28 |
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);