ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Carteret" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387836 | 387836 | 2020-07-31 | Carteret | North Carolina | 37031 | 284 | 4 |
384619 | 384619 | 2020-07-30 | Carteret | North Carolina | 37031 | 279 | 4 |
381401 | 381401 | 2020-07-29 | Carteret | North Carolina | 37031 | 272 | 4 |
378184 | 378184 | 2020-07-28 | Carteret | North Carolina | 37031 | 271 | 4 |
374968 | 374968 | 2020-07-27 | Carteret | North Carolina | 37031 | 267 | 4 |
371756 | 371756 | 2020-07-26 | Carteret | North Carolina | 37031 | 262 | 4 |
368544 | 368544 | 2020-07-25 | Carteret | North Carolina | 37031 | 238 | 4 |
365335 | 365335 | 2020-07-24 | Carteret | North Carolina | 37031 | 210 | 4 |
362129 | 362129 | 2020-07-23 | Carteret | North Carolina | 37031 | 180 | 4 |
358923 | 358923 | 2020-07-22 | Carteret | North Carolina | 37031 | 178 | 4 |
355719 | 355719 | 2020-07-21 | Carteret | North Carolina | 37031 | 176 | 4 |
352516 | 352516 | 2020-07-20 | Carteret | North Carolina | 37031 | 178 | 4 |
349313 | 349313 | 2020-07-19 | Carteret | North Carolina | 37031 | 176 | 4 |
346112 | 346112 | 2020-07-18 | Carteret | North Carolina | 37031 | 173 | 4 |
342913 | 342913 | 2020-07-17 | Carteret | North Carolina | 37031 | 168 | 4 |
339715 | 339715 | 2020-07-16 | Carteret | North Carolina | 37031 | 164 | 4 |
336519 | 336519 | 2020-07-15 | Carteret | North Carolina | 37031 | 152 | 3 |
333325 | 333325 | 2020-07-14 | Carteret | North Carolina | 37031 | 144 | 3 |
330135 | 330135 | 2020-07-13 | Carteret | North Carolina | 37031 | 136 | 3 |
326948 | 326948 | 2020-07-12 | Carteret | North Carolina | 37031 | 130 | 3 |
323764 | 323764 | 2020-07-11 | Carteret | North Carolina | 37031 | 121 | 3 |
320584 | 320584 | 2020-07-10 | Carteret | North Carolina | 37031 | 117 | 3 |
317407 | 317407 | 2020-07-09 | Carteret | North Carolina | 37031 | 111 | 3 |
314233 | 314233 | 2020-07-08 | Carteret | North Carolina | 37031 | 111 | 3 |
311062 | 311062 | 2020-07-07 | Carteret | North Carolina | 37031 | 110 | 3 |
307894 | 307894 | 2020-07-06 | Carteret | North Carolina | 37031 | 109 | 3 |
304727 | 304727 | 2020-07-05 | Carteret | North Carolina | 37031 | 105 | 3 |
301564 | 301564 | 2020-07-04 | Carteret | North Carolina | 37031 | 101 | 3 |
298401 | 298401 | 2020-07-03 | Carteret | North Carolina | 37031 | 100 | 3 |
295241 | 295241 | 2020-07-02 | Carteret | North Carolina | 37031 | 91 | 3 |
292086 | 292086 | 2020-07-01 | Carteret | North Carolina | 37031 | 87 | 3 |
288934 | 288934 | 2020-06-30 | Carteret | North Carolina | 37031 | 87 | 3 |
285784 | 285784 | 2020-06-29 | Carteret | North Carolina | 37031 | 84 | 3 |
282639 | 282639 | 2020-06-28 | Carteret | North Carolina | 37031 | 76 | 3 |
279493 | 279493 | 2020-06-27 | Carteret | North Carolina | 37031 | 70 | 3 |
276345 | 276345 | 2020-06-26 | Carteret | North Carolina | 37031 | 67 | 3 |
273199 | 273199 | 2020-06-25 | Carteret | North Carolina | 37031 | 64 | 3 |
270060 | 270060 | 2020-06-24 | Carteret | North Carolina | 37031 | 61 | 3 |
266926 | 266926 | 2020-06-23 | Carteret | North Carolina | 37031 | 59 | 3 |
263798 | 263798 | 2020-06-22 | Carteret | North Carolina | 37031 | 57 | 3 |
260670 | 260670 | 2020-06-21 | Carteret | North Carolina | 37031 | 53 | 3 |
257543 | 257543 | 2020-06-20 | Carteret | North Carolina | 37031 | 52 | 3 |
254420 | 254420 | 2020-06-19 | Carteret | North Carolina | 37031 | 51 | 3 |
251305 | 251305 | 2020-06-18 | Carteret | North Carolina | 37031 | 49 | 3 |
248190 | 248190 | 2020-06-17 | Carteret | North Carolina | 37031 | 47 | 3 |
245077 | 245077 | 2020-06-16 | Carteret | North Carolina | 37031 | 48 | 3 |
241965 | 241965 | 2020-06-15 | Carteret | North Carolina | 37031 | 47 | 3 |
238856 | 238856 | 2020-06-14 | Carteret | North Carolina | 37031 | 46 | 3 |
235748 | 235748 | 2020-06-13 | Carteret | North Carolina | 37031 | 46 | 3 |
232643 | 232643 | 2020-06-12 | Carteret | North Carolina | 37031 | 45 | 3 |
229538 | 229538 | 2020-06-11 | Carteret | North Carolina | 37031 | 43 | 3 |
226434 | 226434 | 2020-06-10 | Carteret | North Carolina | 37031 | 42 | 3 |
223334 | 223334 | 2020-06-09 | Carteret | North Carolina | 37031 | 40 | 3 |
220240 | 220240 | 2020-06-08 | Carteret | North Carolina | 37031 | 40 | 3 |
217148 | 217148 | 2020-06-07 | Carteret | North Carolina | 37031 | 39 | 3 |
214058 | 214058 | 2020-06-06 | Carteret | North Carolina | 37031 | 39 | 3 |
210974 | 210974 | 2020-06-05 | Carteret | North Carolina | 37031 | 39 | 3 |
207892 | 207892 | 2020-06-04 | Carteret | North Carolina | 37031 | 37 | 3 |
204811 | 204811 | 2020-06-03 | Carteret | North Carolina | 37031 | 36 | 3 |
201734 | 201734 | 2020-06-02 | Carteret | North Carolina | 37031 | 36 | 3 |
198660 | 198660 | 2020-06-01 | Carteret | North Carolina | 37031 | 36 | 3 |
195587 | 195587 | 2020-05-31 | Carteret | North Carolina | 37031 | 36 | 3 |
192517 | 192517 | 2020-05-30 | Carteret | North Carolina | 37031 | 36 | 3 |
189453 | 189453 | 2020-05-29 | Carteret | North Carolina | 37031 | 36 | 3 |
186393 | 186393 | 2020-05-28 | Carteret | North Carolina | 37031 | 36 | 3 |
183336 | 183336 | 2020-05-27 | Carteret | North Carolina | 37031 | 36 | 3 |
180288 | 180288 | 2020-05-26 | Carteret | North Carolina | 37031 | 36 | 3 |
177245 | 177245 | 2020-05-25 | Carteret | North Carolina | 37031 | 36 | 3 |
174201 | 174201 | 2020-05-24 | Carteret | North Carolina | 37031 | 35 | 9 |
171159 | 171159 | 2020-05-23 | Carteret | North Carolina | 37031 | 35 | 9 |
168120 | 168120 | 2020-05-22 | Carteret | North Carolina | 37031 | 35 | 9 |
165085 | 165085 | 2020-05-21 | Carteret | North Carolina | 37031 | 35 | 3 |
162056 | 162056 | 2020-05-20 | Carteret | North Carolina | 37031 | 35 | 3 |
159029 | 159029 | 2020-05-19 | Carteret | North Carolina | 37031 | 35 | 3 |
156010 | 156010 | 2020-05-18 | Carteret | North Carolina | 37031 | 35 | 3 |
152993 | 152993 | 2020-05-17 | Carteret | North Carolina | 37031 | 35 | 3 |
149983 | 149983 | 2020-05-16 | Carteret | North Carolina | 37031 | 35 | 3 |
146976 | 146976 | 2020-05-15 | Carteret | North Carolina | 37031 | 35 | 3 |
143975 | 143975 | 2020-05-14 | Carteret | North Carolina | 37031 | 34 | 3 |
140980 | 140980 | 2020-05-13 | Carteret | North Carolina | 37031 | 34 | 3 |
137984 | 137984 | 2020-05-12 | Carteret | North Carolina | 37031 | 32 | 3 |
134994 | 134994 | 2020-05-11 | Carteret | North Carolina | 37031 | 31 | 3 |
132003 | 132003 | 2020-05-10 | Carteret | North Carolina | 37031 | 31 | 3 |
129014 | 129014 | 2020-05-09 | Carteret | North Carolina | 37031 | 29 | 3 |
126025 | 126025 | 2020-05-08 | Carteret | North Carolina | 37031 | 29 | 3 |
123042 | 123042 | 2020-05-07 | Carteret | North Carolina | 37031 | 29 | 3 |
120067 | 120067 | 2020-05-06 | Carteret | North Carolina | 37031 | 28 | 3 |
117106 | 117106 | 2020-05-05 | Carteret | North Carolina | 37031 | 27 | 3 |
114226 | 114226 | 2020-05-04 | Carteret | North Carolina | 37031 | 27 | 3 |
111345 | 111345 | 2020-05-03 | Carteret | North Carolina | 37031 | 27 | 3 |
108472 | 108472 | 2020-05-02 | Carteret | North Carolina | 37031 | 27 | 3 |
105605 | 105605 | 2020-05-01 | Carteret | North Carolina | 37031 | 29 | 3 |
102743 | 102743 | 2020-04-30 | Carteret | North Carolina | 37031 | 27 | 3 |
99890 | 99890 | 2020-04-29 | Carteret | North Carolina | 37031 | 27 | 3 |
97043 | 97043 | 2020-04-28 | Carteret | North Carolina | 37031 | 28 | 3 |
94207 | 94207 | 2020-04-27 | Carteret | North Carolina | 37031 | 28 | 3 |
91381 | 91381 | 2020-04-26 | Carteret | North Carolina | 37031 | 26 | 3 |
88566 | 88566 | 2020-04-25 | Carteret | North Carolina | 37031 | 26 | 3 |
85754 | 85754 | 2020-04-24 | Carteret | North Carolina | 37031 | 22 | 2 |
82950 | 82950 | 2020-04-23 | Carteret | North Carolina | 37031 | 22 | 2 |
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);