ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 37145 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 |
---|---|---|---|---|---|---|---|
536391 | 536391 | 2020-09-15 | Person | North Carolina | 37145 | 385 | 6 |
533155 | 533155 | 2020-09-14 | Person | North Carolina | 37145 | 384 | 6 |
529920 | 529920 | 2020-09-13 | Person | North Carolina | 37145 | 383 | 6 |
526683 | 526683 | 2020-09-12 | Person | North Carolina | 37145 | 379 | 6 |
523447 | 523447 | 2020-09-11 | Person | North Carolina | 37145 | 376 | 6 |
520211 | 520211 | 2020-09-10 | Person | North Carolina | 37145 | 366 | 6 |
516975 | 516975 | 2020-09-09 | Person | North Carolina | 37145 | 360 | 6 |
513740 | 513740 | 2020-09-08 | Person | North Carolina | 37145 | 358 | 6 |
510507 | 510507 | 2020-09-07 | Person | North Carolina | 37145 | 357 | 6 |
507274 | 507274 | 2020-09-06 | Person | North Carolina | 37145 | 356 | 6 |
504042 | 504042 | 2020-09-05 | Person | North Carolina | 37145 | 354 | 6 |
500808 | 500808 | 2020-09-04 | Person | North Carolina | 37145 | 347 | 6 |
497574 | 497574 | 2020-09-03 | Person | North Carolina | 37145 | 343 | 6 |
494341 | 494341 | 2020-09-02 | Person | North Carolina | 37145 | 336 | 5 |
491107 | 491107 | 2020-09-01 | Person | North Carolina | 37145 | 332 | 5 |
487874 | 487874 | 2020-08-31 | Person | North Carolina | 37145 | 323 | 5 |
484641 | 484641 | 2020-08-30 | Person | North Carolina | 37145 | 322 | 5 |
481406 | 481406 | 2020-08-29 | Person | North Carolina | 37145 | 316 | 5 |
478173 | 478173 | 2020-08-28 | Person | North Carolina | 37145 | 307 | 3 |
474940 | 474940 | 2020-08-27 | Person | North Carolina | 37145 | 302 | 3 |
471706 | 471706 | 2020-08-26 | Person | North Carolina | 37145 | 298 | 2 |
468474 | 468474 | 2020-08-25 | Person | North Carolina | 37145 | 282 | 2 |
465246 | 465246 | 2020-08-24 | Person | North Carolina | 37145 | 279 | 2 |
462017 | 462017 | 2020-08-23 | Person | North Carolina | 37145 | 276 | 2 |
458789 | 458789 | 2020-08-22 | Person | North Carolina | 37145 | 271 | 2 |
455561 | 455561 | 2020-08-21 | Person | North Carolina | 37145 | 265 | 2 |
452333 | 452333 | 2020-08-20 | Person | North Carolina | 37145 | 259 | 2 |
449105 | 449105 | 2020-08-19 | Person | North Carolina | 37145 | 252 | 2 |
445877 | 445877 | 2020-08-18 | Person | North Carolina | 37145 | 250 | 2 |
442651 | 442651 | 2020-08-17 | Person | North Carolina | 37145 | 247 | 2 |
439424 | 439424 | 2020-08-16 | Person | North Carolina | 37145 | 247 | 2 |
436199 | 436199 | 2020-08-15 | Person | North Carolina | 37145 | 243 | 2 |
432973 | 432973 | 2020-08-14 | Person | North Carolina | 37145 | 237 | 2 |
429747 | 429747 | 2020-08-13 | Person | North Carolina | 37145 | 234 | 2 |
426522 | 426522 | 2020-08-12 | Person | North Carolina | 37145 | 228 | 2 |
423299 | 423299 | 2020-08-11 | Person | North Carolina | 37145 | 226 | 2 |
420076 | 420076 | 2020-08-10 | Person | North Carolina | 37145 | 223 | 2 |
416856 | 416856 | 2020-08-09 | Person | North Carolina | 37145 | 223 | 2 |
413635 | 413635 | 2020-08-08 | Person | North Carolina | 37145 | 208 | 2 |
410415 | 410415 | 2020-08-07 | Person | North Carolina | 37145 | 207 | 2 |
407195 | 407195 | 2020-08-06 | Person | North Carolina | 37145 | 203 | 2 |
403976 | 403976 | 2020-08-05 | Person | North Carolina | 37145 | 202 | 2 |
400758 | 400758 | 2020-08-04 | Person | North Carolina | 37145 | 201 | 2 |
397543 | 397543 | 2020-08-03 | Person | North Carolina | 37145 | 201 | 2 |
394326 | 394326 | 2020-08-02 | Person | North Carolina | 37145 | 193 | 2 |
391110 | 391110 | 2020-08-01 | Person | North Carolina | 37145 | 191 | 2 |
387893 | 387893 | 2020-07-31 | Person | North Carolina | 37145 | 189 | 2 |
384676 | 384676 | 2020-07-30 | Person | North Carolina | 37145 | 187 | 2 |
381458 | 381458 | 2020-07-29 | Person | North Carolina | 37145 | 186 | 1 |
378241 | 378241 | 2020-07-28 | Person | North Carolina | 37145 | 185 | 1 |
375025 | 375025 | 2020-07-27 | Person | North Carolina | 37145 | 176 | 1 |
371813 | 371813 | 2020-07-26 | Person | North Carolina | 37145 | 174 | 1 |
368601 | 368601 | 2020-07-25 | Person | North Carolina | 37145 | 169 | 1 |
365392 | 365392 | 2020-07-24 | Person | North Carolina | 37145 | 167 | 1 |
362186 | 362186 | 2020-07-23 | Person | North Carolina | 37145 | 159 | 1 |
358980 | 358980 | 2020-07-22 | Person | North Carolina | 37145 | 157 | 1 |
355776 | 355776 | 2020-07-21 | Person | North Carolina | 37145 | 151 | 1 |
352573 | 352573 | 2020-07-20 | Person | North Carolina | 37145 | 144 | 1 |
349370 | 349370 | 2020-07-19 | Person | North Carolina | 37145 | 143 | 1 |
346169 | 346169 | 2020-07-18 | Person | North Carolina | 37145 | 141 | 1 |
342970 | 342970 | 2020-07-17 | Person | North Carolina | 37145 | 139 | 1 |
339772 | 339772 | 2020-07-16 | Person | North Carolina | 37145 | 136 | 1 |
336576 | 336576 | 2020-07-15 | Person | North Carolina | 37145 | 135 | 1 |
333382 | 333382 | 2020-07-14 | Person | North Carolina | 37145 | 134 | 1 |
330192 | 330192 | 2020-07-13 | Person | North Carolina | 37145 | 131 | 1 |
327005 | 327005 | 2020-07-12 | Person | North Carolina | 37145 | 130 | 1 |
323821 | 323821 | 2020-07-11 | Person | North Carolina | 37145 | 128 | 1 |
320641 | 320641 | 2020-07-10 | Person | North Carolina | 37145 | 127 | 1 |
317464 | 317464 | 2020-07-09 | Person | North Carolina | 37145 | 125 | 1 |
314290 | 314290 | 2020-07-08 | Person | North Carolina | 37145 | 124 | 1 |
311119 | 311119 | 2020-07-07 | Person | North Carolina | 37145 | 123 | 1 |
307951 | 307951 | 2020-07-06 | Person | North Carolina | 37145 | 120 | 1 |
304784 | 304784 | 2020-07-05 | Person | North Carolina | 37145 | 117 | 1 |
301621 | 301621 | 2020-07-04 | Person | North Carolina | 37145 | 114 | 1 |
298458 | 298458 | 2020-07-03 | Person | North Carolina | 37145 | 112 | 1 |
295298 | 295298 | 2020-07-02 | Person | North Carolina | 37145 | 107 | 1 |
292143 | 292143 | 2020-07-01 | Person | North Carolina | 37145 | 107 | 1 |
288991 | 288991 | 2020-06-30 | Person | North Carolina | 37145 | 106 | 1 |
285841 | 285841 | 2020-06-29 | Person | North Carolina | 37145 | 107 | 1 |
282696 | 282696 | 2020-06-28 | Person | North Carolina | 37145 | 104 | 1 |
279550 | 279550 | 2020-06-27 | Person | North Carolina | 37145 | 103 | 1 |
276402 | 276402 | 2020-06-26 | Person | North Carolina | 37145 | 100 | 1 |
273256 | 273256 | 2020-06-25 | Person | North Carolina | 37145 | 96 | 1 |
270117 | 270117 | 2020-06-24 | Person | North Carolina | 37145 | 97 | 1 |
266983 | 266983 | 2020-06-23 | Person | North Carolina | 37145 | 92 | 1 |
263855 | 263855 | 2020-06-22 | Person | North Carolina | 37145 | 92 | 1 |
260727 | 260727 | 2020-06-21 | Person | North Carolina | 37145 | 92 | 1 |
257600 | 257600 | 2020-06-20 | Person | North Carolina | 37145 | 91 | 1 |
254477 | 254477 | 2020-06-19 | Person | North Carolina | 37145 | 88 | 1 |
251362 | 251362 | 2020-06-18 | Person | North Carolina | 37145 | 86 | 1 |
248247 | 248247 | 2020-06-17 | Person | North Carolina | 37145 | 83 | 1 |
245134 | 245134 | 2020-06-16 | Person | North Carolina | 37145 | 82 | 1 |
242022 | 242022 | 2020-06-15 | Person | North Carolina | 37145 | 79 | 1 |
238913 | 238913 | 2020-06-14 | Person | North Carolina | 37145 | 79 | 1 |
235805 | 235805 | 2020-06-13 | Person | North Carolina | 37145 | 73 | 1 |
232700 | 232700 | 2020-06-12 | Person | North Carolina | 37145 | 72 | 1 |
229595 | 229595 | 2020-06-11 | Person | North Carolina | 37145 | 70 | 1 |
226491 | 226491 | 2020-06-10 | Person | North Carolina | 37145 | 65 | 1 |
223391 | 223391 | 2020-06-09 | Person | North Carolina | 37145 | 63 | 1 |
220297 | 220297 | 2020-06-08 | Person | North Carolina | 37145 | 61 | 1 |
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);