ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Warren" and fips = 34041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387730 | 387730 | 2020-07-31 | Warren | New Jersey | 34041 | 1343 | 170 |
384513 | 384513 | 2020-07-30 | Warren | New Jersey | 34041 | 1340 | 170 |
381295 | 381295 | 2020-07-29 | Warren | New Jersey | 34041 | 1341 | 171 |
378077 | 378077 | 2020-07-28 | Warren | New Jersey | 34041 | 1335 | 170 |
374862 | 374862 | 2020-07-27 | Warren | New Jersey | 34041 | 1329 | 170 |
371650 | 371650 | 2020-07-26 | Warren | New Jersey | 34041 | 1326 | 169 |
368438 | 368438 | 2020-07-25 | Warren | New Jersey | 34041 | 1322 | 169 |
365229 | 365229 | 2020-07-24 | Warren | New Jersey | 34041 | 1316 | 169 |
362023 | 362023 | 2020-07-23 | Warren | New Jersey | 34041 | 1310 | 169 |
358817 | 358817 | 2020-07-22 | Warren | New Jersey | 34041 | 1309 | 169 |
355613 | 355613 | 2020-07-21 | Warren | New Jersey | 34041 | 1303 | 172 |
352410 | 352410 | 2020-07-20 | Warren | New Jersey | 34041 | 1297 | 171 |
349207 | 349207 | 2020-07-19 | Warren | New Jersey | 34041 | 1293 | 171 |
346006 | 346006 | 2020-07-18 | Warren | New Jersey | 34041 | 1290 | 171 |
342807 | 342807 | 2020-07-17 | Warren | New Jersey | 34041 | 1289 | 171 |
339609 | 339609 | 2020-07-16 | Warren | New Jersey | 34041 | 1285 | 171 |
336413 | 336413 | 2020-07-15 | Warren | New Jersey | 34041 | 1284 | 170 |
333219 | 333219 | 2020-07-14 | Warren | New Jersey | 34041 | 1281 | 167 |
330029 | 330029 | 2020-07-13 | Warren | New Jersey | 34041 | 1279 | 167 |
326842 | 326842 | 2020-07-12 | Warren | New Jersey | 34041 | 1279 | 167 |
323658 | 323658 | 2020-07-11 | Warren | New Jersey | 34041 | 1277 | 167 |
320478 | 320478 | 2020-07-10 | Warren | New Jersey | 34041 | 1276 | 167 |
317302 | 317302 | 2020-07-09 | Warren | New Jersey | 34041 | 1275 | 167 |
314128 | 314128 | 2020-07-08 | Warren | New Jersey | 34041 | 1273 | 164 |
310957 | 310957 | 2020-07-07 | Warren | New Jersey | 34041 | 1269 | 162 |
307789 | 307789 | 2020-07-06 | Warren | New Jersey | 34041 | 1266 | 162 |
304622 | 304622 | 2020-07-05 | Warren | New Jersey | 34041 | 1264 | 161 |
301459 | 301459 | 2020-07-04 | Warren | New Jersey | 34041 | 1260 | 161 |
298296 | 298296 | 2020-07-03 | Warren | New Jersey | 34041 | 1257 | 161 |
295136 | 295136 | 2020-07-02 | Warren | New Jersey | 34041 | 1254 | 160 |
291981 | 291981 | 2020-07-01 | Warren | New Jersey | 34041 | 1252 | 159 |
288829 | 288829 | 2020-06-30 | Warren | New Jersey | 34041 | 1244 | 158 |
285679 | 285679 | 2020-06-29 | Warren | New Jersey | 34041 | 1241 | 156 |
282534 | 282534 | 2020-06-28 | Warren | New Jersey | 34041 | 1239 | 156 |
279387 | 279387 | 2020-06-27 | Warren | New Jersey | 34041 | 1238 | 156 |
276239 | 276239 | 2020-06-26 | Warren | New Jersey | 34041 | 1236 | 155 |
273094 | 273094 | 2020-06-25 | Warren | New Jersey | 34041 | 1235 | 155 |
269955 | 269955 | 2020-06-24 | Warren | New Jersey | 34041 | 1222 | 144 |
266820 | 266820 | 2020-06-23 | Warren | New Jersey | 34041 | 1221 | 144 |
263693 | 263693 | 2020-06-22 | Warren | New Jersey | 34041 | 1218 | 142 |
260564 | 260564 | 2020-06-21 | Warren | New Jersey | 34041 | 1216 | 142 |
257438 | 257438 | 2020-06-20 | Warren | New Jersey | 34041 | 1211 | 142 |
254315 | 254315 | 2020-06-19 | Warren | New Jersey | 34041 | 1209 | 141 |
251200 | 251200 | 2020-06-18 | Warren | New Jersey | 34041 | 1205 | 139 |
248085 | 248085 | 2020-06-17 | Warren | New Jersey | 34041 | 1206 | 140 |
244972 | 244972 | 2020-06-16 | Warren | New Jersey | 34041 | 1205 | 140 |
241860 | 241860 | 2020-06-15 | Warren | New Jersey | 34041 | 1202 | 138 |
238750 | 238750 | 2020-06-14 | Warren | New Jersey | 34041 | 1202 | 138 |
235643 | 235643 | 2020-06-13 | Warren | New Jersey | 34041 | 1202 | 138 |
232538 | 232538 | 2020-06-12 | Warren | New Jersey | 34041 | 1200 | 138 |
229433 | 229433 | 2020-06-11 | Warren | New Jersey | 34041 | 1198 | 137 |
226329 | 226329 | 2020-06-10 | Warren | New Jersey | 34041 | 1197 | 135 |
223229 | 223229 | 2020-06-09 | Warren | New Jersey | 34041 | 1193 | 135 |
220134 | 220134 | 2020-06-08 | Warren | New Jersey | 34041 | 1192 | 135 |
217042 | 217042 | 2020-06-07 | Warren | New Jersey | 34041 | 1189 | 132 |
213953 | 213953 | 2020-06-06 | Warren | New Jersey | 34041 | 1190 | 132 |
210869 | 210869 | 2020-06-05 | Warren | New Jersey | 34041 | 1189 | 132 |
207787 | 207787 | 2020-06-04 | Warren | New Jersey | 34041 | 1186 | 132 |
204706 | 204706 | 2020-06-03 | Warren | New Jersey | 34041 | 1182 | 132 |
201629 | 201629 | 2020-06-02 | Warren | New Jersey | 34041 | 1173 | 132 |
198555 | 198555 | 2020-06-01 | Warren | New Jersey | 34041 | 1165 | 132 |
195482 | 195482 | 2020-05-31 | Warren | New Jersey | 34041 | 1160 | 131 |
192412 | 192412 | 2020-05-30 | Warren | New Jersey | 34041 | 1162 | 131 |
189348 | 189348 | 2020-05-29 | Warren | New Jersey | 34041 | 1153 | 131 |
186288 | 186288 | 2020-05-28 | Warren | New Jersey | 34041 | 1146 | 129 |
183231 | 183231 | 2020-05-27 | Warren | New Jersey | 34041 | 1145 | 129 |
180183 | 180183 | 2020-05-26 | Warren | New Jersey | 34041 | 1136 | 128 |
177139 | 177139 | 2020-05-25 | Warren | New Jersey | 34041 | 1132 | 126 |
174096 | 174096 | 2020-05-24 | Warren | New Jersey | 34041 | 1125 | 126 |
171054 | 171054 | 2020-05-23 | Warren | New Jersey | 34041 | 1119 | 126 |
168015 | 168015 | 2020-05-22 | Warren | New Jersey | 34041 | 1118 | 123 |
164979 | 164979 | 2020-05-21 | Warren | New Jersey | 34041 | 1111 | 123 |
161950 | 161950 | 2020-05-20 | Warren | New Jersey | 34041 | 1100 | 122 |
158924 | 158924 | 2020-05-19 | Warren | New Jersey | 34041 | 1091 | 121 |
155906 | 155906 | 2020-05-18 | Warren | New Jersey | 34041 | 1086 | 121 |
152890 | 152890 | 2020-05-17 | Warren | New Jersey | 34041 | 1078 | 120 |
149880 | 149880 | 2020-05-16 | Warren | New Jersey | 34041 | 1077 | 118 |
146873 | 146873 | 2020-05-15 | Warren | New Jersey | 34041 | 1072 | 118 |
143872 | 143872 | 2020-05-14 | Warren | New Jersey | 34041 | 1068 | 115 |
140877 | 140877 | 2020-05-13 | Warren | New Jersey | 34041 | 1066 | 114 |
137881 | 137881 | 2020-05-12 | Warren | New Jersey | 34041 | 1061 | 108 |
134891 | 134891 | 2020-05-11 | Warren | New Jersey | 34041 | 1047 | 104 |
131900 | 131900 | 2020-05-10 | Warren | New Jersey | 34041 | 1044 | 104 |
128911 | 128911 | 2020-05-09 | Warren | New Jersey | 34041 | 1040 | 103 |
125922 | 125922 | 2020-05-08 | Warren | New Jersey | 34041 | 1034 | 101 |
122939 | 122939 | 2020-05-07 | Warren | New Jersey | 34041 | 1004 | 99 |
119964 | 119964 | 2020-05-06 | Warren | New Jersey | 34041 | 993 | 94 |
117003 | 117003 | 2020-05-05 | Warren | New Jersey | 34041 | 982 | 91 |
114122 | 114122 | 2020-05-04 | Warren | New Jersey | 34041 | 977 | 87 |
111241 | 111241 | 2020-05-03 | Warren | New Jersey | 34041 | 957 | 86 |
108368 | 108368 | 2020-05-02 | Warren | New Jersey | 34041 | 941 | 84 |
105502 | 105502 | 2020-05-01 | Warren | New Jersey | 34041 | 920 | 83 |
102640 | 102640 | 2020-04-30 | Warren | New Jersey | 34041 | 903 | 82 |
99787 | 99787 | 2020-04-29 | Warren | New Jersey | 34041 | 880 | 81 |
96940 | 96940 | 2020-04-28 | Warren | New Jersey | 34041 | 848 | 71 |
94104 | 94104 | 2020-04-27 | Warren | New Jersey | 34041 | 810 | 67 |
91280 | 91280 | 2020-04-26 | Warren | New Jersey | 34041 | 778 | 65 |
88465 | 88465 | 2020-04-25 | Warren | New Jersey | 34041 | 750 | 63 |
85654 | 85654 | 2020-04-24 | Warren | New Jersey | 34041 | 729 | 61 |
82850 | 82850 | 2020-04-23 | Warren | New Jersey | 34041 | 719 | 60 |
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);