ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Hudson" and 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 |
---|---|---|---|---|---|---|---|
943 | 943 | 2020-03-09 | Hudson | New Jersey | 34017 | 1 | 0 |
1094 | 1094 | 2020-03-10 | Hudson | New Jersey | 34017 | 1 | 0 |
1276 | 1276 | 2020-03-11 | Hudson | New Jersey | 34017 | 1 | 0 |
1506 | 1506 | 2020-03-12 | Hudson | New Jersey | 34017 | 1 | 0 |
1798 | 1798 | 2020-03-13 | Hudson | New Jersey | 34017 | 3 | 0 |
2144 | 2144 | 2020-03-14 | Hudson | New Jersey | 34017 | 5 | 0 |
2552 | 2552 | 2020-03-15 | Hudson | New Jersey | 34017 | 10 | 0 |
3008 | 3008 | 2020-03-16 | Hudson | New Jersey | 34017 | 19 | 0 |
3521 | 3521 | 2020-03-17 | Hudson | New Jersey | 34017 | 24 | 0 |
4117 | 4117 | 2020-03-18 | Hudson | New Jersey | 34017 | 34 | 0 |
4844 | 4844 | 2020-03-19 | Hudson | New Jersey | 34017 | 55 | 0 |
5688 | 5688 | 2020-03-20 | Hudson | New Jersey | 34017 | 66 | 0 |
6681 | 6681 | 2020-03-21 | Hudson | New Jersey | 34017 | 97 | 0 |
7772 | 7772 | 2020-03-22 | Hudson | New Jersey | 34017 | 126 | 0 |
8968 | 8968 | 2020-03-23 | Hudson | New Jersey | 34017 | 190 | 0 |
10272 | 10272 | 2020-03-24 | Hudson | New Jersey | 34017 | 234 | 3 |
11704 | 11704 | 2020-03-25 | Hudson | New Jersey | 34017 | 260 | 4 |
13307 | 13307 | 2020-03-26 | Hudson | New Jersey | 34017 | 441 | 4 |
15039 | 15039 | 2020-03-27 | Hudson | New Jersey | 34017 | 594 | 4 |
16868 | 16868 | 2020-03-28 | Hudson | New Jersey | 34017 | 771 | 6 |
18792 | 18792 | 2020-03-29 | Hudson | New Jersey | 34017 | 974 | 6 |
20830 | 20830 | 2020-03-30 | Hudson | New Jersey | 34017 | 1314 | 11 |
22953 | 22953 | 2020-03-31 | Hudson | New Jersey | 34017 | 1606 | 16 |
25144 | 25144 | 2020-04-01 | Hudson | New Jersey | 34017 | 1910 | 29 |
27404 | 27404 | 2020-04-02 | Hudson | New Jersey | 34017 | 2270 | 44 |
29727 | 29727 | 2020-04-03 | Hudson | New Jersey | 34017 | 2835 | 59 |
32112 | 32112 | 2020-04-04 | Hudson | New Jersey | 34017 | 3491 | 78 |
34543 | 34543 | 2020-04-05 | Hudson | New Jersey | 34017 | 3924 | 87 |
37013 | 37013 | 2020-04-06 | Hudson | New Jersey | 34017 | 4395 | 92 |
39528 | 39528 | 2020-04-07 | Hudson | New Jersey | 34017 | 4949 | 103 |
42085 | 42085 | 2020-04-08 | Hudson | New Jersey | 34017 | 5437 | 122 |
44667 | 44667 | 2020-04-09 | Hudson | New Jersey | 34017 | 5879 | 132 |
47279 | 47279 | 2020-04-10 | Hudson | New Jersey | 34017 | 6411 | 163 |
49933 | 49933 | 2020-04-11 | Hudson | New Jersey | 34017 | 6851 | 183 |
52606 | 52606 | 2020-04-12 | Hudson | New Jersey | 34017 | 7469 | 226 |
55289 | 55289 | 2020-04-13 | Hudson | New Jersey | 34017 | 7879 | 236 |
57989 | 57989 | 2020-04-14 | Hudson | New Jersey | 34017 | 8242 | 277 |
60703 | 60703 | 2020-04-15 | Hudson | New Jersey | 34017 | 8511 | 312 |
63429 | 63429 | 2020-04-16 | Hudson | New Jersey | 34017 | 9165 | 365 |
66171 | 66171 | 2020-04-17 | Hudson | New Jersey | 34017 | 9636 | 420 |
68927 | 68927 | 2020-04-18 | Hudson | New Jersey | 34017 | 9956 | 434 |
71694 | 71694 | 2020-04-19 | Hudson | New Jersey | 34017 | 10486 | 452 |
74469 | 74469 | 2020-04-20 | Hudson | New Jersey | 34017 | 11150 | 492 |
77250 | 77250 | 2020-04-21 | Hudson | New Jersey | 34017 | 11636 | 525 |
80039 | 80039 | 2020-04-22 | Hudson | New Jersey | 34017 | 12039 | 568 |
82837 | 82837 | 2020-04-23 | Hudson | New Jersey | 34017 | 12645 | 606 |
85641 | 85641 | 2020-04-24 | Hudson | New Jersey | 34017 | 13011 | 640 |
88452 | 88452 | 2020-04-25 | Hudson | New Jersey | 34017 | 13367 | 655 |
91267 | 91267 | 2020-04-26 | Hudson | New Jersey | 34017 | 13708 | 661 |
94091 | 94091 | 2020-04-27 | Hudson | New Jersey | 34017 | 13925 | 673 |
96927 | 96927 | 2020-04-28 | Hudson | New Jersey | 34017 | 14309 | 722 |
99774 | 99774 | 2020-04-29 | Hudson | New Jersey | 34017 | 14596 | 758 |
102627 | 102627 | 2020-04-30 | Hudson | New Jersey | 34017 | 14916 | 798 |
105489 | 105489 | 2020-05-01 | Hudson | New Jersey | 34017 | 15148 | 819 |
108355 | 108355 | 2020-05-02 | Hudson | New Jersey | 34017 | 15401 | 834 |
111228 | 111228 | 2020-05-03 | Hudson | New Jersey | 34017 | 15769 | 845 |
114109 | 114109 | 2020-05-04 | Hudson | New Jersey | 34017 | 15881 | 845 |
116990 | 116990 | 2020-05-05 | Hudson | New Jersey | 34017 | 16099 | 870 |
119951 | 119951 | 2020-05-06 | Hudson | New Jersey | 34017 | 16197 | 903 |
122926 | 122926 | 2020-05-07 | Hudson | New Jersey | 34017 | 16354 | 923 |
125909 | 125909 | 2020-05-08 | Hudson | New Jersey | 34017 | 16520 | 940 |
128898 | 128898 | 2020-05-09 | Hudson | New Jersey | 34017 | 16675 | 954 |
131887 | 131887 | 2020-05-10 | Hudson | New Jersey | 34017 | 16822 | 969 |
134878 | 134878 | 2020-05-11 | Hudson | New Jersey | 34017 | 16936 | 971 |
137868 | 137868 | 2020-05-12 | Hudson | New Jersey | 34017 | 16975 | 981 |
140864 | 140864 | 2020-05-13 | Hudson | New Jersey | 34017 | 17035 | 1007 |
143859 | 143859 | 2020-05-14 | Hudson | New Jersey | 34017 | 17134 | 1032 |
146860 | 146860 | 2020-05-15 | Hudson | New Jersey | 34017 | 17237 | 1042 |
149867 | 149867 | 2020-05-16 | Hudson | New Jersey | 34017 | 17326 | 1045 |
152877 | 152877 | 2020-05-17 | Hudson | New Jersey | 34017 | 17447 | 1057 |
155893 | 155893 | 2020-05-18 | Hudson | New Jersey | 34017 | 17574 | 1068 |
158911 | 158911 | 2020-05-19 | Hudson | New Jersey | 34017 | 17621 | 1082 |
161937 | 161937 | 2020-05-20 | Hudson | New Jersey | 34017 | 17748 | 1106 |
164966 | 164966 | 2020-05-21 | Hudson | New Jersey | 34017 | 17814 | 1121 |
168002 | 168002 | 2020-05-22 | Hudson | New Jersey | 34017 | 17897 | 1134 |
171041 | 171041 | 2020-05-23 | Hudson | New Jersey | 34017 | 17910 | 1138 |
174083 | 174083 | 2020-05-24 | Hudson | New Jersey | 34017 | 17977 | 1139 |
177126 | 177126 | 2020-05-25 | Hudson | New Jersey | 34017 | 18051 | 1137 |
180170 | 180170 | 2020-05-26 | Hudson | New Jersey | 34017 | 18096 | 1143 |
183218 | 183218 | 2020-05-27 | Hudson | New Jersey | 34017 | 18132 | 1158 |
186275 | 186275 | 2020-05-28 | Hudson | New Jersey | 34017 | 18226 | 1161 |
189335 | 189335 | 2020-05-29 | Hudson | New Jersey | 34017 | 18287 | 1168 |
192399 | 192399 | 2020-05-30 | Hudson | New Jersey | 34017 | 18343 | 1173 |
195469 | 195469 | 2020-05-31 | Hudson | New Jersey | 34017 | 18419 | 1183 |
198542 | 198542 | 2020-06-01 | Hudson | New Jersey | 34017 | 18428 | 1182 |
201616 | 201616 | 2020-06-02 | Hudson | New Jersey | 34017 | 18455 | 1188 |
204693 | 204693 | 2020-06-03 | Hudson | New Jersey | 34017 | 18460 | 1192 |
207774 | 207774 | 2020-06-04 | Hudson | New Jersey | 34017 | 18465 | 1199 |
210856 | 210856 | 2020-06-05 | Hudson | New Jersey | 34017 | 18518 | 1205 |
213940 | 213940 | 2020-06-06 | Hudson | New Jersey | 34017 | 18548 | 1210 |
217029 | 217029 | 2020-06-07 | Hudson | New Jersey | 34017 | 18565 | 1218 |
220121 | 220121 | 2020-06-08 | Hudson | New Jersey | 34017 | 18584 | 1226 |
223216 | 223216 | 2020-06-09 | Hudson | New Jersey | 34017 | 18607 | 1235 |
226316 | 226316 | 2020-06-10 | Hudson | New Jersey | 34017 | 18647 | 1242 |
229420 | 229420 | 2020-06-11 | Hudson | New Jersey | 34017 | 18675 | 1242 |
232525 | 232525 | 2020-06-12 | Hudson | New Jersey | 34017 | 18693 | 1246 |
235630 | 235630 | 2020-06-13 | Hudson | New Jersey | 34017 | 18717 | 1253 |
238737 | 238737 | 2020-06-14 | Hudson | New Jersey | 34017 | 18746 | 1254 |
241847 | 241847 | 2020-06-15 | Hudson | New Jersey | 34017 | 18765 | 1256 |
244959 | 244959 | 2020-06-16 | Hudson | New Jersey | 34017 | 18744 | 1255 |
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);