ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Gaston" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536354 | 536354 | 2020-09-15 | Gaston | North Carolina | 37071 | 4600 | 74 |
533118 | 533118 | 2020-09-14 | Gaston | North Carolina | 37071 | 4568 | 70 |
529883 | 529883 | 2020-09-13 | Gaston | North Carolina | 37071 | 4546 | 70 |
526646 | 526646 | 2020-09-12 | Gaston | North Carolina | 37071 | 4515 | 69 |
523410 | 523410 | 2020-09-11 | Gaston | North Carolina | 37071 | 4464 | 68 |
520174 | 520174 | 2020-09-10 | Gaston | North Carolina | 37071 | 4424 | 67 |
516938 | 516938 | 2020-09-09 | Gaston | North Carolina | 37071 | 4388 | 67 |
513703 | 513703 | 2020-09-08 | Gaston | North Carolina | 37071 | 4348 | 67 |
510470 | 510470 | 2020-09-07 | Gaston | North Carolina | 37071 | 4325 | 66 |
507237 | 507237 | 2020-09-06 | Gaston | North Carolina | 37071 | 4304 | 66 |
504005 | 504005 | 2020-09-05 | Gaston | North Carolina | 37071 | 4283 | 66 |
500771 | 500771 | 2020-09-04 | Gaston | North Carolina | 37071 | 4247 | 66 |
497537 | 497537 | 2020-09-03 | Gaston | North Carolina | 37071 | 4208 | 66 |
494304 | 494304 | 2020-09-02 | Gaston | North Carolina | 37071 | 4149 | 66 |
491070 | 491070 | 2020-09-01 | Gaston | North Carolina | 37071 | 4126 | 63 |
487837 | 487837 | 2020-08-31 | Gaston | North Carolina | 37071 | 4091 | 63 |
484604 | 484604 | 2020-08-30 | Gaston | North Carolina | 37071 | 4068 | 63 |
481369 | 481369 | 2020-08-29 | Gaston | North Carolina | 37071 | 4052 | 63 |
478136 | 478136 | 2020-08-28 | Gaston | North Carolina | 37071 | 3969 | 63 |
474903 | 474903 | 2020-08-27 | Gaston | North Carolina | 37071 | 3946 | 63 |
471669 | 471669 | 2020-08-26 | Gaston | North Carolina | 37071 | 3910 | 62 |
468437 | 468437 | 2020-08-25 | Gaston | North Carolina | 37071 | 3877 | 62 |
465209 | 465209 | 2020-08-24 | Gaston | North Carolina | 37071 | 3846 | 61 |
461980 | 461980 | 2020-08-23 | Gaston | North Carolina | 37071 | 3814 | 61 |
458752 | 458752 | 2020-08-22 | Gaston | North Carolina | 37071 | 3783 | 60 |
455524 | 455524 | 2020-08-21 | Gaston | North Carolina | 37071 | 3746 | 59 |
452296 | 452296 | 2020-08-20 | Gaston | North Carolina | 37071 | 3716 | 59 |
449068 | 449068 | 2020-08-19 | Gaston | North Carolina | 37071 | 3655 | 58 |
445840 | 445840 | 2020-08-18 | Gaston | North Carolina | 37071 | 3636 | 58 |
442614 | 442614 | 2020-08-17 | Gaston | North Carolina | 37071 | 3579 | 57 |
439387 | 439387 | 2020-08-16 | Gaston | North Carolina | 37071 | 3570 | 57 |
436162 | 436162 | 2020-08-15 | Gaston | North Carolina | 37071 | 3539 | 57 |
432936 | 432936 | 2020-08-14 | Gaston | North Carolina | 37071 | 3495 | 57 |
429710 | 429710 | 2020-08-13 | Gaston | North Carolina | 37071 | 3438 | 56 |
426485 | 426485 | 2020-08-12 | Gaston | North Carolina | 37071 | 3392 | 55 |
423262 | 423262 | 2020-08-11 | Gaston | North Carolina | 37071 | 3358 | 52 |
420039 | 420039 | 2020-08-10 | Gaston | North Carolina | 37071 | 3339 | 52 |
416819 | 416819 | 2020-08-09 | Gaston | North Carolina | 37071 | 3322 | 52 |
413598 | 413598 | 2020-08-08 | Gaston | North Carolina | 37071 | 3299 | 51 |
410378 | 410378 | 2020-08-07 | Gaston | North Carolina | 37071 | 3263 | 47 |
407158 | 407158 | 2020-08-06 | Gaston | North Carolina | 37071 | 3222 | 47 |
403939 | 403939 | 2020-08-05 | Gaston | North Carolina | 37071 | 3124 | 41 |
400721 | 400721 | 2020-08-04 | Gaston | North Carolina | 37071 | 3083 | 40 |
397506 | 397506 | 2020-08-03 | Gaston | North Carolina | 37071 | 3035 | 39 |
394289 | 394289 | 2020-08-02 | Gaston | North Carolina | 37071 | 3013 | 37 |
391073 | 391073 | 2020-08-01 | Gaston | North Carolina | 37071 | 2994 | 37 |
387856 | 387856 | 2020-07-31 | Gaston | North Carolina | 37071 | 2939 | 33 |
384639 | 384639 | 2020-07-30 | Gaston | North Carolina | 37071 | 2863 | 33 |
381421 | 381421 | 2020-07-29 | Gaston | North Carolina | 37071 | 2805 | 32 |
378204 | 378204 | 2020-07-28 | Gaston | North Carolina | 37071 | 2777 | 30 |
374988 | 374988 | 2020-07-27 | Gaston | North Carolina | 37071 | 2736 | 25 |
371776 | 371776 | 2020-07-26 | Gaston | North Carolina | 37071 | 2692 | 25 |
368564 | 368564 | 2020-07-25 | Gaston | North Carolina | 37071 | 2635 | 24 |
365355 | 365355 | 2020-07-24 | Gaston | North Carolina | 37071 | 2569 | 22 |
362149 | 362149 | 2020-07-23 | Gaston | North Carolina | 37071 | 2500 | 22 |
358943 | 358943 | 2020-07-22 | Gaston | North Carolina | 37071 | 2432 | 21 |
355739 | 355739 | 2020-07-21 | Gaston | North Carolina | 37071 | 2359 | 19 |
352536 | 352536 | 2020-07-20 | Gaston | North Carolina | 37071 | 2320 | 19 |
349333 | 349333 | 2020-07-19 | Gaston | North Carolina | 37071 | 2267 | 19 |
346132 | 346132 | 2020-07-18 | Gaston | North Carolina | 37071 | 2189 | 19 |
342933 | 342933 | 2020-07-17 | Gaston | North Carolina | 37071 | 2120 | 17 |
339735 | 339735 | 2020-07-16 | Gaston | North Carolina | 37071 | 2076 | 17 |
336539 | 336539 | 2020-07-15 | Gaston | North Carolina | 37071 | 2003 | 17 |
333345 | 333345 | 2020-07-14 | Gaston | North Carolina | 37071 | 1946 | 15 |
330155 | 330155 | 2020-07-13 | Gaston | North Carolina | 37071 | 1859 | 15 |
326968 | 326968 | 2020-07-12 | Gaston | North Carolina | 37071 | 1811 | 15 |
323784 | 323784 | 2020-07-11 | Gaston | North Carolina | 37071 | 1742 | 15 |
320604 | 320604 | 2020-07-10 | Gaston | North Carolina | 37071 | 1640 | 15 |
317427 | 317427 | 2020-07-09 | Gaston | North Carolina | 37071 | 1547 | 15 |
314253 | 314253 | 2020-07-08 | Gaston | North Carolina | 37071 | 1479 | 14 |
311082 | 311082 | 2020-07-07 | Gaston | North Carolina | 37071 | 1443 | 12 |
307914 | 307914 | 2020-07-06 | Gaston | North Carolina | 37071 | 1385 | 12 |
304747 | 304747 | 2020-07-05 | Gaston | North Carolina | 37071 | 1325 | 11 |
301584 | 301584 | 2020-07-04 | Gaston | North Carolina | 37071 | 1291 | 11 |
298421 | 298421 | 2020-07-03 | Gaston | North Carolina | 37071 | 1250 | 11 |
295261 | 295261 | 2020-07-02 | Gaston | North Carolina | 37071 | 1168 | 11 |
292106 | 292106 | 2020-07-01 | Gaston | North Carolina | 37071 | 1139 | 11 |
288954 | 288954 | 2020-06-30 | Gaston | North Carolina | 37071 | 1083 | 11 |
285804 | 285804 | 2020-06-29 | Gaston | North Carolina | 37071 | 1041 | 11 |
282659 | 282659 | 2020-06-28 | Gaston | North Carolina | 37071 | 1004 | 11 |
279513 | 279513 | 2020-06-27 | Gaston | North Carolina | 37071 | 972 | 11 |
276365 | 276365 | 2020-06-26 | Gaston | North Carolina | 37071 | 912 | 11 |
273219 | 273219 | 2020-06-25 | Gaston | North Carolina | 37071 | 869 | 11 |
270080 | 270080 | 2020-06-24 | Gaston | North Carolina | 37071 | 837 | 11 |
266946 | 266946 | 2020-06-23 | Gaston | North Carolina | 37071 | 803 | 11 |
263818 | 263818 | 2020-06-22 | Gaston | North Carolina | 37071 | 771 | 9 |
260690 | 260690 | 2020-06-21 | Gaston | North Carolina | 37071 | 737 | 9 |
257563 | 257563 | 2020-06-20 | Gaston | North Carolina | 37071 | 705 | 9 |
254440 | 254440 | 2020-06-19 | Gaston | North Carolina | 37071 | 671 | 9 |
251325 | 251325 | 2020-06-18 | Gaston | North Carolina | 37071 | 621 | 9 |
248210 | 248210 | 2020-06-17 | Gaston | North Carolina | 37071 | 576 | 9 |
245097 | 245097 | 2020-06-16 | Gaston | North Carolina | 37071 | 549 | 8 |
241985 | 241985 | 2020-06-15 | Gaston | North Carolina | 37071 | 525 | 8 |
238876 | 238876 | 2020-06-14 | Gaston | North Carolina | 37071 | 515 | 8 |
235768 | 235768 | 2020-06-13 | Gaston | North Carolina | 37071 | 484 | 8 |
232663 | 232663 | 2020-06-12 | Gaston | North Carolina | 37071 | 452 | 8 |
229558 | 229558 | 2020-06-11 | Gaston | North Carolina | 37071 | 406 | 8 |
226454 | 226454 | 2020-06-10 | Gaston | North Carolina | 37071 | 392 | 8 |
223354 | 223354 | 2020-06-09 | Gaston | North Carolina | 37071 | 368 | 8 |
220260 | 220260 | 2020-06-08 | Gaston | North Carolina | 37071 | 366 | 8 |
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);