ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Rockland" and state = "New York" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
629 | 629 | 2020-03-06 | Rockland | New York | 36087 | 2 | 0 |
717 | 717 | 2020-03-07 | Rockland | New York | 36087 | 2 | 0 |
822 | 822 | 2020-03-08 | Rockland | New York | 36087 | 2 | 0 |
949 | 949 | 2020-03-09 | Rockland | New York | 36087 | 4 | 0 |
1100 | 1100 | 2020-03-10 | Rockland | New York | 36087 | 6 | 0 |
1287 | 1287 | 2020-03-11 | Rockland | New York | 36087 | 6 | 0 |
1524 | 1524 | 2020-03-12 | Rockland | New York | 36087 | 7 | 0 |
1817 | 1817 | 2020-03-13 | Rockland | New York | 36087 | 9 | 0 |
2166 | 2166 | 2020-03-14 | Rockland | New York | 36087 | 12 | 1 |
2578 | 2578 | 2020-03-15 | Rockland | New York | 36087 | 13 | 1 |
3039 | 3039 | 2020-03-16 | Rockland | New York | 36087 | 16 | 1 |
3556 | 3556 | 2020-03-17 | Rockland | New York | 36087 | 22 | 2 |
4157 | 4157 | 2020-03-18 | Rockland | New York | 36087 | 30 | 2 |
4886 | 4886 | 2020-03-19 | Rockland | New York | 36087 | 53 | 2 |
5737 | 5737 | 2020-03-20 | Rockland | New York | 36087 | 101 | 3 |
6731 | 6731 | 2020-03-21 | Rockland | New York | 36087 | 262 | 3 |
7826 | 7826 | 2020-03-22 | Rockland | New York | 36087 | 455 | 3 |
9026 | 9026 | 2020-03-23 | Rockland | New York | 36087 | 592 | 5 |
10334 | 10334 | 2020-03-24 | Rockland | New York | 36087 | 671 | 5 |
11770 | 11770 | 2020-03-25 | Rockland | New York | 36087 | 1069 | 7 |
13373 | 13373 | 2020-03-26 | Rockland | New York | 36087 | 1197 | 7 |
15107 | 15107 | 2020-03-27 | Rockland | New York | 36087 | 1457 | 8 |
16937 | 16937 | 2020-03-28 | Rockland | New York | 36087 | 1896 | 8 |
18862 | 18862 | 2020-03-29 | Rockland | New York | 36087 | 2209 | 8 |
20901 | 20901 | 2020-03-30 | Rockland | New York | 36087 | 2511 | 8 |
23024 | 23024 | 2020-03-31 | Rockland | New York | 36087 | 2863 | 8 |
25218 | 25218 | 2020-04-01 | Rockland | New York | 36087 | 3321 | 29 |
27478 | 27478 | 2020-04-02 | Rockland | New York | 36087 | 3751 | 42 |
29802 | 29802 | 2020-04-03 | Rockland | New York | 36087 | 4289 | 42 |
32188 | 32188 | 2020-04-04 | Rockland | New York | 36087 | 4872 | 69 |
34619 | 34619 | 2020-04-05 | Rockland | New York | 36087 | 5362 | 69 |
37089 | 37089 | 2020-04-06 | Rockland | New York | 36087 | 5703 | 76 |
39604 | 39604 | 2020-04-07 | Rockland | New York | 36087 | 5990 | 119 |
42161 | 42161 | 2020-04-08 | Rockland | New York | 36087 | 6413 | 98 |
44744 | 44744 | 2020-04-09 | Rockland | New York | 36087 | 6665 | 117 |
47357 | 47357 | 2020-04-10 | Rockland | New York | 36087 | 7122 | 135 |
50012 | 50012 | 2020-04-11 | Rockland | New York | 36087 | 7477 | 153 |
52685 | 52685 | 2020-04-12 | Rockland | New York | 36087 | 7721 | 166 |
55368 | 55368 | 2020-04-13 | Rockland | New York | 36087 | 7965 | 182 |
58068 | 58068 | 2020-04-14 | Rockland | New York | 36087 | 8335 | 192 |
60782 | 60782 | 2020-04-15 | Rockland | New York | 36087 | 8474 | 212 |
63508 | 63508 | 2020-04-16 | Rockland | New York | 36087 | 8752 | 234 |
66250 | 66250 | 2020-04-17 | Rockland | New York | 36087 | 8987 | 234 |
69007 | 69007 | 2020-04-18 | Rockland | New York | 36087 | 9171 | 234 |
71774 | 71774 | 2020-04-19 | Rockland | New York | 36087 | 9364 | 276 |
74549 | 74549 | 2020-04-20 | Rockland | New York | 36087 | 9457 | 286 |
77330 | 77330 | 2020-04-21 | Rockland | New York | 36087 | 9568 | 297 |
80119 | 80119 | 2020-04-22 | Rockland | New York | 36087 | 9699 | 309 |
82918 | 82918 | 2020-04-23 | Rockland | New York | 36087 | 9828 | 322 |
85722 | 85722 | 2020-04-24 | Rockland | New York | 36087 | 10091 | 334 |
88534 | 88534 | 2020-04-25 | Rockland | New York | 36087 | 11091 | 340 |
91349 | 91349 | 2020-04-26 | Rockland | New York | 36087 | 11256 | 349 |
94174 | 94174 | 2020-04-27 | Rockland | New York | 36087 | 11366 | 355 |
97010 | 97010 | 2020-04-28 | Rockland | New York | 36087 | 11453 | 359 |
99857 | 99857 | 2020-04-29 | Rockland | New York | 36087 | 11586 | 364 |
102710 | 102710 | 2020-04-30 | Rockland | New York | 36087 | 11708 | 370 |
105572 | 105572 | 2020-05-01 | Rockland | New York | 36087 | 11812 | 371 |
108439 | 108439 | 2020-05-02 | Rockland | New York | 36087 | 11945 | 376 |
111312 | 111312 | 2020-05-03 | Rockland | New York | 36087 | 12025 | 378 |
114193 | 114193 | 2020-05-04 | Rockland | New York | 36087 | 12095 | 380 |
117073 | 117073 | 2020-05-05 | Rockland | New York | 36087 | 12144 | 383 |
120034 | 120034 | 2020-05-06 | Rockland | New York | 36087 | 12204 | 400 |
123009 | 123009 | 2020-05-07 | Rockland | New York | 36087 | 12280 | 404 |
125992 | 125992 | 2020-05-08 | Rockland | New York | 36087 | 12349 | 404 |
128981 | 128981 | 2020-05-09 | Rockland | New York | 36087 | 12400 | 410 |
131970 | 131970 | 2020-05-10 | Rockland | New York | 36087 | 12451 | 417 |
134961 | 134961 | 2020-05-11 | Rockland | New York | 36087 | 12484 | 421 |
137951 | 137951 | 2020-05-12 | Rockland | New York | 36087 | 12504 | 427 |
140947 | 140947 | 2020-05-13 | Rockland | New York | 36087 | 12543 | 429 |
143942 | 143942 | 2020-05-14 | Rockland | New York | 36087 | 12596 | 431 |
146943 | 146943 | 2020-05-15 | Rockland | New York | 36087 | 12637 | 434 |
149950 | 149950 | 2020-05-16 | Rockland | New York | 36087 | 12688 | 439 |
152960 | 152960 | 2020-05-17 | Rockland | New York | 36087 | 12758 | 440 |
155977 | 155977 | 2020-05-18 | Rockland | New York | 36087 | 12777 | 442 |
158995 | 158995 | 2020-05-19 | Rockland | New York | 36087 | 12798 | 445 |
162022 | 162022 | 2020-05-20 | Rockland | New York | 36087 | 12831 | 447 |
165051 | 165051 | 2020-05-21 | Rockland | New York | 36087 | 12877 | 448 |
168086 | 168086 | 2020-05-22 | Rockland | New York | 36087 | 12905 | 450 |
171125 | 171125 | 2020-05-23 | Rockland | New York | 36087 | 12934 | 452 |
174167 | 174167 | 2020-05-24 | Rockland | New York | 36087 | 12963 | 454 |
177211 | 177211 | 2020-05-25 | Rockland | New York | 36087 | 12996 | 454 |
180254 | 180254 | 2020-05-26 | Rockland | New York | 36087 | 13019 | 455 |
183302 | 183302 | 2020-05-27 | Rockland | New York | 36087 | 13047 | 455 |
186359 | 186359 | 2020-05-28 | Rockland | New York | 36087 | 13076 | 457 |
189419 | 189419 | 2020-05-29 | Rockland | New York | 36087 | 13100 | 457 |
192483 | 192483 | 2020-05-30 | Rockland | New York | 36087 | 13128 | 457 |
195553 | 195553 | 2020-05-31 | Rockland | New York | 36087 | 13151 | 458 |
198626 | 198626 | 2020-06-01 | Rockland | New York | 36087 | 13185 | 458 |
201700 | 201700 | 2020-06-02 | Rockland | New York | 36087 | 13223 | 463 |
204777 | 204777 | 2020-06-03 | Rockland | New York | 36087 | 13259 | 464 |
207858 | 207858 | 2020-06-04 | Rockland | New York | 36087 | 13280 | 464 |
210940 | 210940 | 2020-06-05 | Rockland | New York | 36087 | 13297 | 465 |
214024 | 214024 | 2020-06-06 | Rockland | New York | 36087 | 13315 | 465 |
217114 | 217114 | 2020-06-07 | Rockland | New York | 36087 | 13325 | 465 |
220206 | 220206 | 2020-06-08 | Rockland | New York | 36087 | 13340 | 465 |
223300 | 223300 | 2020-06-09 | Rockland | New York | 36087 | 13353 | 465 |
226400 | 226400 | 2020-06-10 | Rockland | New York | 36087 | 13372 | 466 |
229504 | 229504 | 2020-06-11 | Rockland | New York | 36087 | 13385 | 466 |
232609 | 232609 | 2020-06-12 | Rockland | New York | 36087 | 13396 | 466 |
235714 | 235714 | 2020-06-13 | Rockland | New York | 36087 | 13411 | 466 |
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);