ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay" and fips = 37043 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 |
---|---|---|---|---|---|---|---|
23059 | 23059 | 2020-03-31 | Clay | North Carolina | 37043 | 1 | 0 |
25253 | 25253 | 2020-04-01 | Clay | North Carolina | 37043 | 1 | 0 |
27514 | 27514 | 2020-04-02 | Clay | North Carolina | 37043 | 2 | 0 |
29840 | 29840 | 2020-04-03 | Clay | North Carolina | 37043 | 3 | 0 |
32227 | 32227 | 2020-04-04 | Clay | North Carolina | 37043 | 3 | 0 |
34658 | 34658 | 2020-04-05 | Clay | North Carolina | 37043 | 3 | 0 |
37127 | 37127 | 2020-04-06 | Clay | North Carolina | 37043 | 3 | 0 |
39642 | 39642 | 2020-04-07 | Clay | North Carolina | 37043 | 3 | 0 |
42199 | 42199 | 2020-04-08 | Clay | North Carolina | 37043 | 3 | 0 |
44782 | 44782 | 2020-04-09 | Clay | North Carolina | 37043 | 4 | 0 |
47395 | 47395 | 2020-04-10 | Clay | North Carolina | 37043 | 3 | 0 |
50050 | 50050 | 2020-04-11 | Clay | North Carolina | 37043 | 3 | 0 |
52723 | 52723 | 2020-04-12 | Clay | North Carolina | 37043 | 3 | 0 |
55406 | 55406 | 2020-04-13 | Clay | North Carolina | 37043 | 3 | 0 |
58106 | 58106 | 2020-04-14 | Clay | North Carolina | 37043 | 3 | 0 |
60820 | 60820 | 2020-04-15 | Clay | North Carolina | 37043 | 3 | 0 |
63546 | 63546 | 2020-04-16 | Clay | North Carolina | 37043 | 4 | 0 |
66289 | 66289 | 2020-04-17 | Clay | North Carolina | 37043 | 5 | 0 |
69046 | 69046 | 2020-04-18 | Clay | North Carolina | 37043 | 5 | 0 |
71812 | 71812 | 2020-04-19 | Clay | North Carolina | 37043 | 5 | 0 |
74587 | 74587 | 2020-04-20 | Clay | North Carolina | 37043 | 5 | 0 |
77368 | 77368 | 2020-04-21 | Clay | North Carolina | 37043 | 5 | 0 |
80157 | 80157 | 2020-04-22 | Clay | North Carolina | 37043 | 5 | 0 |
82956 | 82956 | 2020-04-23 | Clay | North Carolina | 37043 | 5 | 0 |
85760 | 85760 | 2020-04-24 | Clay | North Carolina | 37043 | 5 | 0 |
88572 | 88572 | 2020-04-25 | Clay | North Carolina | 37043 | 5 | 0 |
91387 | 91387 | 2020-04-26 | Clay | North Carolina | 37043 | 5 | 0 |
94213 | 94213 | 2020-04-27 | Clay | North Carolina | 37043 | 5 | 0 |
97049 | 97049 | 2020-04-28 | Clay | North Carolina | 37043 | 5 | 0 |
99896 | 99896 | 2020-04-29 | Clay | North Carolina | 37043 | 5 | 0 |
102749 | 102749 | 2020-04-30 | Clay | North Carolina | 37043 | 5 | 0 |
105611 | 105611 | 2020-05-01 | Clay | North Carolina | 37043 | 5 | 0 |
108478 | 108478 | 2020-05-02 | Clay | North Carolina | 37043 | 5 | 0 |
111351 | 111351 | 2020-05-03 | Clay | North Carolina | 37043 | 5 | 0 |
114232 | 114232 | 2020-05-04 | Clay | North Carolina | 37043 | 5 | 0 |
117112 | 117112 | 2020-05-05 | Clay | North Carolina | 37043 | 5 | 0 |
120073 | 120073 | 2020-05-06 | Clay | North Carolina | 37043 | 5 | 0 |
123048 | 123048 | 2020-05-07 | Clay | North Carolina | 37043 | 5 | 0 |
126031 | 126031 | 2020-05-08 | Clay | North Carolina | 37043 | 5 | 0 |
129020 | 129020 | 2020-05-09 | Clay | North Carolina | 37043 | 5 | 0 |
132009 | 132009 | 2020-05-10 | Clay | North Carolina | 37043 | 5 | 0 |
135000 | 135000 | 2020-05-11 | Clay | North Carolina | 37043 | 5 | 0 |
137990 | 137990 | 2020-05-12 | Clay | North Carolina | 37043 | 5 | 0 |
140986 | 140986 | 2020-05-13 | Clay | North Carolina | 37043 | 5 | 0 |
143981 | 143981 | 2020-05-14 | Clay | North Carolina | 37043 | 5 | 0 |
146982 | 146982 | 2020-05-15 | Clay | North Carolina | 37043 | 5 | 0 |
149989 | 149989 | 2020-05-16 | Clay | North Carolina | 37043 | 5 | 0 |
152999 | 152999 | 2020-05-17 | Clay | North Carolina | 37043 | 5 | 0 |
156016 | 156016 | 2020-05-18 | Clay | North Carolina | 37043 | 5 | 0 |
159035 | 159035 | 2020-05-19 | Clay | North Carolina | 37043 | 5 | 0 |
162062 | 162062 | 2020-05-20 | Clay | North Carolina | 37043 | 5 | 0 |
165091 | 165091 | 2020-05-21 | Clay | North Carolina | 37043 | 5 | 0 |
168126 | 168126 | 2020-05-22 | Clay | North Carolina | 37043 | 5 | 0 |
171165 | 171165 | 2020-05-23 | Clay | North Carolina | 37043 | 5 | 0 |
174207 | 174207 | 2020-05-24 | Clay | North Carolina | 37043 | 5 | 0 |
177251 | 177251 | 2020-05-25 | Clay | North Carolina | 37043 | 5 | 0 |
180294 | 180294 | 2020-05-26 | Clay | North Carolina | 37043 | 5 | 0 |
183342 | 183342 | 2020-05-27 | Clay | North Carolina | 37043 | 5 | 0 |
186399 | 186399 | 2020-05-28 | Clay | North Carolina | 37043 | 5 | 0 |
189459 | 189459 | 2020-05-29 | Clay | North Carolina | 37043 | 5 | 0 |
192523 | 192523 | 2020-05-30 | Clay | North Carolina | 37043 | 5 | 0 |
195593 | 195593 | 2020-05-31 | Clay | North Carolina | 37043 | 5 | 0 |
198666 | 198666 | 2020-06-01 | Clay | North Carolina | 37043 | 5 | 0 |
201740 | 201740 | 2020-06-02 | Clay | North Carolina | 37043 | 5 | 0 |
204817 | 204817 | 2020-06-03 | Clay | North Carolina | 37043 | 5 | 0 |
207898 | 207898 | 2020-06-04 | Clay | North Carolina | 37043 | 5 | 0 |
210980 | 210980 | 2020-06-05 | Clay | North Carolina | 37043 | 5 | 0 |
214064 | 214064 | 2020-06-06 | Clay | North Carolina | 37043 | 5 | 0 |
217154 | 217154 | 2020-06-07 | Clay | North Carolina | 37043 | 5 | 0 |
220246 | 220246 | 2020-06-08 | Clay | North Carolina | 37043 | 6 | 0 |
223340 | 223340 | 2020-06-09 | Clay | North Carolina | 37043 | 8 | 0 |
226440 | 226440 | 2020-06-10 | Clay | North Carolina | 37043 | 8 | 0 |
229544 | 229544 | 2020-06-11 | Clay | North Carolina | 37043 | 8 | 0 |
232649 | 232649 | 2020-06-12 | Clay | North Carolina | 37043 | 8 | 0 |
235754 | 235754 | 2020-06-13 | Clay | North Carolina | 37043 | 9 | 0 |
238862 | 238862 | 2020-06-14 | Clay | North Carolina | 37043 | 9 | 0 |
241971 | 241971 | 2020-06-15 | Clay | North Carolina | 37043 | 9 | 0 |
245083 | 245083 | 2020-06-16 | Clay | North Carolina | 37043 | 9 | 0 |
248196 | 248196 | 2020-06-17 | Clay | North Carolina | 37043 | 9 | 0 |
251311 | 251311 | 2020-06-18 | Clay | North Carolina | 37043 | 9 | 0 |
254426 | 254426 | 2020-06-19 | Clay | North Carolina | 37043 | 9 | 0 |
257549 | 257549 | 2020-06-20 | Clay | North Carolina | 37043 | 9 | 0 |
260676 | 260676 | 2020-06-21 | Clay | North Carolina | 37043 | 9 | 0 |
263804 | 263804 | 2020-06-22 | Clay | North Carolina | 37043 | 9 | 0 |
266932 | 266932 | 2020-06-23 | Clay | North Carolina | 37043 | 9 | 0 |
270066 | 270066 | 2020-06-24 | Clay | North Carolina | 37043 | 9 | 0 |
273205 | 273205 | 2020-06-25 | Clay | North Carolina | 37043 | 9 | 0 |
276351 | 276351 | 2020-06-26 | Clay | North Carolina | 37043 | 9 | 0 |
279499 | 279499 | 2020-06-27 | Clay | North Carolina | 37043 | 9 | 0 |
282645 | 282645 | 2020-06-28 | Clay | North Carolina | 37043 | 9 | 0 |
285790 | 285790 | 2020-06-29 | Clay | North Carolina | 37043 | 9 | 0 |
288940 | 288940 | 2020-06-30 | Clay | North Carolina | 37043 | 10 | 0 |
292092 | 292092 | 2020-07-01 | Clay | North Carolina | 37043 | 10 | 0 |
295247 | 295247 | 2020-07-02 | Clay | North Carolina | 37043 | 10 | 0 |
298407 | 298407 | 2020-07-03 | Clay | North Carolina | 37043 | 12 | 0 |
301570 | 301570 | 2020-07-04 | Clay | North Carolina | 37043 | 12 | 0 |
304733 | 304733 | 2020-07-05 | Clay | North Carolina | 37043 | 12 | 0 |
307900 | 307900 | 2020-07-06 | Clay | North Carolina | 37043 | 12 | 0 |
311068 | 311068 | 2020-07-07 | Clay | North Carolina | 37043 | 11 | 0 |
314239 | 314239 | 2020-07-08 | Clay | North Carolina | 37043 | 11 | 0 |
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);