ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Union" and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387728 | 387728 | 2020-07-31 | Union | New Jersey | 34039 | 16694 | 1347 |
384511 | 384511 | 2020-07-30 | Union | New Jersey | 34039 | 16627 | 1346 |
381293 | 381293 | 2020-07-29 | Union | New Jersey | 34039 | 16610 | 1345 |
378075 | 378075 | 2020-07-28 | Union | New Jersey | 34039 | 16585 | 1349 |
374860 | 374860 | 2020-07-27 | Union | New Jersey | 34039 | 16551 | 1347 |
371648 | 371648 | 2020-07-26 | Union | New Jersey | 34039 | 16534 | 1345 |
368436 | 368436 | 2020-07-25 | Union | New Jersey | 34039 | 16510 | 1345 |
365227 | 365227 | 2020-07-24 | Union | New Jersey | 34039 | 16496 | 1345 |
362021 | 362021 | 2020-07-23 | Union | New Jersey | 34039 | 16472 | 1343 |
358815 | 358815 | 2020-07-22 | Union | New Jersey | 34039 | 16526 | 1342 |
355611 | 355611 | 2020-07-21 | Union | New Jersey | 34039 | 16694 | 1346 |
352408 | 352408 | 2020-07-20 | Union | New Jersey | 34039 | 16696 | 1344 |
349205 | 349205 | 2020-07-19 | Union | New Jersey | 34039 | 16687 | 1344 |
346004 | 346004 | 2020-07-18 | Union | New Jersey | 34039 | 16725 | 1344 |
342805 | 342805 | 2020-07-17 | Union | New Jersey | 34039 | 16719 | 1343 |
339607 | 339607 | 2020-07-16 | Union | New Jersey | 34039 | 16746 | 1341 |
336411 | 336411 | 2020-07-15 | Union | New Jersey | 34039 | 16742 | 1340 |
333217 | 333217 | 2020-07-14 | Union | New Jersey | 34039 | 16721 | 1344 |
330027 | 330027 | 2020-07-13 | Union | New Jersey | 34039 | 16703 | 1343 |
326840 | 326840 | 2020-07-12 | Union | New Jersey | 34039 | 16685 | 1343 |
323656 | 323656 | 2020-07-11 | Union | New Jersey | 34039 | 16655 | 1343 |
320476 | 320476 | 2020-07-10 | Union | New Jersey | 34039 | 16644 | 1341 |
317300 | 317300 | 2020-07-09 | Union | New Jersey | 34039 | 16646 | 1341 |
314126 | 314126 | 2020-07-08 | Union | New Jersey | 34039 | 16618 | 1330 |
310955 | 310955 | 2020-07-07 | Union | New Jersey | 34039 | 16625 | 1331 |
307787 | 307787 | 2020-07-06 | Union | New Jersey | 34039 | 16607 | 1328 |
304620 | 304620 | 2020-07-05 | Union | New Jersey | 34039 | 16630 | 1328 |
301457 | 301457 | 2020-07-04 | Union | New Jersey | 34039 | 16616 | 1327 |
298294 | 298294 | 2020-07-03 | Union | New Jersey | 34039 | 16591 | 1326 |
295134 | 295134 | 2020-07-02 | Union | New Jersey | 34039 | 16569 | 1325 |
291979 | 291979 | 2020-07-01 | Union | New Jersey | 34039 | 16564 | 1329 |
288827 | 288827 | 2020-06-30 | Union | New Jersey | 34039 | 16566 | 1326 |
285677 | 285677 | 2020-06-29 | Union | New Jersey | 34039 | 16557 | 1325 |
282532 | 282532 | 2020-06-28 | Union | New Jersey | 34039 | 16548 | 1325 |
279385 | 279385 | 2020-06-27 | Union | New Jersey | 34039 | 16533 | 1324 |
276237 | 276237 | 2020-06-26 | Union | New Jersey | 34039 | 16536 | 1323 |
273092 | 273092 | 2020-06-25 | Union | New Jersey | 34039 | 16514 | 1321 |
269953 | 269953 | 2020-06-24 | Union | New Jersey | 34039 | 16330 | 1140 |
266818 | 266818 | 2020-06-23 | Union | New Jersey | 34039 | 16341 | 1139 |
263691 | 263691 | 2020-06-22 | Union | New Jersey | 34039 | 16340 | 1138 |
260562 | 260562 | 2020-06-21 | Union | New Jersey | 34039 | 16322 | 1135 |
257436 | 257436 | 2020-06-20 | Union | New Jersey | 34039 | 16298 | 1135 |
254313 | 254313 | 2020-06-19 | Union | New Jersey | 34039 | 16291 | 1131 |
251198 | 251198 | 2020-06-18 | Union | New Jersey | 34039 | 16304 | 1132 |
248083 | 248083 | 2020-06-17 | Union | New Jersey | 34039 | 16315 | 1131 |
244970 | 244970 | 2020-06-16 | Union | New Jersey | 34039 | 16320 | 1130 |
241858 | 241858 | 2020-06-15 | Union | New Jersey | 34039 | 16308 | 1128 |
238748 | 238748 | 2020-06-14 | Union | New Jersey | 34039 | 16322 | 1126 |
235641 | 235641 | 2020-06-13 | Union | New Jersey | 34039 | 16337 | 1121 |
232536 | 232536 | 2020-06-12 | Union | New Jersey | 34039 | 16351 | 1112 |
229431 | 229431 | 2020-06-11 | Union | New Jersey | 34039 | 16337 | 1104 |
226327 | 226327 | 2020-06-10 | Union | New Jersey | 34039 | 16317 | 1103 |
223227 | 223227 | 2020-06-09 | Union | New Jersey | 34039 | 16302 | 1100 |
220132 | 220132 | 2020-06-08 | Union | New Jersey | 34039 | 16241 | 1100 |
217040 | 217040 | 2020-06-07 | Union | New Jersey | 34039 | 16186 | 1098 |
213951 | 213951 | 2020-06-06 | Union | New Jersey | 34039 | 16116 | 1095 |
210867 | 210867 | 2020-06-05 | Union | New Jersey | 34039 | 16038 | 1092 |
207785 | 207785 | 2020-06-04 | Union | New Jersey | 34039 | 15953 | 1088 |
204704 | 204704 | 2020-06-03 | Union | New Jersey | 34039 | 15911 | 1086 |
201627 | 201627 | 2020-06-02 | Union | New Jersey | 34039 | 15868 | 1078 |
198553 | 198553 | 2020-06-01 | Union | New Jersey | 34039 | 15858 | 1074 |
195480 | 195480 | 2020-05-31 | Union | New Jersey | 34039 | 15821 | 1073 |
192410 | 192410 | 2020-05-30 | Union | New Jersey | 34039 | 15764 | 1067 |
189346 | 189346 | 2020-05-29 | Union | New Jersey | 34039 | 15610 | 1060 |
186286 | 186286 | 2020-05-28 | Union | New Jersey | 34039 | 15475 | 1047 |
183229 | 183229 | 2020-05-27 | Union | New Jersey | 34039 | 15324 | 1042 |
180181 | 180181 | 2020-05-26 | Union | New Jersey | 34039 | 15293 | 1030 |
177137 | 177137 | 2020-05-25 | Union | New Jersey | 34039 | 15218 | 1024 |
174094 | 174094 | 2020-05-24 | Union | New Jersey | 34039 | 15169 | 1025 |
171052 | 171052 | 2020-05-23 | Union | New Jersey | 34039 | 15186 | 1022 |
168013 | 168013 | 2020-05-22 | Union | New Jersey | 34039 | 15191 | 1018 |
164977 | 164977 | 2020-05-21 | Union | New Jersey | 34039 | 15176 | 1005 |
161948 | 161948 | 2020-05-20 | Union | New Jersey | 34039 | 15122 | 994 |
158922 | 158922 | 2020-05-19 | Union | New Jersey | 34039 | 15031 | 977 |
155904 | 155904 | 2020-05-18 | Union | New Jersey | 34039 | 14903 | 962 |
152888 | 152888 | 2020-05-17 | Union | New Jersey | 34039 | 14702 | 957 |
149878 | 149878 | 2020-05-16 | Union | New Jersey | 34039 | 14569 | 946 |
146871 | 146871 | 2020-05-15 | Union | New Jersey | 34039 | 14492 | 939 |
143870 | 143870 | 2020-05-14 | Union | New Jersey | 34039 | 14385 | 930 |
140875 | 140875 | 2020-05-13 | Union | New Jersey | 34039 | 14306 | 908 |
137879 | 137879 | 2020-05-12 | Union | New Jersey | 34039 | 14203 | 899 |
134889 | 134889 | 2020-05-11 | Union | New Jersey | 34039 | 14164 | 875 |
131898 | 131898 | 2020-05-10 | Union | New Jersey | 34039 | 14057 | 867 |
128909 | 128909 | 2020-05-09 | Union | New Jersey | 34039 | 13984 | 852 |
125920 | 125920 | 2020-05-08 | Union | New Jersey | 34039 | 13917 | 844 |
122937 | 122937 | 2020-05-07 | Union | New Jersey | 34039 | 13781 | 829 |
119962 | 119962 | 2020-05-06 | Union | New Jersey | 34039 | 13604 | 800 |
117001 | 117001 | 2020-05-05 | Union | New Jersey | 34039 | 13503 | 768 |
114120 | 114120 | 2020-05-04 | Union | New Jersey | 34039 | 13357 | 737 |
111239 | 111239 | 2020-05-03 | Union | New Jersey | 34039 | 13225 | 738 |
108366 | 108366 | 2020-05-02 | Union | New Jersey | 34039 | 12996 | 731 |
105500 | 105500 | 2020-05-01 | Union | New Jersey | 34039 | 12779 | 714 |
102638 | 102638 | 2020-04-30 | Union | New Jersey | 34039 | 12578 | 690 |
99785 | 99785 | 2020-04-29 | Union | New Jersey | 34039 | 12380 | 653 |
96938 | 96938 | 2020-04-28 | Union | New Jersey | 34039 | 12188 | 627 |
94102 | 94102 | 2020-04-27 | Union | New Jersey | 34039 | 12011 | 583 |
91278 | 91278 | 2020-04-26 | Union | New Jersey | 34039 | 11853 | 571 |
88463 | 88463 | 2020-04-25 | Union | New Jersey | 34039 | 11523 | 563 |
85652 | 85652 | 2020-04-24 | Union | New Jersey | 34039 | 11208 | 542 |
82848 | 82848 | 2020-04-23 | Union | New Jersey | 34039 | 10935 | 515 |
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);