ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Heard" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5360 | 5360 | 2020-03-20 | Heard | Georgia | 13149 | 1 | 0 |
6293 | 6293 | 2020-03-21 | Heard | Georgia | 13149 | 1 | 0 |
7339 | 7339 | 2020-03-22 | Heard | Georgia | 13149 | 1 | 0 |
8488 | 8488 | 2020-03-23 | Heard | Georgia | 13149 | 1 | 0 |
9741 | 9741 | 2020-03-24 | Heard | Georgia | 13149 | 1 | 1 |
11118 | 11118 | 2020-03-25 | Heard | Georgia | 13149 | 1 | 1 |
12669 | 12669 | 2020-03-26 | Heard | Georgia | 13149 | 1 | 1 |
14343 | 14343 | 2020-03-27 | Heard | Georgia | 13149 | 1 | 1 |
16129 | 16129 | 2020-03-28 | Heard | Georgia | 13149 | 1 | 1 |
18026 | 18026 | 2020-03-29 | Heard | Georgia | 13149 | 1 | 1 |
20016 | 20016 | 2020-03-30 | Heard | Georgia | 13149 | 1 | 1 |
22097 | 22097 | 2020-03-31 | Heard | Georgia | 13149 | 1 | 1 |
24260 | 24260 | 2020-04-01 | Heard | Georgia | 13149 | 2 | 1 |
26491 | 26491 | 2020-04-02 | Heard | Georgia | 13149 | 2 | 1 |
28795 | 28795 | 2020-04-03 | Heard | Georgia | 13149 | 2 | 1 |
31155 | 31155 | 2020-04-04 | Heard | Georgia | 13149 | 2 | 1 |
33562 | 33562 | 2020-04-05 | Heard | Georgia | 13149 | 2 | 1 |
36011 | 36011 | 2020-04-06 | Heard | Georgia | 13149 | 2 | 1 |
38504 | 38504 | 2020-04-07 | Heard | Georgia | 13149 | 3 | 1 |
41048 | 41048 | 2020-04-08 | Heard | Georgia | 13149 | 2 | 0 |
43622 | 43622 | 2020-04-09 | Heard | Georgia | 13149 | 3 | 1 |
46224 | 46224 | 2020-04-10 | Heard | Georgia | 13149 | 3 | 1 |
48854 | 48854 | 2020-04-11 | Heard | Georgia | 13149 | 4 | 1 |
51516 | 51516 | 2020-04-12 | Heard | Georgia | 13149 | 4 | 1 |
54196 | 54196 | 2020-04-13 | Heard | Georgia | 13149 | 4 | 1 |
56888 | 56888 | 2020-04-14 | Heard | Georgia | 13149 | 5 | 1 |
59595 | 59595 | 2020-04-15 | Heard | Georgia | 13149 | 5 | 1 |
62315 | 62315 | 2020-04-16 | Heard | Georgia | 13149 | 5 | 1 |
65048 | 65048 | 2020-04-17 | Heard | Georgia | 13149 | 5 | 1 |
67796 | 67796 | 2020-04-18 | Heard | Georgia | 13149 | 7 | 1 |
70558 | 70558 | 2020-04-19 | Heard | Georgia | 13149 | 7 | 1 |
73327 | 73327 | 2020-04-20 | Heard | Georgia | 13149 | 7 | 1 |
76103 | 76103 | 2020-04-21 | Heard | Georgia | 13149 | 8 | 1 |
78887 | 78887 | 2020-04-22 | Heard | Georgia | 13149 | 8 | 1 |
81680 | 81680 | 2020-04-23 | Heard | Georgia | 13149 | 9 | 1 |
84480 | 84480 | 2020-04-24 | Heard | Georgia | 13149 | 9 | 1 |
87289 | 87289 | 2020-04-25 | Heard | Georgia | 13149 | 9 | 1 |
90105 | 90105 | 2020-04-26 | Heard | Georgia | 13149 | 9 | 1 |
92924 | 92924 | 2020-04-27 | Heard | Georgia | 13149 | 10 | 1 |
95756 | 95756 | 2020-04-28 | Heard | Georgia | 13149 | 10 | 1 |
98601 | 98601 | 2020-04-29 | Heard | Georgia | 13149 | 9 | 1 |
101451 | 101451 | 2020-04-30 | Heard | Georgia | 13149 | 10 | 1 |
104306 | 104306 | 2020-05-01 | Heard | Georgia | 13149 | 11 | 1 |
107171 | 107171 | 2020-05-02 | Heard | Georgia | 13149 | 11 | 1 |
110040 | 110040 | 2020-05-03 | Heard | Georgia | 13149 | 14 | 1 |
112915 | 112915 | 2020-05-04 | Heard | Georgia | 13149 | 13 | 1 |
115798 | 115798 | 2020-05-05 | Heard | Georgia | 13149 | 14 | 1 |
118758 | 118758 | 2020-05-06 | Heard | Georgia | 13149 | 14 | 1 |
121728 | 121728 | 2020-05-07 | Heard | Georgia | 13149 | 14 | 1 |
124707 | 124707 | 2020-05-08 | Heard | Georgia | 13149 | 14 | 1 |
127694 | 127694 | 2020-05-09 | Heard | Georgia | 13149 | 14 | 1 |
130685 | 130685 | 2020-05-10 | Heard | Georgia | 13149 | 14 | 1 |
133676 | 133676 | 2020-05-11 | Heard | Georgia | 13149 | 15 | 1 |
136665 | 136665 | 2020-05-12 | Heard | Georgia | 13149 | 17 | 1 |
139656 | 139656 | 2020-05-13 | Heard | Georgia | 13149 | 17 | 1 |
142652 | 142652 | 2020-05-14 | Heard | Georgia | 13149 | 17 | 1 |
145652 | 145652 | 2020-05-15 | Heard | Georgia | 13149 | 17 | 1 |
148655 | 148655 | 2020-05-16 | Heard | Georgia | 13149 | 17 | 1 |
151664 | 151664 | 2020-05-17 | Heard | Georgia | 13149 | 17 | 1 |
154676 | 154676 | 2020-05-18 | Heard | Georgia | 13149 | 17 | 1 |
157692 | 157692 | 2020-05-19 | Heard | Georgia | 13149 | 20 | 1 |
160718 | 160718 | 2020-05-20 | Heard | Georgia | 13149 | 23 | 1 |
163746 | 163746 | 2020-05-21 | Heard | Georgia | 13149 | 24 | 2 |
166779 | 166779 | 2020-05-22 | Heard | Georgia | 13149 | 26 | 2 |
169816 | 169816 | 2020-05-23 | Heard | Georgia | 13149 | 26 | 2 |
172857 | 172857 | 2020-05-24 | Heard | Georgia | 13149 | 26 | 2 |
175900 | 175900 | 2020-05-25 | Heard | Georgia | 13149 | 28 | 2 |
178944 | 178944 | 2020-05-26 | Heard | Georgia | 13149 | 28 | 2 |
181988 | 181988 | 2020-05-27 | Heard | Georgia | 13149 | 30 | 2 |
185042 | 185042 | 2020-05-28 | Heard | Georgia | 13149 | 32 | 2 |
188098 | 188098 | 2020-05-29 | Heard | Georgia | 13149 | 32 | 2 |
191163 | 191163 | 2020-05-30 | Heard | Georgia | 13149 | 33 | 2 |
194230 | 194230 | 2020-05-31 | Heard | Georgia | 13149 | 34 | 2 |
197300 | 197300 | 2020-06-01 | Heard | Georgia | 13149 | 34 | 2 |
200373 | 200373 | 2020-06-02 | Heard | Georgia | 13149 | 35 | 2 |
203449 | 203449 | 2020-06-03 | Heard | Georgia | 13149 | 35 | 2 |
206529 | 206529 | 2020-06-04 | Heard | Georgia | 13149 | 37 | 3 |
209610 | 209610 | 2020-06-05 | Heard | Georgia | 13149 | 36 | 3 |
212695 | 212695 | 2020-06-06 | Heard | Georgia | 13149 | 36 | 3 |
215782 | 215782 | 2020-06-07 | Heard | Georgia | 13149 | 36 | 3 |
218873 | 218873 | 2020-06-08 | Heard | Georgia | 13149 | 36 | 3 |
221968 | 221968 | 2020-06-09 | Heard | Georgia | 13149 | 37 | 3 |
225063 | 225063 | 2020-06-10 | Heard | Georgia | 13149 | 39 | 3 |
228165 | 228165 | 2020-06-11 | Heard | Georgia | 13149 | 41 | 3 |
231268 | 231268 | 2020-06-12 | Heard | Georgia | 13149 | 42 | 3 |
234374 | 234374 | 2020-06-13 | Heard | Georgia | 13149 | 42 | 3 |
237481 | 237481 | 2020-06-14 | Heard | Georgia | 13149 | 43 | 3 |
240589 | 240589 | 2020-06-15 | Heard | Georgia | 13149 | 43 | 3 |
243700 | 243700 | 2020-06-16 | Heard | Georgia | 13149 | 45 | 3 |
246813 | 246813 | 2020-06-17 | Heard | Georgia | 13149 | 45 | 3 |
249925 | 249925 | 2020-06-18 | Heard | Georgia | 13149 | 45 | 3 |
253040 | 253040 | 2020-06-19 | Heard | Georgia | 13149 | 45 | 3 |
256159 | 256159 | 2020-06-20 | Heard | Georgia | 13149 | 45 | 3 |
259286 | 259286 | 2020-06-21 | Heard | Georgia | 13149 | 45 | 3 |
262413 | 262413 | 2020-06-22 | Heard | Georgia | 13149 | 46 | 3 |
265541 | 265541 | 2020-06-23 | Heard | Georgia | 13149 | 47 | 3 |
268671 | 268671 | 2020-06-24 | Heard | Georgia | 13149 | 47 | 3 |
271807 | 271807 | 2020-06-25 | Heard | Georgia | 13149 | 47 | 3 |
274947 | 274947 | 2020-06-26 | Heard | Georgia | 13149 | 47 | 3 |
278095 | 278095 | 2020-06-27 | Heard | Georgia | 13149 | 48 | 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);