ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Mecklenburg" and state = "North Carolina" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1533 | 1533 | 2020-03-12 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
1827 | 1827 | 2020-03-13 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
2181 | 2181 | 2020-03-14 | Mecklenburg | North Carolina | 37119 | 2 | 0 |
2593 | 2593 | 2020-03-15 | Mecklenburg | North Carolina | 37119 | 4 | 0 |
3055 | 3055 | 2020-03-16 | Mecklenburg | North Carolina | 37119 | 4 | 0 |
3575 | 3575 | 2020-03-17 | Mecklenburg | North Carolina | 37119 | 7 | 0 |
4182 | 4182 | 2020-03-18 | Mecklenburg | North Carolina | 37119 | 11 | 0 |
4913 | 4913 | 2020-03-19 | Mecklenburg | North Carolina | 37119 | 13 | 0 |
5767 | 5767 | 2020-03-20 | Mecklenburg | North Carolina | 37119 | 28 | 0 |
6764 | 6764 | 2020-03-21 | Mecklenburg | North Carolina | 37119 | 41 | 0 |
7866 | 7866 | 2020-03-22 | Mecklenburg | North Carolina | 37119 | 66 | 0 |
9067 | 9067 | 2020-03-23 | Mecklenburg | North Carolina | 37119 | 80 | 0 |
10375 | 10375 | 2020-03-24 | Mecklenburg | North Carolina | 37119 | 104 | 0 |
11819 | 11819 | 2020-03-25 | Mecklenburg | North Carolina | 37119 | 170 | 0 |
13423 | 13423 | 2020-03-26 | Mecklenburg | North Carolina | 37119 | 181 | 0 |
15158 | 15158 | 2020-03-27 | Mecklenburg | North Carolina | 37119 | 218 | 0 |
16990 | 16990 | 2020-03-28 | Mecklenburg | North Carolina | 37119 | 299 | 0 |
18921 | 18921 | 2020-03-29 | Mecklenburg | North Carolina | 37119 | 336 | 1 |
20961 | 20961 | 2020-03-30 | Mecklenburg | North Carolina | 37119 | 382 | 1 |
23088 | 23088 | 2020-03-31 | Mecklenburg | North Carolina | 37119 | 420 | 1 |
25282 | 25282 | 2020-04-01 | Mecklenburg | North Carolina | 37119 | 444 | 2 |
27546 | 27546 | 2020-04-02 | Mecklenburg | North Carolina | 37119 | 495 | 2 |
29873 | 29873 | 2020-04-03 | Mecklenburg | North Carolina | 37119 | 564 | 2 |
32260 | 32260 | 2020-04-04 | Mecklenburg | North Carolina | 37119 | 635 | 4 |
34691 | 34691 | 2020-04-05 | Mecklenburg | North Carolina | 37119 | 664 | 6 |
37160 | 37160 | 2020-04-06 | Mecklenburg | North Carolina | 37119 | 733 | 7 |
39675 | 39675 | 2020-04-07 | Mecklenburg | North Carolina | 37119 | 810 | 8 |
42232 | 42232 | 2020-04-08 | Mecklenburg | North Carolina | 37119 | 830 | 10 |
44816 | 44816 | 2020-04-09 | Mecklenburg | North Carolina | 37119 | 861 | 10 |
47429 | 47429 | 2020-04-10 | Mecklenburg | North Carolina | 37119 | 906 | 10 |
50084 | 50084 | 2020-04-11 | Mecklenburg | North Carolina | 37119 | 935 | 12 |
52757 | 52757 | 2020-04-12 | Mecklenburg | North Carolina | 37119 | 954 | 12 |
55441 | 55441 | 2020-04-13 | Mecklenburg | North Carolina | 37119 | 970 | 12 |
58141 | 58141 | 2020-04-14 | Mecklenburg | North Carolina | 37119 | 993 | 15 |
60855 | 60855 | 2020-04-15 | Mecklenburg | North Carolina | 37119 | 1015 | 19 |
63581 | 63581 | 2020-04-16 | Mecklenburg | North Carolina | 37119 | 1084 | 19 |
66324 | 66324 | 2020-04-17 | Mecklenburg | North Carolina | 37119 | 1136 | 21 |
69081 | 69081 | 2020-04-18 | Mecklenburg | North Carolina | 37119 | 1153 | 24 |
71847 | 71847 | 2020-04-19 | Mecklenburg | North Carolina | 37119 | 1178 | 29 |
74622 | 74622 | 2020-04-20 | Mecklenburg | North Carolina | 37119 | 1210 | 29 |
77403 | 77403 | 2020-04-21 | Mecklenburg | North Carolina | 37119 | 1245 | 32 |
80192 | 80192 | 2020-04-22 | Mecklenburg | North Carolina | 37119 | 1284 | 33 |
82991 | 82991 | 2020-04-23 | Mecklenburg | North Carolina | 37119 | 1362 | 33 |
85795 | 85795 | 2020-04-24 | Mecklenburg | North Carolina | 37119 | 1407 | 35 |
88608 | 88608 | 2020-04-25 | Mecklenburg | North Carolina | 37119 | 1450 | 41 |
91423 | 91423 | 2020-04-26 | Mecklenburg | North Carolina | 37119 | 1482 | 41 |
94249 | 94249 | 2020-04-27 | Mecklenburg | North Carolina | 37119 | 1492 | 43 |
97086 | 97086 | 2020-04-28 | Mecklenburg | North Carolina | 37119 | 1519 | 43 |
99934 | 99934 | 2020-04-29 | Mecklenburg | North Carolina | 37119 | 1567 | 44 |
102787 | 102787 | 2020-04-30 | Mecklenburg | North Carolina | 37119 | 1627 | 49 |
105649 | 105649 | 2020-05-01 | Mecklenburg | North Carolina | 37119 | 1651 | 49 |
108516 | 108516 | 2020-05-02 | Mecklenburg | North Carolina | 37119 | 1699 | 50 |
111389 | 111389 | 2020-05-03 | Mecklenburg | North Carolina | 37119 | 1724 | 51 |
114270 | 114270 | 2020-05-04 | Mecklenburg | North Carolina | 37119 | 1734 | 54 |
117150 | 117150 | 2020-05-05 | Mecklenburg | North Carolina | 37119 | 1758 | 55 |
120111 | 120111 | 2020-05-06 | Mecklenburg | North Carolina | 37119 | 1850 | 58 |
123086 | 123086 | 2020-05-07 | Mecklenburg | North Carolina | 37119 | 1922 | 58 |
126069 | 126069 | 2020-05-08 | Mecklenburg | North Carolina | 37119 | 1989 | 58 |
129058 | 129058 | 2020-05-09 | Mecklenburg | North Carolina | 37119 | 2043 | 61 |
132047 | 132047 | 2020-05-10 | Mecklenburg | North Carolina | 37119 | 2074 | 63 |
135038 | 135038 | 2020-05-11 | Mecklenburg | North Carolina | 37119 | 2134 | 63 |
138028 | 138028 | 2020-05-12 | Mecklenburg | North Carolina | 37119 | 2148 | 63 |
141024 | 141024 | 2020-05-13 | Mecklenburg | North Carolina | 37119 | 2204 | 63 |
144019 | 144019 | 2020-05-14 | Mecklenburg | North Carolina | 37119 | 2320 | 63 |
147020 | 147020 | 2020-05-15 | Mecklenburg | North Carolina | 37119 | 2385 | 63 |
150027 | 150027 | 2020-05-16 | Mecklenburg | North Carolina | 37119 | 2504 | 63 |
153037 | 153037 | 2020-05-17 | Mecklenburg | North Carolina | 37119 | 2591 | 63 |
156054 | 156054 | 2020-05-18 | Mecklenburg | North Carolina | 37119 | 2652 | 63 |
159073 | 159073 | 2020-05-19 | Mecklenburg | North Carolina | 37119 | 2717 | 68 |
162100 | 162100 | 2020-05-20 | Mecklenburg | North Carolina | 37119 | 2780 | 69 |
165129 | 165129 | 2020-05-21 | Mecklenburg | North Carolina | 37119 | 2894 | 70 |
168164 | 168164 | 2020-05-22 | Mecklenburg | North Carolina | 37119 | 2954 | 72 |
171203 | 171203 | 2020-05-23 | Mecklenburg | North Carolina | 37119 | 3142 | 73 |
174245 | 174245 | 2020-05-24 | Mecklenburg | North Carolina | 37119 | 3231 | 73 |
177289 | 177289 | 2020-05-25 | Mecklenburg | North Carolina | 37119 | 3380 | 74 |
180332 | 180332 | 2020-05-26 | Mecklenburg | North Carolina | 37119 | 3403 | 74 |
183380 | 183380 | 2020-05-27 | Mecklenburg | North Carolina | 37119 | 3478 | 80 |
186437 | 186437 | 2020-05-28 | Mecklenburg | North Carolina | 37119 | 3605 | 85 |
189497 | 189497 | 2020-05-29 | Mecklenburg | North Carolina | 37119 | 3837 | 88 |
192561 | 192561 | 2020-05-30 | Mecklenburg | North Carolina | 37119 | 4028 | 88 |
195631 | 195631 | 2020-05-31 | Mecklenburg | North Carolina | 37119 | 4250 | 89 |
198704 | 198704 | 2020-06-01 | Mecklenburg | North Carolina | 37119 | 4412 | 92 |
201778 | 201778 | 2020-06-02 | Mecklenburg | North Carolina | 37119 | 4519 | 95 |
204855 | 204855 | 2020-06-03 | Mecklenburg | North Carolina | 37119 | 4670 | 96 |
207936 | 207936 | 2020-06-04 | Mecklenburg | North Carolina | 37119 | 4842 | 101 |
211018 | 211018 | 2020-06-05 | Mecklenburg | North Carolina | 37119 | 5057 | 102 |
214102 | 214102 | 2020-06-06 | Mecklenburg | North Carolina | 37119 | 5358 | 106 |
217192 | 217192 | 2020-06-07 | Mecklenburg | North Carolina | 37119 | 5509 | 109 |
220284 | 220284 | 2020-06-08 | Mecklenburg | North Carolina | 37119 | 5682 | 110 |
223378 | 223378 | 2020-06-09 | Mecklenburg | North Carolina | 37119 | 5744 | 115 |
226478 | 226478 | 2020-06-10 | Mecklenburg | North Carolina | 37119 | 5861 | 119 |
229582 | 229582 | 2020-06-11 | Mecklenburg | North Carolina | 37119 | 6155 | 123 |
232687 | 232687 | 2020-06-12 | Mecklenburg | North Carolina | 37119 | 6538 | 123 |
235792 | 235792 | 2020-06-13 | Mecklenburg | North Carolina | 37119 | 6862 | 125 |
238900 | 238900 | 2020-06-14 | Mecklenburg | North Carolina | 37119 | 7131 | 126 |
242009 | 242009 | 2020-06-15 | Mecklenburg | North Carolina | 37119 | 7321 | 131 |
245121 | 245121 | 2020-06-16 | Mecklenburg | North Carolina | 37119 | 7468 | 134 |
248234 | 248234 | 2020-06-17 | Mecklenburg | North Carolina | 37119 | 7563 | 134 |
251349 | 251349 | 2020-06-18 | Mecklenburg | North Carolina | 37119 | 7804 | 136 |
254464 | 254464 | 2020-06-19 | Mecklenburg | North Carolina | 37119 | 8166 | 137 |
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);