ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 35001 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1281 | 1281 | 2020-03-11 | Bernalillo | New Mexico | 35001 | 1 | 0 |
1513 | 1513 | 2020-03-12 | Bernalillo | New Mexico | 35001 | 2 | 0 |
1806 | 1806 | 2020-03-13 | Bernalillo | New Mexico | 35001 | 5 | 0 |
2153 | 2153 | 2020-03-14 | Bernalillo | New Mexico | 35001 | 6 | 0 |
2561 | 2561 | 2020-03-15 | Bernalillo | New Mexico | 35001 | 10 | 0 |
3019 | 3019 | 2020-03-16 | Bernalillo | New Mexico | 35001 | 14 | 0 |
3533 | 3533 | 2020-03-17 | Bernalillo | New Mexico | 35001 | 14 | 0 |
4129 | 4129 | 2020-03-18 | Bernalillo | New Mexico | 35001 | 17 | 0 |
4857 | 4857 | 2020-03-19 | Bernalillo | New Mexico | 35001 | 20 | 0 |
5701 | 5701 | 2020-03-20 | Bernalillo | New Mexico | 35001 | 23 | 0 |
6694 | 6694 | 2020-03-21 | Bernalillo | New Mexico | 35001 | 32 | 0 |
7786 | 7786 | 2020-03-22 | Bernalillo | New Mexico | 35001 | 34 | 0 |
8982 | 8982 | 2020-03-23 | Bernalillo | New Mexico | 35001 | 38 | 0 |
10286 | 10286 | 2020-03-24 | Bernalillo | New Mexico | 35001 | 43 | 0 |
11718 | 11718 | 2020-03-25 | Bernalillo | New Mexico | 35001 | 48 | 0 |
13321 | 13321 | 2020-03-26 | Bernalillo | New Mexico | 35001 | 55 | 0 |
15053 | 15053 | 2020-03-27 | Bernalillo | New Mexico | 35001 | 82 | 0 |
16882 | 16882 | 2020-03-28 | Bernalillo | New Mexico | 35001 | 93 | 1 |
18806 | 18806 | 2020-03-29 | Bernalillo | New Mexico | 35001 | 101 | 1 |
20844 | 20844 | 2020-03-30 | Bernalillo | New Mexico | 35001 | 117 | 3 |
22967 | 22967 | 2020-03-31 | Bernalillo | New Mexico | 35001 | 129 | 4 |
25158 | 25158 | 2020-04-01 | Bernalillo | New Mexico | 35001 | 148 | 4 |
27418 | 27418 | 2020-04-02 | Bernalillo | New Mexico | 35001 | 163 | 5 |
29741 | 29741 | 2020-04-03 | Bernalillo | New Mexico | 35001 | 202 | 7 |
32126 | 32126 | 2020-04-04 | Bernalillo | New Mexico | 35001 | 225 | 7 |
34557 | 34557 | 2020-04-05 | Bernalillo | New Mexico | 35001 | 246 | 7 |
37027 | 37027 | 2020-04-06 | Bernalillo | New Mexico | 35001 | 262 | 7 |
39542 | 39542 | 2020-04-07 | Bernalillo | New Mexico | 35001 | 307 | 8 |
42099 | 42099 | 2020-04-08 | Bernalillo | New Mexico | 35001 | 325 | 11 |
44681 | 44681 | 2020-04-09 | Bernalillo | New Mexico | 35001 | 369 | 12 |
47293 | 47293 | 2020-04-10 | Bernalillo | New Mexico | 35001 | 407 | 13 |
49947 | 49947 | 2020-04-11 | Bernalillo | New Mexico | 35001 | 422 | 13 |
52620 | 52620 | 2020-04-12 | Bernalillo | New Mexico | 35001 | 440 | 16 |
55303 | 55303 | 2020-04-13 | Bernalillo | New Mexico | 35001 | 455 | 16 |
58003 | 58003 | 2020-04-14 | Bernalillo | New Mexico | 35001 | 464 | 17 |
60717 | 60717 | 2020-04-15 | Bernalillo | New Mexico | 35001 | 477 | 17 |
63443 | 63443 | 2020-04-16 | Bernalillo | New Mexico | 35001 | 491 | 18 |
66185 | 66185 | 2020-04-17 | Bernalillo | New Mexico | 35001 | 514 | 22 |
68941 | 68941 | 2020-04-18 | Bernalillo | New Mexico | 35001 | 527 | 23 |
71708 | 71708 | 2020-04-19 | Bernalillo | New Mexico | 35001 | 542 | 24 |
74483 | 74483 | 2020-04-20 | Bernalillo | New Mexico | 35001 | 566 | 24 |
77264 | 77264 | 2020-04-21 | Bernalillo | New Mexico | 35001 | 585 | 29 |
80053 | 80053 | 2020-04-22 | Bernalillo | New Mexico | 35001 | 600 | 29 |
82851 | 82851 | 2020-04-23 | Bernalillo | New Mexico | 35001 | 631 | 31 |
85655 | 85655 | 2020-04-24 | Bernalillo | New Mexico | 35001 | 651 | 33 |
88466 | 88466 | 2020-04-25 | Bernalillo | New Mexico | 35001 | 670 | 33 |
91281 | 91281 | 2020-04-26 | Bernalillo | New Mexico | 35001 | 688 | 33 |
94105 | 94105 | 2020-04-27 | Bernalillo | New Mexico | 35001 | 694 | 33 |
96941 | 96941 | 2020-04-28 | Bernalillo | New Mexico | 35001 | 738 | 35 |
99788 | 99788 | 2020-04-29 | Bernalillo | New Mexico | 35001 | 765 | 35 |
102641 | 102641 | 2020-04-30 | Bernalillo | New Mexico | 35001 | 811 | 35 |
105503 | 105503 | 2020-05-01 | Bernalillo | New Mexico | 35001 | 830 | 36 |
108369 | 108369 | 2020-05-02 | Bernalillo | New Mexico | 35001 | 883 | 38 |
111242 | 111242 | 2020-05-03 | Bernalillo | New Mexico | 35001 | 920 | 40 |
114123 | 114123 | 2020-05-04 | Bernalillo | New Mexico | 35001 | 944 | 40 |
117004 | 117004 | 2020-05-05 | Bernalillo | New Mexico | 35001 | 963 | 42 |
119965 | 119965 | 2020-05-06 | Bernalillo | New Mexico | 35001 | 981 | 44 |
122940 | 122940 | 2020-05-07 | Bernalillo | New Mexico | 35001 | 1012 | 44 |
125923 | 125923 | 2020-05-08 | Bernalillo | New Mexico | 35001 | 1030 | 45 |
128912 | 128912 | 2020-05-09 | Bernalillo | New Mexico | 35001 | 1050 | 46 |
131901 | 131901 | 2020-05-10 | Bernalillo | New Mexico | 35001 | 1073 | 46 |
134892 | 134892 | 2020-05-11 | Bernalillo | New Mexico | 35001 | 1086 | 48 |
137882 | 137882 | 2020-05-12 | Bernalillo | New Mexico | 35001 | 1111 | 50 |
140878 | 140878 | 2020-05-13 | Bernalillo | New Mexico | 35001 | 1124 | 53 |
143873 | 143873 | 2020-05-14 | Bernalillo | New Mexico | 35001 | 1149 | 54 |
146874 | 146874 | 2020-05-15 | Bernalillo | New Mexico | 35001 | 1180 | 56 |
149881 | 149881 | 2020-05-16 | Bernalillo | New Mexico | 35001 | 1194 | 56 |
152891 | 152891 | 2020-05-17 | Bernalillo | New Mexico | 35001 | 1210 | 57 |
155907 | 155907 | 2020-05-18 | Bernalillo | New Mexico | 35001 | 1218 | 59 |
158925 | 158925 | 2020-05-19 | Bernalillo | New Mexico | 35001 | 1225 | 59 |
161951 | 161951 | 2020-05-20 | Bernalillo | New Mexico | 35001 | 1254 | 59 |
164980 | 164980 | 2020-05-21 | Bernalillo | New Mexico | 35001 | 1273 | 63 |
168016 | 168016 | 2020-05-22 | Bernalillo | New Mexico | 35001 | 1313 | 66 |
171055 | 171055 | 2020-05-23 | Bernalillo | New Mexico | 35001 | 1326 | 68 |
174097 | 174097 | 2020-05-24 | Bernalillo | New Mexico | 35001 | 1337 | 68 |
177140 | 177140 | 2020-05-25 | Bernalillo | New Mexico | 35001 | 1347 | 68 |
180184 | 180184 | 2020-05-26 | Bernalillo | New Mexico | 35001 | 1362 | 68 |
183232 | 183232 | 2020-05-27 | Bernalillo | New Mexico | 35001 | 1383 | 69 |
186289 | 186289 | 2020-05-28 | Bernalillo | New Mexico | 35001 | 1434 | 70 |
189349 | 189349 | 2020-05-29 | Bernalillo | New Mexico | 35001 | 1445 | 71 |
192413 | 192413 | 2020-05-30 | Bernalillo | New Mexico | 35001 | 1464 | 71 |
195483 | 195483 | 2020-05-31 | Bernalillo | New Mexico | 35001 | 1476 | 71 |
198556 | 198556 | 2020-06-01 | Bernalillo | New Mexico | 35001 | 1486 | 71 |
201630 | 201630 | 2020-06-02 | Bernalillo | New Mexico | 35001 | 1499 | 72 |
204707 | 204707 | 2020-06-03 | Bernalillo | New Mexico | 35001 | 1524 | 72 |
207788 | 207788 | 2020-06-04 | Bernalillo | New Mexico | 35001 | 1543 | 73 |
210870 | 210870 | 2020-06-05 | Bernalillo | New Mexico | 35001 | 1559 | 74 |
213954 | 213954 | 2020-06-06 | Bernalillo | New Mexico | 35001 | 1575 | 74 |
217043 | 217043 | 2020-06-07 | Bernalillo | New Mexico | 35001 | 1592 | 75 |
220135 | 220135 | 2020-06-08 | Bernalillo | New Mexico | 35001 | 1600 | 75 |
223230 | 223230 | 2020-06-09 | Bernalillo | New Mexico | 35001 | 1612 | 76 |
226330 | 226330 | 2020-06-10 | Bernalillo | New Mexico | 35001 | 1623 | 77 |
229434 | 229434 | 2020-06-11 | Bernalillo | New Mexico | 35001 | 1652 | 77 |
232539 | 232539 | 2020-06-12 | Bernalillo | New Mexico | 35001 | 1669 | 77 |
235644 | 235644 | 2020-06-13 | Bernalillo | New Mexico | 35001 | 1682 | 78 |
238751 | 238751 | 2020-06-14 | Bernalillo | New Mexico | 35001 | 1693 | 80 |
241861 | 241861 | 2020-06-15 | Bernalillo | New Mexico | 35001 | 1705 | 80 |
244973 | 244973 | 2020-06-16 | Bernalillo | New Mexico | 35001 | 1733 | 80 |
248086 | 248086 | 2020-06-17 | Bernalillo | New Mexico | 35001 | 1752 | 81 |
251201 | 251201 | 2020-06-18 | Bernalillo | New Mexico | 35001 | 1763 | 82 |
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);