ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Gloucester" and fips = 34015 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, 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 |
6680 | 6680 | 2020-03-21 | Gloucester | New Jersey | 34015 | 6 | 0 |
7771 | 7771 | 2020-03-22 | Gloucester | New Jersey | 34015 | 8 | 0 |
8967 | 8967 | 2020-03-23 | Gloucester | New Jersey | 34015 | 13 | 0 |
10271 | 10271 | 2020-03-24 | Gloucester | New Jersey | 34015 | 19 | 0 |
11703 | 11703 | 2020-03-25 | Gloucester | New Jersey | 34015 | 23 | 0 |
13306 | 13306 | 2020-03-26 | Gloucester | New Jersey | 34015 | 33 | 0 |
15038 | 15038 | 2020-03-27 | Gloucester | New Jersey | 34015 | 40 | 1 |
16867 | 16867 | 2020-03-28 | Gloucester | New Jersey | 34015 | 51 | 1 |
18791 | 18791 | 2020-03-29 | Gloucester | New Jersey | 34015 | 72 | 1 |
20829 | 20829 | 2020-03-30 | Gloucester | New Jersey | 34015 | 89 | 1 |
22952 | 22952 | 2020-03-31 | Gloucester | New Jersey | 34015 | 114 | 2 |
25143 | 25143 | 2020-04-01 | Gloucester | New Jersey | 34015 | 149 | 2 |
27403 | 27403 | 2020-04-02 | Gloucester | New Jersey | 34015 | 169 | 2 |
29726 | 29726 | 2020-04-03 | Gloucester | New Jersey | 34015 | 183 | 3 |
32111 | 32111 | 2020-04-04 | Gloucester | New Jersey | 34015 | 215 | 3 |
34542 | 34542 | 2020-04-05 | Gloucester | New Jersey | 34015 | 248 | 3 |
37012 | 37012 | 2020-04-06 | Gloucester | New Jersey | 34015 | 279 | 3 |
39527 | 39527 | 2020-04-07 | Gloucester | New Jersey | 34015 | 311 | 5 |
42084 | 42084 | 2020-04-08 | Gloucester | New Jersey | 34015 | 340 | 7 |
44666 | 44666 | 2020-04-09 | Gloucester | New Jersey | 34015 | 413 | 8 |
47278 | 47278 | 2020-04-10 | Gloucester | New Jersey | 34015 | 447 | 8 |
49932 | 49932 | 2020-04-11 | Gloucester | New Jersey | 34015 | 487 | 9 |
52605 | 52605 | 2020-04-12 | Gloucester | New Jersey | 34015 | 532 | 9 |
55288 | 55288 | 2020-04-13 | Gloucester | New Jersey | 34015 | 566 | 9 |
57988 | 57988 | 2020-04-14 | Gloucester | New Jersey | 34015 | 587 | 11 |
60702 | 60702 | 2020-04-15 | Gloucester | New Jersey | 34015 | 602 | 14 |
63428 | 63428 | 2020-04-16 | Gloucester | New Jersey | 34015 | 624 | 18 |
66170 | 66170 | 2020-04-17 | Gloucester | New Jersey | 34015 | 664 | 22 |
68926 | 68926 | 2020-04-18 | Gloucester | New Jersey | 34015 | 683 | 23 |
71693 | 71693 | 2020-04-19 | Gloucester | New Jersey | 34015 | 737 | 24 |
74468 | 74468 | 2020-04-20 | Gloucester | New Jersey | 34015 | 770 | 25 |
77249 | 77249 | 2020-04-21 | Gloucester | New Jersey | 34015 | 808 | 27 |
80038 | 80038 | 2020-04-22 | Gloucester | New Jersey | 34015 | 856 | 29 |
82836 | 82836 | 2020-04-23 | Gloucester | New Jersey | 34015 | 899 | 30 |
85640 | 85640 | 2020-04-24 | Gloucester | New Jersey | 34015 | 923 | 30 |
88451 | 88451 | 2020-04-25 | Gloucester | New Jersey | 34015 | 949 | 30 |
91266 | 91266 | 2020-04-26 | Gloucester | New Jersey | 34015 | 976 | 31 |
94090 | 94090 | 2020-04-27 | Gloucester | New Jersey | 34015 | 1111 | 33 |
96926 | 96926 | 2020-04-28 | Gloucester | New Jersey | 34015 | 1179 | 38 |
99773 | 99773 | 2020-04-29 | Gloucester | New Jersey | 34015 | 1208 | 40 |
102626 | 102626 | 2020-04-30 | Gloucester | New Jersey | 34015 | 1251 | 46 |
105488 | 105488 | 2020-05-01 | Gloucester | New Jersey | 34015 | 1282 | 48 |
108354 | 108354 | 2020-05-02 | Gloucester | New Jersey | 34015 | 1334 | 50 |
111227 | 111227 | 2020-05-03 | Gloucester | New Jersey | 34015 | 1384 | 51 |
114108 | 114108 | 2020-05-04 | Gloucester | New Jersey | 34015 | 1433 | 51 |
116989 | 116989 | 2020-05-05 | Gloucester | New Jersey | 34015 | 1467 | 61 |
119950 | 119950 | 2020-05-06 | Gloucester | New Jersey | 34015 | 1499 | 63 |
122925 | 122925 | 2020-05-07 | Gloucester | New Jersey | 34015 | 1548 | 66 |
125908 | 125908 | 2020-05-08 | Gloucester | New Jersey | 34015 | 1593 | 72 |
128897 | 128897 | 2020-05-09 | Gloucester | New Jersey | 34015 | 1631 | 79 |
131886 | 131886 | 2020-05-10 | Gloucester | New Jersey | 34015 | 1654 | 81 |
134877 | 134877 | 2020-05-11 | Gloucester | New Jersey | 34015 | 1690 | 83 |
137867 | 137867 | 2020-05-12 | Gloucester | New Jersey | 34015 | 1710 | 90 |
140863 | 140863 | 2020-05-13 | Gloucester | New Jersey | 34015 | 1728 | 92 |
143858 | 143858 | 2020-05-14 | Gloucester | New Jersey | 34015 | 1756 | 98 |
146859 | 146859 | 2020-05-15 | Gloucester | New Jersey | 34015 | 1788 | 106 |
149866 | 149866 | 2020-05-16 | Gloucester | New Jersey | 34015 | 1811 | 113 |
152876 | 152876 | 2020-05-17 | Gloucester | New Jersey | 34015 | 1832 | 116 |
155892 | 155892 | 2020-05-18 | Gloucester | New Jersey | 34015 | 1907 | 117 |
158910 | 158910 | 2020-05-19 | Gloucester | New Jersey | 34015 | 1935 | 125 |
161936 | 161936 | 2020-05-20 | Gloucester | New Jersey | 34015 | 1966 | 127 |
164965 | 164965 | 2020-05-21 | Gloucester | New Jersey | 34015 | 2002 | 129 |
168001 | 168001 | 2020-05-22 | Gloucester | New Jersey | 34015 | 2031 | 132 |
171040 | 171040 | 2020-05-23 | Gloucester | New Jersey | 34015 | 2044 | 134 |
174082 | 174082 | 2020-05-24 | Gloucester | New Jersey | 34015 | 2066 | 134 |
177125 | 177125 | 2020-05-25 | Gloucester | New Jersey | 34015 | 2089 | 138 |
180169 | 180169 | 2020-05-26 | Gloucester | New Jersey | 34015 | 2103 | 138 |
183217 | 183217 | 2020-05-27 | Gloucester | New Jersey | 34015 | 2130 | 140 |
186274 | 186274 | 2020-05-28 | Gloucester | New Jersey | 34015 | 2165 | 143 |
189334 | 189334 | 2020-05-29 | Gloucester | New Jersey | 34015 | 2198 | 147 |
192398 | 192398 | 2020-05-30 | Gloucester | New Jersey | 34015 | 2217 | 147 |
195468 | 195468 | 2020-05-31 | Gloucester | New Jersey | 34015 | 2234 | 147 |
198541 | 198541 | 2020-06-01 | Gloucester | New Jersey | 34015 | 2245 | 148 |
201615 | 201615 | 2020-06-02 | Gloucester | New Jersey | 34015 | 2262 | 148 |
204692 | 204692 | 2020-06-03 | Gloucester | New Jersey | 34015 | 2278 | 149 |
207773 | 207773 | 2020-06-04 | Gloucester | New Jersey | 34015 | 2290 | 150 |
210855 | 210855 | 2020-06-05 | Gloucester | New Jersey | 34015 | 2310 | 151 |
213939 | 213939 | 2020-06-06 | Gloucester | New Jersey | 34015 | 2319 | 152 |
217028 | 217028 | 2020-06-07 | Gloucester | New Jersey | 34015 | 2328 | 153 |
220120 | 220120 | 2020-06-08 | Gloucester | New Jersey | 34015 | 2332 | 152 |
223215 | 223215 | 2020-06-09 | Gloucester | New Jersey | 34015 | 2340 | 153 |
226315 | 226315 | 2020-06-10 | Gloucester | New Jersey | 34015 | 2357 | 153 |
229419 | 229419 | 2020-06-11 | Gloucester | New Jersey | 34015 | 2367 | 155 |
232524 | 232524 | 2020-06-12 | Gloucester | New Jersey | 34015 | 2379 | 156 |
235629 | 235629 | 2020-06-13 | Gloucester | New Jersey | 34015 | 2402 | 156 |
238736 | 238736 | 2020-06-14 | Gloucester | New Jersey | 34015 | 2414 | 157 |
241846 | 241846 | 2020-06-15 | Gloucester | New Jersey | 34015 | 2416 | 163 |
244958 | 244958 | 2020-06-16 | Gloucester | New Jersey | 34015 | 2423 | 164 |
248071 | 248071 | 2020-06-17 | Gloucester | New Jersey | 34015 | 2428 | 166 |
251186 | 251186 | 2020-06-18 | Gloucester | New Jersey | 34015 | 2438 | 167 |
254301 | 254301 | 2020-06-19 | Gloucester | New Jersey | 34015 | 2451 | 169 |
257424 | 257424 | 2020-06-20 | Gloucester | New Jersey | 34015 | 2457 | 171 |
260550 | 260550 | 2020-06-21 | Gloucester | New Jersey | 34015 | 2467 | 171 |
263679 | 263679 | 2020-06-22 | Gloucester | New Jersey | 34015 | 2471 | 171 |
266806 | 266806 | 2020-06-23 | Gloucester | New Jersey | 34015 | 2489 | 172 |
269941 | 269941 | 2020-06-24 | Gloucester | New Jersey | 34015 | 2497 | 172 |
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);