ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,573 rows where county = "Gloucester" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3520 | 3520 | 2020-03-17 | Gloucester | New Jersey | 34015 | 2 | 0 |
4116 | 4116 | 2020-03-18 | Gloucester | New Jersey | 34015 | 2 | 0 |
4843 | 4843 | 2020-03-19 | Gloucester | New Jersey | 34015 | 3 | 0 |
5687 | 5687 | 2020-03-20 | Gloucester | New Jersey | 34015 | 3 | 0 |
5995 | 5995 | 2020-03-20 | Gloucester | Virginia | 51073 | 1 | 0 |
6680 | 6680 | 2020-03-21 | Gloucester | New Jersey | 34015 | 6 | 0 |
7023 | 7023 | 2020-03-21 | Gloucester | Virginia | 51073 | 2 | 0 |
7771 | 7771 | 2020-03-22 | Gloucester | New Jersey | 34015 | 8 | 0 |
8157 | 8157 | 2020-03-22 | Gloucester | Virginia | 51073 | 2 | 0 |
8967 | 8967 | 2020-03-23 | Gloucester | New Jersey | 34015 | 13 | 0 |
9379 | 9379 | 2020-03-23 | Gloucester | Virginia | 51073 | 2 | 0 |
10271 | 10271 | 2020-03-24 | Gloucester | New Jersey | 34015 | 19 | 0 |
10726 | 10726 | 2020-03-24 | Gloucester | Virginia | 51073 | 2 | 0 |
11703 | 11703 | 2020-03-25 | Gloucester | New Jersey | 34015 | 23 | 0 |
12240 | 12240 | 2020-03-25 | Gloucester | Virginia | 51073 | 2 | 0 |
13306 | 13306 | 2020-03-26 | Gloucester | New Jersey | 34015 | 33 | 0 |
13878 | 13878 | 2020-03-26 | Gloucester | Virginia | 51073 | 3 | 0 |
15038 | 15038 | 2020-03-27 | Gloucester | New Jersey | 34015 | 40 | 1 |
15646 | 15646 | 2020-03-27 | Gloucester | Virginia | 51073 | 3 | 0 |
16867 | 16867 | 2020-03-28 | Gloucester | New Jersey | 34015 | 51 | 1 |
17520 | 17520 | 2020-03-28 | Gloucester | Virginia | 51073 | 6 | 0 |
18791 | 18791 | 2020-03-29 | Gloucester | New Jersey | 34015 | 72 | 1 |
19480 | 19480 | 2020-03-29 | Gloucester | Virginia | 51073 | 6 | 0 |
20829 | 20829 | 2020-03-30 | Gloucester | New Jersey | 34015 | 89 | 1 |
21543 | 21543 | 2020-03-30 | Gloucester | Virginia | 51073 | 7 | 0 |
22952 | 22952 | 2020-03-31 | Gloucester | New Jersey | 34015 | 114 | 2 |
23688 | 23688 | 2020-03-31 | Gloucester | Virginia | 51073 | 7 | 0 |
25143 | 25143 | 2020-04-01 | Gloucester | New Jersey | 34015 | 149 | 2 |
25904 | 25904 | 2020-04-01 | Gloucester | Virginia | 51073 | 8 | 0 |
27403 | 27403 | 2020-04-02 | Gloucester | New Jersey | 34015 | 169 | 2 |
28194 | 28194 | 2020-04-02 | Gloucester | Virginia | 51073 | 8 | 0 |
29726 | 29726 | 2020-04-03 | Gloucester | New Jersey | 34015 | 183 | 3 |
30540 | 30540 | 2020-04-03 | Gloucester | Virginia | 51073 | 8 | 0 |
32111 | 32111 | 2020-04-04 | Gloucester | New Jersey | 34015 | 215 | 3 |
32939 | 32939 | 2020-04-04 | Gloucester | Virginia | 51073 | 9 | 0 |
34542 | 34542 | 2020-04-05 | Gloucester | New Jersey | 34015 | 248 | 3 |
35377 | 35377 | 2020-04-05 | Gloucester | Virginia | 51073 | 10 | 0 |
37012 | 37012 | 2020-04-06 | Gloucester | New Jersey | 34015 | 279 | 3 |
37860 | 37860 | 2020-04-06 | Gloucester | Virginia | 51073 | 12 | 0 |
39527 | 39527 | 2020-04-07 | Gloucester | New Jersey | 34015 | 311 | 5 |
40393 | 40393 | 2020-04-07 | Gloucester | Virginia | 51073 | 15 | 0 |
42084 | 42084 | 2020-04-08 | Gloucester | New Jersey | 34015 | 340 | 7 |
42962 | 42962 | 2020-04-08 | Gloucester | Virginia | 51073 | 16 | 0 |
44666 | 44666 | 2020-04-09 | Gloucester | New Jersey | 34015 | 413 | 8 |
45557 | 45557 | 2020-04-09 | Gloucester | Virginia | 51073 | 16 | 0 |
47278 | 47278 | 2020-04-10 | Gloucester | New Jersey | 34015 | 447 | 8 |
48183 | 48183 | 2020-04-10 | Gloucester | Virginia | 51073 | 18 | 0 |
49932 | 49932 | 2020-04-11 | Gloucester | New Jersey | 34015 | 487 | 9 |
50841 | 50841 | 2020-04-11 | Gloucester | Virginia | 51073 | 20 | 0 |
52605 | 52605 | 2020-04-12 | Gloucester | New Jersey | 34015 | 532 | 9 |
53516 | 53516 | 2020-04-12 | Gloucester | Virginia | 51073 | 20 | 0 |
55288 | 55288 | 2020-04-13 | Gloucester | New Jersey | 34015 | 566 | 9 |
56206 | 56206 | 2020-04-13 | Gloucester | Virginia | 51073 | 20 | 0 |
57988 | 57988 | 2020-04-14 | Gloucester | New Jersey | 34015 | 587 | 11 |
58912 | 58912 | 2020-04-14 | Gloucester | Virginia | 51073 | 20 | 0 |
60702 | 60702 | 2020-04-15 | Gloucester | New Jersey | 34015 | 602 | 14 |
61631 | 61631 | 2020-04-15 | Gloucester | Virginia | 51073 | 20 | 0 |
63428 | 63428 | 2020-04-16 | Gloucester | New Jersey | 34015 | 624 | 18 |
64364 | 64364 | 2020-04-16 | Gloucester | Virginia | 51073 | 20 | 0 |
66170 | 66170 | 2020-04-17 | Gloucester | New Jersey | 34015 | 664 | 22 |
67112 | 67112 | 2020-04-17 | Gloucester | Virginia | 51073 | 20 | 0 |
68926 | 68926 | 2020-04-18 | Gloucester | New Jersey | 34015 | 683 | 23 |
69874 | 69874 | 2020-04-18 | Gloucester | Virginia | 51073 | 21 | 0 |
71693 | 71693 | 2020-04-19 | Gloucester | New Jersey | 34015 | 737 | 24 |
72644 | 72644 | 2020-04-19 | Gloucester | Virginia | 51073 | 21 | 0 |
74468 | 74468 | 2020-04-20 | Gloucester | New Jersey | 34015 | 770 | 25 |
75420 | 75420 | 2020-04-20 | Gloucester | Virginia | 51073 | 21 | 0 |
77249 | 77249 | 2020-04-21 | Gloucester | New Jersey | 34015 | 808 | 27 |
78202 | 78202 | 2020-04-21 | Gloucester | Virginia | 51073 | 21 | 1 |
80038 | 80038 | 2020-04-22 | Gloucester | New Jersey | 34015 | 856 | 29 |
80994 | 80994 | 2020-04-22 | Gloucester | Virginia | 51073 | 21 | 1 |
82836 | 82836 | 2020-04-23 | Gloucester | New Jersey | 34015 | 899 | 30 |
83795 | 83795 | 2020-04-23 | Gloucester | Virginia | 51073 | 21 | 1 |
85640 | 85640 | 2020-04-24 | Gloucester | New Jersey | 34015 | 923 | 30 |
86602 | 86602 | 2020-04-24 | Gloucester | Virginia | 51073 | 21 | 1 |
88451 | 88451 | 2020-04-25 | Gloucester | New Jersey | 34015 | 949 | 30 |
89417 | 89417 | 2020-04-25 | Gloucester | Virginia | 51073 | 22 | 1 |
91266 | 91266 | 2020-04-26 | Gloucester | New Jersey | 34015 | 976 | 31 |
92234 | 92234 | 2020-04-26 | Gloucester | Virginia | 51073 | 22 | 1 |
94090 | 94090 | 2020-04-27 | Gloucester | New Jersey | 34015 | 1111 | 33 |
95063 | 95063 | 2020-04-27 | Gloucester | Virginia | 51073 | 22 | 1 |
96926 | 96926 | 2020-04-28 | Gloucester | New Jersey | 34015 | 1179 | 38 |
97905 | 97905 | 2020-04-28 | Gloucester | Virginia | 51073 | 22 | 1 |
99773 | 99773 | 2020-04-29 | Gloucester | New Jersey | 34015 | 1208 | 40 |
100755 | 100755 | 2020-04-29 | Gloucester | Virginia | 51073 | 23 | 1 |
102626 | 102626 | 2020-04-30 | Gloucester | New Jersey | 34015 | 1251 | 46 |
103610 | 103610 | 2020-04-30 | Gloucester | Virginia | 51073 | 23 | 1 |
105488 | 105488 | 2020-05-01 | Gloucester | New Jersey | 34015 | 1282 | 48 |
106474 | 106474 | 2020-05-01 | Gloucester | Virginia | 51073 | 24 | 1 |
108354 | 108354 | 2020-05-02 | Gloucester | New Jersey | 34015 | 1334 | 50 |
109343 | 109343 | 2020-05-02 | Gloucester | Virginia | 51073 | 24 | 1 |
111227 | 111227 | 2020-05-03 | Gloucester | New Jersey | 34015 | 1384 | 51 |
112217 | 112217 | 2020-05-03 | Gloucester | Virginia | 51073 | 25 | 1 |
114108 | 114108 | 2020-05-04 | Gloucester | New Jersey | 34015 | 1433 | 51 |
115100 | 115100 | 2020-05-04 | Gloucester | Virginia | 51073 | 27 | 1 |
116989 | 116989 | 2020-05-05 | Gloucester | New Jersey | 34015 | 1467 | 61 |
118059 | 118059 | 2020-05-05 | Gloucester | Virginia | 51073 | 26 | 1 |
119950 | 119950 | 2020-05-06 | Gloucester | New Jersey | 34015 | 1499 | 63 |
121023 | 121023 | 2020-05-06 | Gloucester | Virginia | 51073 | 26 | 1 |
122925 | 122925 | 2020-05-07 | Gloucester | New Jersey | 34015 | 1548 | 66 |
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);