ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 34035 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3016 | 3016 | 2020-03-16 | Somerset | New Jersey | 34035 | 4 | 0 |
3529 | 3529 | 2020-03-17 | Somerset | New Jersey | 34035 | 6 | 0 |
4125 | 4125 | 2020-03-18 | Somerset | New Jersey | 34035 | 15 | 0 |
4852 | 4852 | 2020-03-19 | Somerset | New Jersey | 34035 | 20 | 0 |
5696 | 5696 | 2020-03-20 | Somerset | New Jersey | 34035 | 27 | 0 |
6689 | 6689 | 2020-03-21 | Somerset | New Jersey | 34035 | 34 | 0 |
7781 | 7781 | 2020-03-22 | Somerset | New Jersey | 34035 | 51 | 1 |
8977 | 8977 | 2020-03-23 | Somerset | New Jersey | 34035 | 67 | 2 |
10281 | 10281 | 2020-03-24 | Somerset | New Jersey | 34035 | 102 | 2 |
11713 | 11713 | 2020-03-25 | Somerset | New Jersey | 34035 | 117 | 3 |
13316 | 13316 | 2020-03-26 | Somerset | New Jersey | 34035 | 179 | 4 |
15048 | 15048 | 2020-03-27 | Somerset | New Jersey | 34035 | 222 | 7 |
16877 | 16877 | 2020-03-28 | Somerset | New Jersey | 34035 | 258 | 8 |
18801 | 18801 | 2020-03-29 | Somerset | New Jersey | 34035 | 295 | 8 |
20839 | 20839 | 2020-03-30 | Somerset | New Jersey | 34035 | 349 | 14 |
22962 | 22962 | 2020-03-31 | Somerset | New Jersey | 34035 | 413 | 14 |
25153 | 25153 | 2020-04-01 | Somerset | New Jersey | 34035 | 472 | 15 |
27413 | 27413 | 2020-04-02 | Somerset | New Jersey | 34035 | 549 | 17 |
29736 | 29736 | 2020-04-03 | Somerset | New Jersey | 34035 | 641 | 23 |
32121 | 32121 | 2020-04-04 | Somerset | New Jersey | 34035 | 765 | 24 |
34552 | 34552 | 2020-04-05 | Somerset | New Jersey | 34035 | 833 | 26 |
37022 | 37022 | 2020-04-06 | Somerset | New Jersey | 34035 | 902 | 31 |
39537 | 39537 | 2020-04-07 | Somerset | New Jersey | 34035 | 1033 | 40 |
42094 | 42094 | 2020-04-08 | Somerset | New Jersey | 34035 | 1189 | 46 |
44676 | 44676 | 2020-04-09 | Somerset | New Jersey | 34035 | 1335 | 59 |
47288 | 47288 | 2020-04-10 | Somerset | New Jersey | 34035 | 1523 | 69 |
49942 | 49942 | 2020-04-11 | Somerset | New Jersey | 34035 | 1642 | 78 |
52615 | 52615 | 2020-04-12 | Somerset | New Jersey | 34035 | 1732 | 79 |
55298 | 55298 | 2020-04-13 | Somerset | New Jersey | 34035 | 1809 | 85 |
57998 | 57998 | 2020-04-14 | Somerset | New Jersey | 34035 | 1911 | 91 |
60712 | 60712 | 2020-04-15 | Somerset | New Jersey | 34035 | 2001 | 101 |
63438 | 63438 | 2020-04-16 | Somerset | New Jersey | 34035 | 2103 | 121 |
66180 | 66180 | 2020-04-17 | Somerset | New Jersey | 34035 | 2195 | 135 |
68936 | 68936 | 2020-04-18 | Somerset | New Jersey | 34035 | 2283 | 146 |
71703 | 71703 | 2020-04-19 | Somerset | New Jersey | 34035 | 2384 | 158 |
74478 | 74478 | 2020-04-20 | Somerset | New Jersey | 34035 | 2488 | 170 |
77259 | 77259 | 2020-04-21 | Somerset | New Jersey | 34035 | 2599 | 176 |
80048 | 80048 | 2020-04-22 | Somerset | New Jersey | 34035 | 2688 | 183 |
82846 | 82846 | 2020-04-23 | Somerset | New Jersey | 34035 | 2798 | 196 |
85650 | 85650 | 2020-04-24 | Somerset | New Jersey | 34035 | 2921 | 198 |
88461 | 88461 | 2020-04-25 | Somerset | New Jersey | 34035 | 3030 | 219 |
91276 | 91276 | 2020-04-26 | Somerset | New Jersey | 34035 | 3144 | 223 |
94100 | 94100 | 2020-04-27 | Somerset | New Jersey | 34035 | 3204 | 227 |
96936 | 96936 | 2020-04-28 | Somerset | New Jersey | 34035 | 3278 | 242 |
99783 | 99783 | 2020-04-29 | Somerset | New Jersey | 34035 | 3372 | 252 |
102636 | 102636 | 2020-04-30 | Somerset | New Jersey | 34035 | 3464 | 270 |
105498 | 105498 | 2020-05-01 | Somerset | New Jersey | 34035 | 3537 | 282 |
108364 | 108364 | 2020-05-02 | Somerset | New Jersey | 34035 | 3605 | 289 |
111237 | 111237 | 2020-05-03 | Somerset | New Jersey | 34035 | 3703 | 295 |
114118 | 114118 | 2020-05-04 | Somerset | New Jersey | 34035 | 3753 | 298 |
116999 | 116999 | 2020-05-05 | Somerset | New Jersey | 34035 | 3820 | 306 |
119960 | 119960 | 2020-05-06 | Somerset | New Jersey | 34035 | 3860 | 315 |
122935 | 122935 | 2020-05-07 | Somerset | New Jersey | 34035 | 3914 | 320 |
125918 | 125918 | 2020-05-08 | Somerset | New Jersey | 34035 | 3968 | 328 |
128907 | 128907 | 2020-05-09 | Somerset | New Jersey | 34035 | 3996 | 331 |
131896 | 131896 | 2020-05-10 | Somerset | New Jersey | 34035 | 4054 | 333 |
134887 | 134887 | 2020-05-11 | Somerset | New Jersey | 34035 | 4093 | 335 |
137877 | 137877 | 2020-05-12 | Somerset | New Jersey | 34035 | 4115 | 339 |
140873 | 140873 | 2020-05-13 | Somerset | New Jersey | 34035 | 4127 | 340 |
143868 | 143868 | 2020-05-14 | Somerset | New Jersey | 34035 | 4159 | 348 |
146869 | 146869 | 2020-05-15 | Somerset | New Jersey | 34035 | 4181 | 359 |
149876 | 149876 | 2020-05-16 | Somerset | New Jersey | 34035 | 4212 | 363 |
152886 | 152886 | 2020-05-17 | Somerset | New Jersey | 34035 | 4255 | 375 |
155902 | 155902 | 2020-05-18 | Somerset | New Jersey | 34035 | 4278 | 375 |
158920 | 158920 | 2020-05-19 | Somerset | New Jersey | 34035 | 4312 | 382 |
161946 | 161946 | 2020-05-20 | Somerset | New Jersey | 34035 | 4349 | 384 |
164975 | 164975 | 2020-05-21 | Somerset | New Jersey | 34035 | 4390 | 387 |
168011 | 168011 | 2020-05-22 | Somerset | New Jersey | 34035 | 4416 | 392 |
171050 | 171050 | 2020-05-23 | Somerset | New Jersey | 34035 | 4425 | 397 |
174092 | 174092 | 2020-05-24 | Somerset | New Jersey | 34035 | 4450 | 399 |
177135 | 177135 | 2020-05-25 | Somerset | New Jersey | 34035 | 4480 | 399 |
180179 | 180179 | 2020-05-26 | Somerset | New Jersey | 34035 | 4489 | 399 |
183227 | 183227 | 2020-05-27 | Somerset | New Jersey | 34035 | 4505 | 408 |
186284 | 186284 | 2020-05-28 | Somerset | New Jersey | 34035 | 4522 | 410 |
189344 | 189344 | 2020-05-29 | Somerset | New Jersey | 34035 | 4552 | 411 |
192408 | 192408 | 2020-05-30 | Somerset | New Jersey | 34035 | 4567 | 417 |
195478 | 195478 | 2020-05-31 | Somerset | New Jersey | 34035 | 4583 | 419 |
198551 | 198551 | 2020-06-01 | Somerset | New Jersey | 34035 | 4595 | 419 |
201625 | 201625 | 2020-06-02 | Somerset | New Jersey | 34035 | 4605 | 419 |
204702 | 204702 | 2020-06-03 | Somerset | New Jersey | 34035 | 4619 | 423 |
207783 | 207783 | 2020-06-04 | Somerset | New Jersey | 34035 | 4626 | 423 |
210865 | 210865 | 2020-06-05 | Somerset | New Jersey | 34035 | 4651 | 424 |
213949 | 213949 | 2020-06-06 | Somerset | New Jersey | 34035 | 4664 | 425 |
217038 | 217038 | 2020-06-07 | Somerset | New Jersey | 34035 | 4662 | 426 |
220130 | 220130 | 2020-06-08 | Somerset | New Jersey | 34035 | 4670 | 427 |
223225 | 223225 | 2020-06-09 | Somerset | New Jersey | 34035 | 4679 | 430 |
226325 | 226325 | 2020-06-10 | Somerset | New Jersey | 34035 | 4698 | 431 |
229429 | 229429 | 2020-06-11 | Somerset | New Jersey | 34035 | 4721 | 432 |
232534 | 232534 | 2020-06-12 | Somerset | New Jersey | 34035 | 4736 | 433 |
235639 | 235639 | 2020-06-13 | Somerset | New Jersey | 34035 | 4756 | 436 |
238746 | 238746 | 2020-06-14 | Somerset | New Jersey | 34035 | 4759 | 437 |
241856 | 241856 | 2020-06-15 | Somerset | New Jersey | 34035 | 4764 | 437 |
244968 | 244968 | 2020-06-16 | Somerset | New Jersey | 34035 | 4767 | 438 |
248081 | 248081 | 2020-06-17 | Somerset | New Jersey | 34035 | 4780 | 438 |
251196 | 251196 | 2020-06-18 | Somerset | New Jersey | 34035 | 4786 | 439 |
254311 | 254311 | 2020-06-19 | Somerset | New Jersey | 34035 | 4796 | 438 |
257434 | 257434 | 2020-06-20 | Somerset | New Jersey | 34035 | 4806 | 438 |
260560 | 260560 | 2020-06-21 | Somerset | New Jersey | 34035 | 4813 | 438 |
263689 | 263689 | 2020-06-22 | Somerset | New Jersey | 34035 | 4819 | 440 |
266816 | 266816 | 2020-06-23 | Somerset | New Jersey | 34035 | 4818 | 441 |
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);