ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "George" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6585 | 6585 | 2020-03-21 | George | Mississippi | 28039 | 1 | 0 |
7668 | 7668 | 2020-03-22 | George | Mississippi | 28039 | 1 | 0 |
8848 | 8848 | 2020-03-23 | George | Mississippi | 28039 | 1 | 0 |
10144 | 10144 | 2020-03-24 | George | Mississippi | 28039 | 1 | 0 |
11564 | 11564 | 2020-03-25 | George | Mississippi | 28039 | 1 | 0 |
13156 | 13156 | 2020-03-26 | George | Mississippi | 28039 | 1 | 0 |
14872 | 14872 | 2020-03-27 | George | Mississippi | 28039 | 1 | 0 |
16696 | 16696 | 2020-03-28 | George | Mississippi | 28039 | 1 | 0 |
18618 | 18618 | 2020-03-29 | George | Mississippi | 28039 | 3 | 0 |
20642 | 20642 | 2020-03-30 | George | Mississippi | 28039 | 3 | 0 |
22759 | 22759 | 2020-03-31 | George | Mississippi | 28039 | 3 | 0 |
24942 | 24942 | 2020-04-01 | George | Mississippi | 28039 | 4 | 0 |
27196 | 27196 | 2020-04-02 | George | Mississippi | 28039 | 4 | 0 |
29515 | 29515 | 2020-04-03 | George | Mississippi | 28039 | 4 | 0 |
31895 | 31895 | 2020-04-04 | George | Mississippi | 28039 | 4 | 0 |
34322 | 34322 | 2020-04-05 | George | Mississippi | 28039 | 5 | 0 |
36784 | 36784 | 2020-04-06 | George | Mississippi | 28039 | 5 | 0 |
39295 | 39295 | 2020-04-07 | George | Mississippi | 28039 | 5 | 0 |
41849 | 41849 | 2020-04-08 | George | Mississippi | 28039 | 5 | 0 |
44425 | 44425 | 2020-04-09 | George | Mississippi | 28039 | 5 | 0 |
47034 | 47034 | 2020-04-10 | George | Mississippi | 28039 | 7 | 0 |
49680 | 49680 | 2020-04-11 | George | Mississippi | 28039 | 7 | 0 |
52353 | 52353 | 2020-04-12 | George | Mississippi | 28039 | 7 | 0 |
55035 | 55035 | 2020-04-13 | George | Mississippi | 28039 | 8 | 0 |
57733 | 57733 | 2020-04-14 | George | Mississippi | 28039 | 10 | 0 |
60444 | 60444 | 2020-04-15 | George | Mississippi | 28039 | 8 | 0 |
63166 | 63166 | 2020-04-16 | George | Mississippi | 28039 | 8 | 0 |
65906 | 65906 | 2020-04-17 | George | Mississippi | 28039 | 9 | 0 |
68658 | 68658 | 2020-04-18 | George | Mississippi | 28039 | 10 | 1 |
71424 | 71424 | 2020-04-19 | George | Mississippi | 28039 | 10 | 1 |
74197 | 74197 | 2020-04-20 | George | Mississippi | 28039 | 10 | 1 |
76978 | 76978 | 2020-04-21 | George | Mississippi | 28039 | 10 | 1 |
79763 | 79763 | 2020-04-22 | George | Mississippi | 28039 | 10 | 1 |
82559 | 82559 | 2020-04-23 | George | Mississippi | 28039 | 10 | 1 |
85363 | 85363 | 2020-04-24 | George | Mississippi | 28039 | 11 | 1 |
88173 | 88173 | 2020-04-25 | George | Mississippi | 28039 | 11 | 1 |
90989 | 90989 | 2020-04-26 | George | Mississippi | 28039 | 11 | 1 |
93810 | 93810 | 2020-04-27 | George | Mississippi | 28039 | 11 | 1 |
96646 | 96646 | 2020-04-28 | George | Mississippi | 28039 | 12 | 1 |
99492 | 99492 | 2020-04-29 | George | Mississippi | 28039 | 13 | 1 |
102344 | 102344 | 2020-04-30 | George | Mississippi | 28039 | 13 | 1 |
105205 | 105205 | 2020-05-01 | George | Mississippi | 28039 | 14 | 1 |
108070 | 108070 | 2020-05-02 | George | Mississippi | 28039 | 14 | 1 |
110941 | 110941 | 2020-05-03 | George | Mississippi | 28039 | 14 | 1 |
113820 | 113820 | 2020-05-04 | George | Mississippi | 28039 | 14 | 1 |
116702 | 116702 | 2020-05-05 | George | Mississippi | 28039 | 14 | 1 |
119662 | 119662 | 2020-05-06 | George | Mississippi | 28039 | 15 | 1 |
122636 | 122636 | 2020-05-07 | George | Mississippi | 28039 | 15 | 1 |
125618 | 125618 | 2020-05-08 | George | Mississippi | 28039 | 15 | 1 |
128605 | 128605 | 2020-05-09 | George | Mississippi | 28039 | 15 | 1 |
131595 | 131595 | 2020-05-10 | George | Mississippi | 28039 | 15 | 1 |
134586 | 134586 | 2020-05-11 | George | Mississippi | 28039 | 15 | 1 |
137576 | 137576 | 2020-05-12 | George | Mississippi | 28039 | 15 | 1 |
140570 | 140570 | 2020-05-13 | George | Mississippi | 28039 | 16 | 1 |
143565 | 143565 | 2020-05-14 | George | Mississippi | 28039 | 16 | 1 |
146565 | 146565 | 2020-05-15 | George | Mississippi | 28039 | 18 | 1 |
149570 | 149570 | 2020-05-16 | George | Mississippi | 28039 | 17 | 1 |
152581 | 152581 | 2020-05-17 | George | Mississippi | 28039 | 17 | 1 |
155595 | 155595 | 2020-05-18 | George | Mississippi | 28039 | 17 | 1 |
158613 | 158613 | 2020-05-19 | George | Mississippi | 28039 | 19 | 1 |
161639 | 161639 | 2020-05-20 | George | Mississippi | 28039 | 19 | 1 |
164668 | 164668 | 2020-05-21 | George | Mississippi | 28039 | 19 | 1 |
167704 | 167704 | 2020-05-22 | George | Mississippi | 28039 | 19 | 1 |
170742 | 170742 | 2020-05-23 | George | Mississippi | 28039 | 19 | 1 |
173784 | 173784 | 2020-05-24 | George | Mississippi | 28039 | 19 | 1 |
176827 | 176827 | 2020-05-25 | George | Mississippi | 28039 | 20 | 1 |
179871 | 179871 | 2020-05-26 | George | Mississippi | 28039 | 20 | 1 |
182917 | 182917 | 2020-05-27 | George | Mississippi | 28039 | 20 | 1 |
185973 | 185973 | 2020-05-28 | George | Mississippi | 28039 | 21 | 1 |
189031 | 189031 | 2020-05-29 | George | Mississippi | 28039 | 21 | 1 |
192095 | 192095 | 2020-05-30 | George | Mississippi | 28039 | 25 | 1 |
195163 | 195163 | 2020-05-31 | George | Mississippi | 28039 | 25 | 1 |
198234 | 198234 | 2020-06-01 | George | Mississippi | 28039 | 25 | 1 |
201307 | 201307 | 2020-06-02 | George | Mississippi | 28039 | 26 | 1 |
204384 | 204384 | 2020-06-03 | George | Mississippi | 28039 | 28 | 1 |
207465 | 207465 | 2020-06-04 | George | Mississippi | 28039 | 29 | 2 |
210546 | 210546 | 2020-06-05 | George | Mississippi | 28039 | 30 | 2 |
213630 | 213630 | 2020-06-06 | George | Mississippi | 28039 | 30 | 2 |
216718 | 216718 | 2020-06-07 | George | Mississippi | 28039 | 30 | 2 |
219810 | 219810 | 2020-06-08 | George | Mississippi | 28039 | 31 | 2 |
222905 | 222905 | 2020-06-09 | George | Mississippi | 28039 | 32 | 2 |
226003 | 226003 | 2020-06-10 | George | Mississippi | 28039 | 32 | 2 |
229105 | 229105 | 2020-06-11 | George | Mississippi | 28039 | 32 | 2 |
232209 | 232209 | 2020-06-12 | George | Mississippi | 28039 | 35 | 2 |
235315 | 235315 | 2020-06-13 | George | Mississippi | 28039 | 35 | 2 |
238422 | 238422 | 2020-06-14 | George | Mississippi | 28039 | 35 | 2 |
241531 | 241531 | 2020-06-15 | George | Mississippi | 28039 | 37 | 2 |
244642 | 244642 | 2020-06-16 | George | Mississippi | 28039 | 40 | 2 |
247755 | 247755 | 2020-06-17 | George | Mississippi | 28039 | 41 | 2 |
250867 | 250867 | 2020-06-18 | George | Mississippi | 28039 | 41 | 2 |
253982 | 253982 | 2020-06-19 | George | Mississippi | 28039 | 41 | 2 |
257102 | 257102 | 2020-06-20 | George | Mississippi | 28039 | 41 | 2 |
260228 | 260228 | 2020-06-21 | George | Mississippi | 28039 | 41 | 2 |
263357 | 263357 | 2020-06-22 | George | Mississippi | 28039 | 53 | 2 |
266483 | 266483 | 2020-06-23 | George | Mississippi | 28039 | 58 | 3 |
269616 | 269616 | 2020-06-24 | George | Mississippi | 28039 | 58 | 3 |
272753 | 272753 | 2020-06-25 | George | Mississippi | 28039 | 60 | 3 |
275896 | 275896 | 2020-06-26 | George | Mississippi | 28039 | 61 | 3 |
279044 | 279044 | 2020-06-27 | George | Mississippi | 28039 | 66 | 3 |
282192 | 282192 | 2020-06-28 | George | Mississippi | 28039 | 66 | 3 |
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);