ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Warren" and state = "New Jersey" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3532 | 3532 | 2020-03-17 | Warren | New Jersey | 34041 | 1 | 0 |
4128 | 4128 | 2020-03-18 | Warren | New Jersey | 34041 | 2 | 0 |
4856 | 4856 | 2020-03-19 | Warren | New Jersey | 34041 | 4 | 0 |
5700 | 5700 | 2020-03-20 | Warren | New Jersey | 34041 | 4 | 0 |
6693 | 6693 | 2020-03-21 | Warren | New Jersey | 34041 | 5 | 0 |
7785 | 7785 | 2020-03-22 | Warren | New Jersey | 34041 | 9 | 0 |
8981 | 8981 | 2020-03-23 | Warren | New Jersey | 34041 | 15 | 1 |
10285 | 10285 | 2020-03-24 | Warren | New Jersey | 34041 | 15 | 1 |
11717 | 11717 | 2020-03-25 | Warren | New Jersey | 34041 | 18 | 1 |
13320 | 13320 | 2020-03-26 | Warren | New Jersey | 34041 | 31 | 1 |
15052 | 15052 | 2020-03-27 | Warren | New Jersey | 34041 | 38 | 1 |
16881 | 16881 | 2020-03-28 | Warren | New Jersey | 34041 | 51 | 2 |
18805 | 18805 | 2020-03-29 | Warren | New Jersey | 34041 | 56 | 2 |
20843 | 20843 | 2020-03-30 | Warren | New Jersey | 34041 | 68 | 2 |
22966 | 22966 | 2020-03-31 | Warren | New Jersey | 34041 | 76 | 2 |
25157 | 25157 | 2020-04-01 | Warren | New Jersey | 34041 | 96 | 3 |
27417 | 27417 | 2020-04-02 | Warren | New Jersey | 34041 | 116 | 3 |
29740 | 29740 | 2020-04-03 | Warren | New Jersey | 34041 | 149 | 3 |
32125 | 32125 | 2020-04-04 | Warren | New Jersey | 34041 | 182 | 6 |
34556 | 34556 | 2020-04-05 | Warren | New Jersey | 34041 | 195 | 6 |
37026 | 37026 | 2020-04-06 | Warren | New Jersey | 34041 | 215 | 7 |
39541 | 39541 | 2020-04-07 | Warren | New Jersey | 34041 | 255 | 7 |
42098 | 42098 | 2020-04-08 | Warren | New Jersey | 34041 | 289 | 9 |
44680 | 44680 | 2020-04-09 | Warren | New Jersey | 34041 | 319 | 7 |
47292 | 47292 | 2020-04-10 | Warren | New Jersey | 34041 | 337 | 15 |
49946 | 49946 | 2020-04-11 | Warren | New Jersey | 34041 | 362 | 18 |
52619 | 52619 | 2020-04-12 | Warren | New Jersey | 34041 | 395 | 22 |
55302 | 55302 | 2020-04-13 | Warren | New Jersey | 34041 | 416 | 24 |
58002 | 58002 | 2020-04-14 | Warren | New Jersey | 34041 | 442 | 25 |
60716 | 60716 | 2020-04-15 | Warren | New Jersey | 34041 | 468 | 30 |
63442 | 63442 | 2020-04-16 | Warren | New Jersey | 34041 | 501 | 33 |
66184 | 66184 | 2020-04-17 | Warren | New Jersey | 34041 | 521 | 36 |
68940 | 68940 | 2020-04-18 | Warren | New Jersey | 34041 | 543 | 39 |
71707 | 71707 | 2020-04-19 | Warren | New Jersey | 34041 | 592 | 44 |
74482 | 74482 | 2020-04-20 | Warren | New Jersey | 34041 | 613 | 47 |
77263 | 77263 | 2020-04-21 | Warren | New Jersey | 34041 | 642 | 48 |
80052 | 80052 | 2020-04-22 | Warren | New Jersey | 34041 | 689 | 55 |
82850 | 82850 | 2020-04-23 | Warren | New Jersey | 34041 | 719 | 60 |
85654 | 85654 | 2020-04-24 | Warren | New Jersey | 34041 | 729 | 61 |
88465 | 88465 | 2020-04-25 | Warren | New Jersey | 34041 | 750 | 63 |
91280 | 91280 | 2020-04-26 | Warren | New Jersey | 34041 | 778 | 65 |
94104 | 94104 | 2020-04-27 | Warren | New Jersey | 34041 | 810 | 67 |
96940 | 96940 | 2020-04-28 | Warren | New Jersey | 34041 | 848 | 71 |
99787 | 99787 | 2020-04-29 | Warren | New Jersey | 34041 | 880 | 81 |
102640 | 102640 | 2020-04-30 | Warren | New Jersey | 34041 | 903 | 82 |
105502 | 105502 | 2020-05-01 | Warren | New Jersey | 34041 | 920 | 83 |
108368 | 108368 | 2020-05-02 | Warren | New Jersey | 34041 | 941 | 84 |
111241 | 111241 | 2020-05-03 | Warren | New Jersey | 34041 | 957 | 86 |
114122 | 114122 | 2020-05-04 | Warren | New Jersey | 34041 | 977 | 87 |
117003 | 117003 | 2020-05-05 | Warren | New Jersey | 34041 | 982 | 91 |
119964 | 119964 | 2020-05-06 | Warren | New Jersey | 34041 | 993 | 94 |
122939 | 122939 | 2020-05-07 | Warren | New Jersey | 34041 | 1004 | 99 |
125922 | 125922 | 2020-05-08 | Warren | New Jersey | 34041 | 1034 | 101 |
128911 | 128911 | 2020-05-09 | Warren | New Jersey | 34041 | 1040 | 103 |
131900 | 131900 | 2020-05-10 | Warren | New Jersey | 34041 | 1044 | 104 |
134891 | 134891 | 2020-05-11 | Warren | New Jersey | 34041 | 1047 | 104 |
137881 | 137881 | 2020-05-12 | Warren | New Jersey | 34041 | 1061 | 108 |
140877 | 140877 | 2020-05-13 | Warren | New Jersey | 34041 | 1066 | 114 |
143872 | 143872 | 2020-05-14 | Warren | New Jersey | 34041 | 1068 | 115 |
146873 | 146873 | 2020-05-15 | Warren | New Jersey | 34041 | 1072 | 118 |
149880 | 149880 | 2020-05-16 | Warren | New Jersey | 34041 | 1077 | 118 |
152890 | 152890 | 2020-05-17 | Warren | New Jersey | 34041 | 1078 | 120 |
155906 | 155906 | 2020-05-18 | Warren | New Jersey | 34041 | 1086 | 121 |
158924 | 158924 | 2020-05-19 | Warren | New Jersey | 34041 | 1091 | 121 |
161950 | 161950 | 2020-05-20 | Warren | New Jersey | 34041 | 1100 | 122 |
164979 | 164979 | 2020-05-21 | Warren | New Jersey | 34041 | 1111 | 123 |
168015 | 168015 | 2020-05-22 | Warren | New Jersey | 34041 | 1118 | 123 |
171054 | 171054 | 2020-05-23 | Warren | New Jersey | 34041 | 1119 | 126 |
174096 | 174096 | 2020-05-24 | Warren | New Jersey | 34041 | 1125 | 126 |
177139 | 177139 | 2020-05-25 | Warren | New Jersey | 34041 | 1132 | 126 |
180183 | 180183 | 2020-05-26 | Warren | New Jersey | 34041 | 1136 | 128 |
183231 | 183231 | 2020-05-27 | Warren | New Jersey | 34041 | 1145 | 129 |
186288 | 186288 | 2020-05-28 | Warren | New Jersey | 34041 | 1146 | 129 |
189348 | 189348 | 2020-05-29 | Warren | New Jersey | 34041 | 1153 | 131 |
192412 | 192412 | 2020-05-30 | Warren | New Jersey | 34041 | 1162 | 131 |
195482 | 195482 | 2020-05-31 | Warren | New Jersey | 34041 | 1160 | 131 |
198555 | 198555 | 2020-06-01 | Warren | New Jersey | 34041 | 1165 | 132 |
201629 | 201629 | 2020-06-02 | Warren | New Jersey | 34041 | 1173 | 132 |
204706 | 204706 | 2020-06-03 | Warren | New Jersey | 34041 | 1182 | 132 |
207787 | 207787 | 2020-06-04 | Warren | New Jersey | 34041 | 1186 | 132 |
210869 | 210869 | 2020-06-05 | Warren | New Jersey | 34041 | 1189 | 132 |
213953 | 213953 | 2020-06-06 | Warren | New Jersey | 34041 | 1190 | 132 |
217042 | 217042 | 2020-06-07 | Warren | New Jersey | 34041 | 1189 | 132 |
220134 | 220134 | 2020-06-08 | Warren | New Jersey | 34041 | 1192 | 135 |
223229 | 223229 | 2020-06-09 | Warren | New Jersey | 34041 | 1193 | 135 |
226329 | 226329 | 2020-06-10 | Warren | New Jersey | 34041 | 1197 | 135 |
229433 | 229433 | 2020-06-11 | Warren | New Jersey | 34041 | 1198 | 137 |
232538 | 232538 | 2020-06-12 | Warren | New Jersey | 34041 | 1200 | 138 |
235643 | 235643 | 2020-06-13 | Warren | New Jersey | 34041 | 1202 | 138 |
238750 | 238750 | 2020-06-14 | Warren | New Jersey | 34041 | 1202 | 138 |
241860 | 241860 | 2020-06-15 | Warren | New Jersey | 34041 | 1202 | 138 |
244972 | 244972 | 2020-06-16 | Warren | New Jersey | 34041 | 1205 | 140 |
248085 | 248085 | 2020-06-17 | Warren | New Jersey | 34041 | 1206 | 140 |
251200 | 251200 | 2020-06-18 | Warren | New Jersey | 34041 | 1205 | 139 |
254315 | 254315 | 2020-06-19 | Warren | New Jersey | 34041 | 1209 | 141 |
257438 | 257438 | 2020-06-20 | Warren | New Jersey | 34041 | 1211 | 142 |
260564 | 260564 | 2020-06-21 | Warren | New Jersey | 34041 | 1216 | 142 |
263693 | 263693 | 2020-06-22 | Warren | New Jersey | 34041 | 1218 | 142 |
266820 | 266820 | 2020-06-23 | Warren | New Jersey | 34041 | 1221 | 144 |
269955 | 269955 | 2020-06-24 | Warren | New Jersey | 34041 | 1222 | 144 |
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);