ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Caldwell" and state = "North Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11792 | 11792 | 2020-03-25 | Caldwell | North Carolina | 37027 | 1 | 0 |
13396 | 13396 | 2020-03-26 | Caldwell | North Carolina | 37027 | 3 | 0 |
15130 | 15130 | 2020-03-27 | Caldwell | North Carolina | 37027 | 3 | 0 |
16961 | 16961 | 2020-03-28 | Caldwell | North Carolina | 37027 | 3 | 0 |
18888 | 18888 | 2020-03-29 | Caldwell | North Carolina | 37027 | 3 | 0 |
20928 | 20928 | 2020-03-30 | Caldwell | North Carolina | 37027 | 3 | 0 |
23053 | 23053 | 2020-03-31 | Caldwell | North Carolina | 37027 | 3 | 0 |
25247 | 25247 | 2020-04-01 | Caldwell | North Carolina | 37027 | 3 | 0 |
27508 | 27508 | 2020-04-02 | Caldwell | North Carolina | 37027 | 3 | 0 |
29833 | 29833 | 2020-04-03 | Caldwell | North Carolina | 37027 | 3 | 0 |
32220 | 32220 | 2020-04-04 | Caldwell | North Carolina | 37027 | 5 | 0 |
34651 | 34651 | 2020-04-05 | Caldwell | North Carolina | 37027 | 6 | 0 |
37120 | 37120 | 2020-04-06 | Caldwell | North Carolina | 37027 | 9 | 0 |
39635 | 39635 | 2020-04-07 | Caldwell | North Carolina | 37027 | 10 | 0 |
42192 | 42192 | 2020-04-08 | Caldwell | North Carolina | 37027 | 10 | 0 |
44775 | 44775 | 2020-04-09 | Caldwell | North Carolina | 37027 | 11 | 0 |
47388 | 47388 | 2020-04-10 | Caldwell | North Carolina | 37027 | 14 | 0 |
50043 | 50043 | 2020-04-11 | Caldwell | North Carolina | 37027 | 15 | 0 |
52716 | 52716 | 2020-04-12 | Caldwell | North Carolina | 37027 | 17 | 0 |
55399 | 55399 | 2020-04-13 | Caldwell | North Carolina | 37027 | 19 | 0 |
58099 | 58099 | 2020-04-14 | Caldwell | North Carolina | 37027 | 19 | 0 |
60813 | 60813 | 2020-04-15 | Caldwell | North Carolina | 37027 | 19 | 0 |
63539 | 63539 | 2020-04-16 | Caldwell | North Carolina | 37027 | 19 | 0 |
66282 | 66282 | 2020-04-17 | Caldwell | North Carolina | 37027 | 22 | 0 |
69039 | 69039 | 2020-04-18 | Caldwell | North Carolina | 37027 | 21 | 0 |
71805 | 71805 | 2020-04-19 | Caldwell | North Carolina | 37027 | 22 | 0 |
74580 | 74580 | 2020-04-20 | Caldwell | North Carolina | 37027 | 23 | 0 |
77361 | 77361 | 2020-04-21 | Caldwell | North Carolina | 37027 | 23 | 0 |
80150 | 80150 | 2020-04-22 | Caldwell | North Carolina | 37027 | 23 | 0 |
82949 | 82949 | 2020-04-23 | Caldwell | North Carolina | 37027 | 26 | 0 |
85753 | 85753 | 2020-04-24 | Caldwell | North Carolina | 37027 | 27 | 0 |
88565 | 88565 | 2020-04-25 | Caldwell | North Carolina | 37027 | 30 | 0 |
91380 | 91380 | 2020-04-26 | Caldwell | North Carolina | 37027 | 30 | 0 |
94205 | 94205 | 2020-04-27 | Caldwell | North Carolina | 37027 | 31 | 0 |
97041 | 97041 | 2020-04-28 | Caldwell | North Carolina | 37027 | 33 | 0 |
99888 | 99888 | 2020-04-29 | Caldwell | North Carolina | 37027 | 32 | 0 |
102741 | 102741 | 2020-04-30 | Caldwell | North Carolina | 37027 | 32 | 0 |
105603 | 105603 | 2020-05-01 | Caldwell | North Carolina | 37027 | 34 | 0 |
108470 | 108470 | 2020-05-02 | Caldwell | North Carolina | 37027 | 34 | 0 |
111343 | 111343 | 2020-05-03 | Caldwell | North Carolina | 37027 | 36 | 0 |
114224 | 114224 | 2020-05-04 | Caldwell | North Carolina | 37027 | 36 | 0 |
117104 | 117104 | 2020-05-05 | Caldwell | North Carolina | 37027 | 44 | 0 |
120065 | 120065 | 2020-05-06 | Caldwell | North Carolina | 37027 | 43 | 0 |
123040 | 123040 | 2020-05-07 | Caldwell | North Carolina | 37027 | 50 | 0 |
126023 | 126023 | 2020-05-08 | Caldwell | North Carolina | 37027 | 52 | 0 |
129012 | 129012 | 2020-05-09 | Caldwell | North Carolina | 37027 | 55 | 0 |
132001 | 132001 | 2020-05-10 | Caldwell | North Carolina | 37027 | 60 | 0 |
134992 | 134992 | 2020-05-11 | Caldwell | North Carolina | 37027 | 60 | 0 |
137982 | 137982 | 2020-05-12 | Caldwell | North Carolina | 37027 | 63 | 0 |
140978 | 140978 | 2020-05-13 | Caldwell | North Carolina | 37027 | 67 | 1 |
143973 | 143973 | 2020-05-14 | Caldwell | North Carolina | 37027 | 71 | 1 |
146974 | 146974 | 2020-05-15 | Caldwell | North Carolina | 37027 | 74 | 1 |
149981 | 149981 | 2020-05-16 | Caldwell | North Carolina | 37027 | 78 | 2 |
152991 | 152991 | 2020-05-17 | Caldwell | North Carolina | 37027 | 83 | 2 |
156008 | 156008 | 2020-05-18 | Caldwell | North Carolina | 37027 | 86 | 2 |
159027 | 159027 | 2020-05-19 | Caldwell | North Carolina | 37027 | 92 | 2 |
162054 | 162054 | 2020-05-20 | Caldwell | North Carolina | 37027 | 90 | 2 |
165083 | 165083 | 2020-05-21 | Caldwell | North Carolina | 37027 | 93 | 2 |
168118 | 168118 | 2020-05-22 | Caldwell | North Carolina | 37027 | 96 | 2 |
171157 | 171157 | 2020-05-23 | Caldwell | North Carolina | 37027 | 105 | 2 |
174199 | 174199 | 2020-05-24 | Caldwell | North Carolina | 37027 | 106 | 2 |
177243 | 177243 | 2020-05-25 | Caldwell | North Carolina | 37027 | 107 | 2 |
180286 | 180286 | 2020-05-26 | Caldwell | North Carolina | 37027 | 107 | 2 |
183334 | 183334 | 2020-05-27 | Caldwell | North Carolina | 37027 | 110 | 2 |
186391 | 186391 | 2020-05-28 | Caldwell | North Carolina | 37027 | 120 | 2 |
189451 | 189451 | 2020-05-29 | Caldwell | North Carolina | 37027 | 127 | 2 |
192515 | 192515 | 2020-05-30 | Caldwell | North Carolina | 37027 | 132 | 3 |
195585 | 195585 | 2020-05-31 | Caldwell | North Carolina | 37027 | 138 | 3 |
198658 | 198658 | 2020-06-01 | Caldwell | North Carolina | 37027 | 155 | 3 |
201732 | 201732 | 2020-06-02 | Caldwell | North Carolina | 37027 | 157 | 3 |
204809 | 204809 | 2020-06-03 | Caldwell | North Carolina | 37027 | 160 | 3 |
207890 | 207890 | 2020-06-04 | Caldwell | North Carolina | 37027 | 172 | 3 |
210972 | 210972 | 2020-06-05 | Caldwell | North Carolina | 37027 | 183 | 3 |
214056 | 214056 | 2020-06-06 | Caldwell | North Carolina | 37027 | 196 | 3 |
217146 | 217146 | 2020-06-07 | Caldwell | North Carolina | 37027 | 201 | 3 |
220238 | 220238 | 2020-06-08 | Caldwell | North Carolina | 37027 | 204 | 3 |
223332 | 223332 | 2020-06-09 | Caldwell | North Carolina | 37027 | 214 | 3 |
226432 | 226432 | 2020-06-10 | Caldwell | North Carolina | 37027 | 219 | 3 |
229536 | 229536 | 2020-06-11 | Caldwell | North Carolina | 37027 | 228 | 3 |
232641 | 232641 | 2020-06-12 | Caldwell | North Carolina | 37027 | 238 | 3 |
235746 | 235746 | 2020-06-13 | Caldwell | North Carolina | 37027 | 240 | 3 |
238854 | 238854 | 2020-06-14 | Caldwell | North Carolina | 37027 | 248 | 3 |
241963 | 241963 | 2020-06-15 | Caldwell | North Carolina | 37027 | 249 | 3 |
245075 | 245075 | 2020-06-16 | Caldwell | North Carolina | 37027 | 252 | 4 |
248188 | 248188 | 2020-06-17 | Caldwell | North Carolina | 37027 | 258 | 4 |
251303 | 251303 | 2020-06-18 | Caldwell | North Carolina | 37027 | 273 | 4 |
254418 | 254418 | 2020-06-19 | Caldwell | North Carolina | 37027 | 296 | 4 |
257541 | 257541 | 2020-06-20 | Caldwell | North Carolina | 37027 | 304 | 4 |
260668 | 260668 | 2020-06-21 | Caldwell | North Carolina | 37027 | 314 | 4 |
263796 | 263796 | 2020-06-22 | Caldwell | North Carolina | 37027 | 315 | 4 |
266924 | 266924 | 2020-06-23 | Caldwell | North Carolina | 37027 | 322 | 4 |
270058 | 270058 | 2020-06-24 | Caldwell | North Carolina | 37027 | 328 | 4 |
273197 | 273197 | 2020-06-25 | Caldwell | North Carolina | 37027 | 335 | 4 |
276343 | 276343 | 2020-06-26 | Caldwell | North Carolina | 37027 | 348 | 4 |
279491 | 279491 | 2020-06-27 | Caldwell | North Carolina | 37027 | 358 | 4 |
282637 | 282637 | 2020-06-28 | Caldwell | North Carolina | 37027 | 398 | 4 |
285782 | 285782 | 2020-06-29 | Caldwell | North Carolina | 37027 | 411 | 4 |
288932 | 288932 | 2020-06-30 | Caldwell | North Carolina | 37027 | 419 | 4 |
292084 | 292084 | 2020-07-01 | Caldwell | North Carolina | 37027 | 434 | 4 |
295239 | 295239 | 2020-07-02 | Caldwell | North Carolina | 37027 | 452 | 4 |
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);