ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17,417 rows where state = "New Jersey" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4111 | 4111 | 2020-03-18 | Atlantic | New Jersey | 34001 | 3 | 0 |
4837 | 4837 | 2020-03-19 | Atlantic | New Jersey | 34001 | 3 | 0 |
5680 | 5680 | 2020-03-20 | Atlantic | New Jersey | 34001 | 3 | 0 |
6673 | 6673 | 2020-03-21 | Atlantic | New Jersey | 34001 | 4 | 0 |
7764 | 7764 | 2020-03-22 | Atlantic | New Jersey | 34001 | 5 | 0 |
8960 | 8960 | 2020-03-23 | Atlantic | New Jersey | 34001 | 6 | 0 |
10264 | 10264 | 2020-03-24 | Atlantic | New Jersey | 34001 | 6 | 0 |
11696 | 11696 | 2020-03-25 | Atlantic | New Jersey | 34001 | 9 | 0 |
13299 | 13299 | 2020-03-26 | Atlantic | New Jersey | 34001 | 10 | 0 |
15031 | 15031 | 2020-03-27 | Atlantic | New Jersey | 34001 | 14 | 0 |
16860 | 16860 | 2020-03-28 | Atlantic | New Jersey | 34001 | 17 | 0 |
18784 | 18784 | 2020-03-29 | Atlantic | New Jersey | 34001 | 24 | 0 |
20822 | 20822 | 2020-03-30 | Atlantic | New Jersey | 34001 | 30 | 0 |
22945 | 22945 | 2020-03-31 | Atlantic | New Jersey | 34001 | 31 | 0 |
25136 | 25136 | 2020-04-01 | Atlantic | New Jersey | 34001 | 40 | 0 |
27396 | 27396 | 2020-04-02 | Atlantic | New Jersey | 34001 | 50 | 1 |
29719 | 29719 | 2020-04-03 | Atlantic | New Jersey | 34001 | 75 | 1 |
32104 | 32104 | 2020-04-04 | Atlantic | New Jersey | 34001 | 98 | 1 |
34535 | 34535 | 2020-04-05 | Atlantic | New Jersey | 34001 | 121 | 1 |
37005 | 37005 | 2020-04-06 | Atlantic | New Jersey | 34001 | 132 | 1 |
39520 | 39520 | 2020-04-07 | Atlantic | New Jersey | 34001 | 144 | 4 |
42077 | 42077 | 2020-04-08 | Atlantic | New Jersey | 34001 | 168 | 4 |
44659 | 44659 | 2020-04-09 | Atlantic | New Jersey | 34001 | 191 | 4 |
47271 | 47271 | 2020-04-10 | Atlantic | New Jersey | 34001 | 211 | 6 |
49925 | 49925 | 2020-04-11 | Atlantic | New Jersey | 34001 | 230 | 7 |
52598 | 52598 | 2020-04-12 | Atlantic | New Jersey | 34001 | 253 | 8 |
55281 | 55281 | 2020-04-13 | Atlantic | New Jersey | 34001 | 267 | 8 |
57981 | 57981 | 2020-04-14 | Atlantic | New Jersey | 34001 | 284 | 11 |
60695 | 60695 | 2020-04-15 | Atlantic | New Jersey | 34001 | 322 | 13 |
63421 | 63421 | 2020-04-16 | Atlantic | New Jersey | 34001 | 344 | 13 |
66163 | 66163 | 2020-04-17 | Atlantic | New Jersey | 34001 | 370 | 17 |
68919 | 68919 | 2020-04-18 | Atlantic | New Jersey | 34001 | 382 | 19 |
71686 | 71686 | 2020-04-19 | Atlantic | New Jersey | 34001 | 398 | 19 |
74461 | 74461 | 2020-04-20 | Atlantic | New Jersey | 34001 | 410 | 19 |
77242 | 77242 | 2020-04-21 | Atlantic | New Jersey | 34001 | 469 | 22 |
80031 | 80031 | 2020-04-22 | Atlantic | New Jersey | 34001 | 505 | 24 |
82829 | 82829 | 2020-04-23 | Atlantic | New Jersey | 34001 | 544 | 30 |
85633 | 85633 | 2020-04-24 | Atlantic | New Jersey | 34001 | 566 | 29 |
88444 | 88444 | 2020-04-25 | Atlantic | New Jersey | 34001 | 596 | 29 |
91259 | 91259 | 2020-04-26 | Atlantic | New Jersey | 34001 | 638 | 29 |
94083 | 94083 | 2020-04-27 | Atlantic | New Jersey | 34001 | 749 | 30 |
96919 | 96919 | 2020-04-28 | Atlantic | New Jersey | 34001 | 868 | 35 |
99766 | 99766 | 2020-04-29 | Atlantic | New Jersey | 34001 | 908 | 37 |
102619 | 102619 | 2020-04-30 | Atlantic | New Jersey | 34001 | 964 | 41 |
105481 | 105481 | 2020-05-01 | Atlantic | New Jersey | 34001 | 1012 | 45 |
108347 | 108347 | 2020-05-02 | Atlantic | New Jersey | 34001 | 1050 | 48 |
111220 | 111220 | 2020-05-03 | Atlantic | New Jersey | 34001 | 1075 | 49 |
114101 | 114101 | 2020-05-04 | Atlantic | New Jersey | 34001 | 1135 | 51 |
116982 | 116982 | 2020-05-05 | Atlantic | New Jersey | 34001 | 1190 | 51 |
119943 | 119943 | 2020-05-06 | Atlantic | New Jersey | 34001 | 1246 | 54 |
122918 | 122918 | 2020-05-07 | Atlantic | New Jersey | 34001 | 1302 | 62 |
125901 | 125901 | 2020-05-08 | Atlantic | New Jersey | 34001 | 1423 | 68 |
128890 | 128890 | 2020-05-09 | Atlantic | New Jersey | 34001 | 1494 | 72 |
131879 | 131879 | 2020-05-10 | Atlantic | New Jersey | 34001 | 1510 | 72 |
134870 | 134870 | 2020-05-11 | Atlantic | New Jersey | 34001 | 1533 | 77 |
137860 | 137860 | 2020-05-12 | Atlantic | New Jersey | 34001 | 1558 | 79 |
140856 | 140856 | 2020-05-13 | Atlantic | New Jersey | 34001 | 1584 | 88 |
143851 | 143851 | 2020-05-14 | Atlantic | New Jersey | 34001 | 1649 | 99 |
146852 | 146852 | 2020-05-15 | Atlantic | New Jersey | 34001 | 1678 | 107 |
149859 | 149859 | 2020-05-16 | Atlantic | New Jersey | 34001 | 1716 | 110 |
152869 | 152869 | 2020-05-17 | Atlantic | New Jersey | 34001 | 1758 | 112 |
155885 | 155885 | 2020-05-18 | Atlantic | New Jersey | 34001 | 1807 | 112 |
158903 | 158903 | 2020-05-19 | Atlantic | New Jersey | 34001 | 1838 | 121 |
161929 | 161929 | 2020-05-20 | Atlantic | New Jersey | 34001 | 1875 | 126 |
164958 | 164958 | 2020-05-21 | Atlantic | New Jersey | 34001 | 1895 | 128 |
167994 | 167994 | 2020-05-22 | Atlantic | New Jersey | 34001 | 1919 | 130 |
171033 | 171033 | 2020-05-23 | Atlantic | New Jersey | 34001 | 1936 | 143 |
174075 | 174075 | 2020-05-24 | Atlantic | New Jersey | 34001 | 1961 | 144 |
177118 | 177118 | 2020-05-25 | Atlantic | New Jersey | 34001 | 2028 | 144 |
180162 | 180162 | 2020-05-26 | Atlantic | New Jersey | 34001 | 2049 | 149 |
183210 | 183210 | 2020-05-27 | Atlantic | New Jersey | 34001 | 2087 | 155 |
186267 | 186267 | 2020-05-28 | Atlantic | New Jersey | 34001 | 2120 | 156 |
189327 | 189327 | 2020-05-29 | Atlantic | New Jersey | 34001 | 2154 | 158 |
192391 | 192391 | 2020-05-30 | Atlantic | New Jersey | 34001 | 2183 | 159 |
195461 | 195461 | 2020-05-31 | Atlantic | New Jersey | 34001 | 2214 | 159 |
198534 | 198534 | 2020-06-01 | Atlantic | New Jersey | 34001 | 2222 | 159 |
201608 | 201608 | 2020-06-02 | Atlantic | New Jersey | 34001 | 2251 | 162 |
204685 | 204685 | 2020-06-03 | Atlantic | New Jersey | 34001 | 2284 | 163 |
207766 | 207766 | 2020-06-04 | Atlantic | New Jersey | 34001 | 2286 | 164 |
210848 | 210848 | 2020-06-05 | Atlantic | New Jersey | 34001 | 2309 | 167 |
213932 | 213932 | 2020-06-06 | Atlantic | New Jersey | 34001 | 2330 | 167 |
217021 | 217021 | 2020-06-07 | Atlantic | New Jersey | 34001 | 2364 | 167 |
220113 | 220113 | 2020-06-08 | Atlantic | New Jersey | 34001 | 2383 | 167 |
223208 | 223208 | 2020-06-09 | Atlantic | New Jersey | 34001 | 2401 | 167 |
226308 | 226308 | 2020-06-10 | Atlantic | New Jersey | 34001 | 2422 | 168 |
229412 | 229412 | 2020-06-11 | Atlantic | New Jersey | 34001 | 2431 | 171 |
232517 | 232517 | 2020-06-12 | Atlantic | New Jersey | 34001 | 2453 | 172 |
235622 | 235622 | 2020-06-13 | Atlantic | New Jersey | 34001 | 2475 | 179 |
238729 | 238729 | 2020-06-14 | Atlantic | New Jersey | 34001 | 2490 | 180 |
241839 | 241839 | 2020-06-15 | Atlantic | New Jersey | 34001 | 2497 | 180 |
244951 | 244951 | 2020-06-16 | Atlantic | New Jersey | 34001 | 2539 | 180 |
248064 | 248064 | 2020-06-17 | Atlantic | New Jersey | 34001 | 2553 | 184 |
251179 | 251179 | 2020-06-18 | Atlantic | New Jersey | 34001 | 2583 | 187 |
254294 | 254294 | 2020-06-19 | Atlantic | New Jersey | 34001 | 2619 | 188 |
257417 | 257417 | 2020-06-20 | Atlantic | New Jersey | 34001 | 2638 | 189 |
260543 | 260543 | 2020-06-21 | Atlantic | New Jersey | 34001 | 2702 | 188 |
263672 | 263672 | 2020-06-22 | Atlantic | New Jersey | 34001 | 2722 | 188 |
266799 | 266799 | 2020-06-23 | Atlantic | New Jersey | 34001 | 2750 | 190 |
269934 | 269934 | 2020-06-24 | Atlantic | New Jersey | 34001 | 2771 | 192 |
273073 | 273073 | 2020-06-25 | Atlantic | New Jersey | 34001 | 2801 | 206 |
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);