ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 34023 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277 | 1277 | 2020-03-11 | Middlesex | New Jersey | 34023 | 2 | 0 |
1507 | 1507 | 2020-03-12 | Middlesex | New Jersey | 34023 | 2 | 0 |
1799 | 1799 | 2020-03-13 | Middlesex | New Jersey | 34023 | 4 | 0 |
2146 | 2146 | 2020-03-14 | Middlesex | New Jersey | 34023 | 8 | 0 |
2554 | 2554 | 2020-03-15 | Middlesex | New Jersey | 34023 | 9 | 0 |
3011 | 3011 | 2020-03-16 | Middlesex | New Jersey | 34023 | 15 | 0 |
3524 | 3524 | 2020-03-17 | Middlesex | New Jersey | 34023 | 20 | 0 |
4120 | 4120 | 2020-03-18 | Middlesex | New Jersey | 34023 | 40 | 0 |
4847 | 4847 | 2020-03-19 | Middlesex | New Jersey | 34023 | 64 | 0 |
5691 | 5691 | 2020-03-20 | Middlesex | New Jersey | 34023 | 76 | 0 |
6684 | 6684 | 2020-03-21 | Middlesex | New Jersey | 34023 | 116 | 0 |
7775 | 7775 | 2020-03-22 | Middlesex | New Jersey | 34023 | 147 | 1 |
8971 | 8971 | 2020-03-23 | Middlesex | New Jersey | 34023 | 210 | 1 |
10275 | 10275 | 2020-03-24 | Middlesex | New Jersey | 34023 | 277 | 1 |
11707 | 11707 | 2020-03-25 | Middlesex | New Jersey | 34023 | 316 | 2 |
13310 | 13310 | 2020-03-26 | Middlesex | New Jersey | 34023 | 505 | 5 |
15042 | 15042 | 2020-03-27 | Middlesex | New Jersey | 34023 | 640 | 9 |
16871 | 16871 | 2020-03-28 | Middlesex | New Jersey | 34023 | 808 | 14 |
18795 | 18795 | 2020-03-29 | Middlesex | New Jersey | 34023 | 938 | 14 |
20833 | 20833 | 2020-03-30 | Middlesex | New Jersey | 34023 | 1123 | 20 |
22956 | 22956 | 2020-03-31 | Middlesex | New Jersey | 34023 | 1277 | 24 |
25147 | 25147 | 2020-04-01 | Middlesex | New Jersey | 34023 | 1493 | 27 |
27407 | 27407 | 2020-04-02 | Middlesex | New Jersey | 34023 | 1766 | 48 |
29730 | 29730 | 2020-04-03 | Middlesex | New Jersey | 34023 | 2125 | 56 |
32115 | 32115 | 2020-04-04 | Middlesex | New Jersey | 34023 | 2578 | 76 |
34546 | 34546 | 2020-04-05 | Middlesex | New Jersey | 34023 | 2950 | 80 |
37016 | 37016 | 2020-04-06 | Middlesex | New Jersey | 34023 | 3263 | 87 |
39531 | 39531 | 2020-04-07 | Middlesex | New Jersey | 34023 | 3717 | 100 |
42088 | 42088 | 2020-04-08 | Middlesex | New Jersey | 34023 | 4156 | 139 |
44670 | 44670 | 2020-04-09 | Middlesex | New Jersey | 34023 | 4628 | 152 |
47282 | 47282 | 2020-04-10 | Middlesex | New Jersey | 34023 | 5060 | 168 |
49936 | 49936 | 2020-04-11 | Middlesex | New Jersey | 34023 | 5406 | 177 |
52609 | 52609 | 2020-04-12 | Middlesex | New Jersey | 34023 | 5693 | 193 |
55292 | 55292 | 2020-04-13 | Middlesex | New Jersey | 34023 | 5987 | 204 |
57992 | 57992 | 2020-04-14 | Middlesex | New Jersey | 34023 | 6313 | 216 |
60706 | 60706 | 2020-04-15 | Middlesex | New Jersey | 34023 | 6576 | 248 |
63432 | 63432 | 2020-04-16 | Middlesex | New Jersey | 34023 | 6994 | 278 |
66174 | 66174 | 2020-04-17 | Middlesex | New Jersey | 34023 | 7308 | 309 |
68930 | 68930 | 2020-04-18 | Middlesex | New Jersey | 34023 | 7624 | 313 |
71697 | 71697 | 2020-04-19 | Middlesex | New Jersey | 34023 | 8017 | 329 |
74472 | 74472 | 2020-04-20 | Middlesex | New Jersey | 34023 | 8346 | 345 |
77253 | 77253 | 2020-04-21 | Middlesex | New Jersey | 34023 | 8767 | 360 |
80042 | 80042 | 2020-04-22 | Middlesex | New Jersey | 34023 | 9047 | 369 |
82840 | 82840 | 2020-04-23 | Middlesex | New Jersey | 34023 | 9530 | 396 |
85644 | 85644 | 2020-04-24 | Middlesex | New Jersey | 34023 | 9789 | 413 |
88455 | 88455 | 2020-04-25 | Middlesex | New Jersey | 34023 | 10075 | 431 |
91270 | 91270 | 2020-04-26 | Middlesex | New Jersey | 34023 | 10642 | 442 |
94094 | 94094 | 2020-04-27 | Middlesex | New Jersey | 34023 | 10767 | 455 |
96930 | 96930 | 2020-04-28 | Middlesex | New Jersey | 34023 | 11102 | 515 |
99777 | 99777 | 2020-04-29 | Middlesex | New Jersey | 34023 | 11436 | 531 |
102630 | 102630 | 2020-04-30 | Middlesex | New Jersey | 34023 | 11715 | 571 |
105492 | 105492 | 2020-05-01 | Middlesex | New Jersey | 34023 | 11947 | 591 |
108358 | 108358 | 2020-05-02 | Middlesex | New Jersey | 34023 | 12213 | 618 |
111231 | 111231 | 2020-05-03 | Middlesex | New Jersey | 34023 | 12597 | 639 |
114112 | 114112 | 2020-05-04 | Middlesex | New Jersey | 34023 | 12768 | 642 |
116993 | 116993 | 2020-05-05 | Middlesex | New Jersey | 34023 | 13142 | 667 |
119954 | 119954 | 2020-05-06 | Middlesex | New Jersey | 34023 | 13254 | 706 |
122929 | 122929 | 2020-05-07 | Middlesex | New Jersey | 34023 | 13411 | 737 |
125912 | 125912 | 2020-05-08 | Middlesex | New Jersey | 34023 | 13617 | 748 |
128901 | 128901 | 2020-05-09 | Middlesex | New Jersey | 34023 | 13759 | 759 |
131890 | 131890 | 2020-05-10 | Middlesex | New Jersey | 34023 | 13937 | 793 |
134881 | 134881 | 2020-05-11 | Middlesex | New Jersey | 34023 | 14036 | 794 |
137871 | 137871 | 2020-05-12 | Middlesex | New Jersey | 34023 | 14121 | 801 |
140867 | 140867 | 2020-05-13 | Middlesex | New Jersey | 34023 | 14241 | 819 |
143862 | 143862 | 2020-05-14 | Middlesex | New Jersey | 34023 | 14332 | 841 |
146863 | 146863 | 2020-05-15 | Middlesex | New Jersey | 34023 | 14429 | 865 |
149870 | 149870 | 2020-05-16 | Middlesex | New Jersey | 34023 | 14514 | 872 |
152880 | 152880 | 2020-05-17 | Middlesex | New Jersey | 34023 | 14668 | 884 |
155896 | 155896 | 2020-05-18 | Middlesex | New Jersey | 34023 | 14752 | 888 |
158914 | 158914 | 2020-05-19 | Middlesex | New Jersey | 34023 | 14834 | 903 |
161940 | 161940 | 2020-05-20 | Middlesex | New Jersey | 34023 | 14954 | 913 |
164969 | 164969 | 2020-05-21 | Middlesex | New Jersey | 34023 | 15057 | 921 |
168005 | 168005 | 2020-05-22 | Middlesex | New Jersey | 34023 | 15165 | 935 |
171044 | 171044 | 2020-05-23 | Middlesex | New Jersey | 34023 | 15215 | 942 |
174086 | 174086 | 2020-05-24 | Middlesex | New Jersey | 34023 | 15351 | 955 |
177129 | 177129 | 2020-05-25 | Middlesex | New Jersey | 34023 | 15437 | 955 |
180173 | 180173 | 2020-05-26 | Middlesex | New Jersey | 34023 | 15499 | 959 |
183221 | 183221 | 2020-05-27 | Middlesex | New Jersey | 34023 | 15547 | 964 |
186278 | 186278 | 2020-05-28 | Middlesex | New Jersey | 34023 | 15633 | 968 |
189338 | 189338 | 2020-05-29 | Middlesex | New Jersey | 34023 | 15734 | 972 |
192402 | 192402 | 2020-05-30 | Middlesex | New Jersey | 34023 | 15824 | 989 |
195472 | 195472 | 2020-05-31 | Middlesex | New Jersey | 34023 | 15921 | 994 |
198545 | 198545 | 2020-06-01 | Middlesex | New Jersey | 34023 | 15977 | 996 |
201619 | 201619 | 2020-06-02 | Middlesex | New Jersey | 34023 | 16021 | 997 |
204696 | 204696 | 2020-06-03 | Middlesex | New Jersey | 34023 | 16066 | 1004 |
207777 | 207777 | 2020-06-04 | Middlesex | New Jersey | 34023 | 16072 | 1015 |
210859 | 210859 | 2020-06-05 | Middlesex | New Jersey | 34023 | 16137 | 1025 |
213943 | 213943 | 2020-06-06 | Middlesex | New Jersey | 34023 | 16203 | 1032 |
217032 | 217032 | 2020-06-07 | Middlesex | New Jersey | 34023 | 16198 | 1040 |
220124 | 220124 | 2020-06-08 | Middlesex | New Jersey | 34023 | 16227 | 1043 |
223219 | 223219 | 2020-06-09 | Middlesex | New Jersey | 34023 | 16251 | 1053 |
226319 | 226319 | 2020-06-10 | Middlesex | New Jersey | 34023 | 16288 | 1064 |
229423 | 229423 | 2020-06-11 | Middlesex | New Jersey | 34023 | 16327 | 1069 |
232528 | 232528 | 2020-06-12 | Middlesex | New Jersey | 34023 | 16353 | 1070 |
235633 | 235633 | 2020-06-13 | Middlesex | New Jersey | 34023 | 16385 | 1074 |
238740 | 238740 | 2020-06-14 | Middlesex | New Jersey | 34023 | 16430 | 1076 |
241850 | 241850 | 2020-06-15 | Middlesex | New Jersey | 34023 | 16458 | 1083 |
244962 | 244962 | 2020-06-16 | Middlesex | New Jersey | 34023 | 16474 | 1085 |
248075 | 248075 | 2020-06-17 | Middlesex | New Jersey | 34023 | 16513 | 1094 |
251190 | 251190 | 2020-06-18 | Middlesex | New Jersey | 34023 | 16547 | 1094 |
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);