johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "Canada" and province_or_state = "New Brunswick" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462560 | 2462560 | 2021-09-14 | Canada | New Brunswick | 3066 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-15 03:22:37 | New Brunswick, Canada | |||
1385399 | 1385399 | 2021-09-13 | Canada | New Brunswick | 3031 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-14 04:21:41 | New Brunswick, Canada | |||
1884768 | 1884768 | 2021-09-12 | Canada | New Brunswick | 2909 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-13 04:21:15 | New Brunswick, Canada | |||
3805671 | 3805671 | 2021-09-11 | Canada | New Brunswick | 2909 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-12 04:21:13 | New Brunswick, Canada | |||
3448611 | 3448611 | 2021-09-10 | Canada | New Brunswick | 2909 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-11 04:21:30 | New Brunswick, Canada | |||
1262557 | 1262557 | 2021-09-09 | Canada | New Brunswick | 2885 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-10 04:21:20 | New Brunswick, Canada | |||
2278927 | 2278927 | 2021-09-08 | Canada | New Brunswick | 2868 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-09 04:21:27 | New Brunswick, Canada | |||
641706 | 641706 | 2021-09-07 | Canada | New Brunswick | 2852 | 47 | 0 | 46.5653 | -66.4619 | 2021-09-08 04:21:31 | New Brunswick, Canada | |||
3193769 | 3193769 | 2021-09-06 | Canada | New Brunswick | 2798 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-07 04:21:35 | New Brunswick, Canada | |||
3280637 | 3280637 | 2021-09-05 | Canada | New Brunswick | 2798 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-06 04:21:22 | New Brunswick, Canada | |||
249051 | 249051 | 2021-09-04 | Canada | New Brunswick | 2798 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-05 04:21:33 | New Brunswick, Canada | |||
3974332 | 3974332 | 2021-09-03 | Canada | New Brunswick | 2798 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-04 04:21:28 | New Brunswick, Canada | |||
177794 | 177794 | 2021-09-02 | Canada | New Brunswick | 2784 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-03 04:21:20 | New Brunswick, Canada | |||
66829 | 66829 | 2021-09-01 | Canada | New Brunswick | 2774 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-02 04:21:15 | New Brunswick, Canada | |||
2067671 | 2067671 | 2021-08-31 | Canada | New Brunswick | 2763 | 46 | 0 | 46.5653 | -66.4619 | 2021-09-01 04:21:38 | New Brunswick, Canada | |||
1775125 | 1775125 | 2021-08-30 | Canada | New Brunswick | 2760 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-31 04:21:46 | New Brunswick, Canada | |||
3891699 | 3891699 | 2021-08-29 | Canada | New Brunswick | 2721 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-30 04:21:23 | New Brunswick, Canada | |||
2792802 | 2792802 | 2021-08-28 | Canada | New Brunswick | 2721 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-29 04:21:14 | New Brunswick, Canada | |||
2922961 | 2922961 | 2021-08-27 | Canada | New Brunswick | 2721 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-28 04:21:28 | New Brunswick, Canada | |||
1595975 | 1595975 | 2021-08-26 | Canada | New Brunswick | 2705 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-27 04:21:37 | New Brunswick, Canada | |||
32184 | 32184 | 2021-08-25 | Canada | New Brunswick | 2697 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-26 04:21:28 | New Brunswick, Canada | |||
3105223 | 3105223 | 2021-08-24 | Canada | New Brunswick | 2687 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-25 04:21:41 | New Brunswick, Canada | |||
3165394 | 3165394 | 2021-08-23 | Canada | New Brunswick | 2672 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-24 04:21:19 | New Brunswick, Canada | |||
2175321 | 2175321 | 2021-08-22 | Canada | New Brunswick | 2614 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-23 04:21:27 | New Brunswick, Canada | |||
3555417 | 3555417 | 2021-08-21 | Canada | New Brunswick | 2614 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-22 04:21:29 | New Brunswick, Canada | |||
1853759 | 1853759 | 2021-08-20 | Canada | New Brunswick | 2614 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-21 04:21:38 | New Brunswick, Canada | |||
511466 | 511466 | 2021-08-19 | Canada | New Brunswick | 2582 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-20 04:21:33 | New Brunswick, Canada | |||
2517945 | 2517945 | 2021-08-18 | Canada | New Brunswick | 2559 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-19 04:21:15 | New Brunswick, Canada | |||
245037 | 245037 | 2021-08-17 | Canada | New Brunswick | 2543 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-18 04:21:35 | New Brunswick, Canada | |||
1604000 | 1604000 | 2021-08-16 | Canada | New Brunswick | 2530 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-17 04:21:49 | New Brunswick, Canada | |||
103094 | 103094 | 2021-08-15 | Canada | New Brunswick | 2490 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-16 04:21:31 | New Brunswick, Canada | |||
507452 | 507452 | 2021-08-14 | Canada | New Brunswick | 2490 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-15 04:21:41 | New Brunswick, Canada | |||
1483324 | 1483324 | 2021-08-13 | Canada | New Brunswick | 2490 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-14 04:21:25 | New Brunswick, Canada | |||
2899454 | 2899454 | 2021-08-12 | Canada | New Brunswick | 2471 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-13 04:21:24 | New Brunswick, Canada | |||
1342058 | 1342058 | 2021-08-11 | Canada | New Brunswick | 2460 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-12 04:21:25 | New Brunswick, Canada | |||
2351205 | 2351205 | 2021-08-10 | Canada | New Brunswick | 2447 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-11 04:21:58 | New Brunswick, Canada | |||
649734 | 649734 | 2021-08-09 | Canada | New Brunswick | 2439 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-10 04:21:27 | New Brunswick, Canada | |||
589396 | 589396 | 2021-08-08 | Canada | New Brunswick | 2434 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-09 04:21:24 | New Brunswick, Canada | |||
2203408 | 2203408 | 2021-08-07 | Canada | New Brunswick | 2414 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-08 04:21:33 | New Brunswick, Canada | |||
1117358 | 1117358 | 2021-08-06 | Canada | New Brunswick | 2414 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-07 04:21:30 | New Brunswick, Canada | |||
1956295 | 1956295 | 2021-08-05 | Canada | New Brunswick | 2409 | 46 | 0 | 46.5653 | -66.4619 | 2021-08-06 04:21:18 | New Brunswick, Canada | |||
331674 | 331674 | 2021-08-04 | Canada | New Brunswick | 2396 | 46 | 2308 | 42 | 46.5653 | -66.4619 | 2021-08-05 04:21:51 | New Brunswick, Canada | ||
3467945 | 3467945 | 2021-08-03 | Canada | New Brunswick | 2394 | 46 | 2303 | 45 | 46.5653 | -66.4619 | 2021-08-04 04:21:25 | New Brunswick, Canada | ||
3683219 | 3683219 | 2021-08-02 | Canada | New Brunswick | 2383 | 46 | 2299 | 38 | 46.5653 | -66.4619 | 2021-08-03 04:21:39 | New Brunswick, Canada | ||
3015118 | 3015118 | 2021-08-01 | Canada | New Brunswick | 2383 | 46 | 2299 | 38 | 46.5653 | -66.4619 | 2021-08-02 04:21:36 | New Brunswick, Canada | ||
3903741 | 3903741 | 2021-07-31 | Canada | New Brunswick | 2365 | 46 | 2299 | 20 | 46.5653 | -66.4619 | 2021-08-01 04:21:50 | New Brunswick, Canada | ||
3295946 | 3295946 | 2021-07-30 | Canada | New Brunswick | 2365 | 46 | 2299 | 20 | 46.5653 | -66.4619 | 2021-07-31 04:21:35 | New Brunswick, Canada | ||
3385157 | 3385157 | 2021-07-29 | Canada | New Brunswick | 2358 | 46 | 2299 | 13 | 46.5653 | -66.4619 | 2021-07-30 04:21:34 | New Brunswick, Canada | ||
408062 | 408062 | 2021-07-28 | Canada | New Brunswick | 2354 | 46 | 2299 | 9 | 46.5653 | -66.4619 | 2021-07-29 04:21:33 | New Brunswick, Canada | ||
1305923 | 1305923 | 2021-07-27 | Canada | New Brunswick | 2352 | 46 | 2298 | 8 | 46.5653 | -66.4619 | 2021-07-28 04:21:39 | New Brunswick, Canada | ||
3218066 | 3218066 | 2021-07-26 | Canada | New Brunswick | 2351 | 46 | 2298 | 7 | 46.5653 | -66.4619 | 2021-07-27 04:21:18 | New Brunswick, Canada | ||
1378275 | 1378275 | 2021-07-25 | Canada | New Brunswick | 2350 | 46 | 2297 | 7 | 46.5653 | -66.4619 | 2021-07-26 04:21:28 | New Brunswick, Canada | ||
1330015 | 1330015 | 2021-07-24 | Canada | New Brunswick | 2350 | 46 | 2293 | 11 | 46.5653 | -66.4619 | 2021-07-25 04:22:12 | New Brunswick, Canada | ||
3137319 | 3137319 | 2021-07-23 | Canada | New Brunswick | 2350 | 46 | 2293 | 11 | 46.5653 | -66.4619 | 2021-07-24 00:21:36 | New Brunswick, Canada | ||
3476079 | 3476079 | 2021-07-22 | Canada | New Brunswick | 2347 | 46 | 2292 | 9 | 46.5653 | -66.4619 | 2021-07-23 04:21:29 | New Brunswick, Canada | ||
3331298 | 3331298 | 2021-07-21 | Canada | New Brunswick | 2346 | 46 | 2292 | 8 | 46.5653 | -66.4619 | 2021-07-22 04:21:19 | New Brunswick, Canada | ||
2371279 | 2371279 | 2021-07-20 | Canada | New Brunswick | 2346 | 46 | 2292 | 8 | 46.5653 | -66.4619 | 2021-07-21 04:21:40 | New Brunswick, Canada | ||
483358 | 483358 | 2021-07-19 | Canada | New Brunswick | 2346 | 46 | 2291 | 9 | 46.5653 | -66.4619 | 2021-07-20 04:21:48 | New Brunswick, Canada | ||
2673581 | 2673581 | 2021-07-18 | Canada | New Brunswick | 2346 | 46 | 2290 | 10 | 46.5653 | -66.4619 | 2021-07-19 04:21:24 | New Brunswick, Canada | ||
3705893 | 3705893 | 2021-07-17 | Canada | New Brunswick | 2345 | 46 | 2290 | 9 | 46.5653 | -66.4619 | 2021-07-18 04:22:07 | New Brunswick, Canada | ||
2947124 | 2947124 | 2021-07-16 | Canada | New Brunswick | 2345 | 46 | 2290 | 9 | 46.5653 | -66.4619 | 2021-07-17 04:22:22 | New Brunswick, Canada | ||
295780 | 295780 | 2021-07-15 | Canada | New Brunswick | 2343 | 46 | 2288 | 9 | 46.5653 | -66.4619 | 2021-07-16 04:21:22 | New Brunswick, Canada | ||
3631725 | 3631725 | 2021-07-14 | Canada | New Brunswick | 2336 | 46 | 2287 | 3 | 46.5653 | -66.4619 | 2021-07-15 04:21:48 | New Brunswick, Canada | ||
578600 | 578600 | 2021-07-13 | Canada | New Brunswick | 2336 | 46 | 2285 | 5 | 46.5653 | -66.4619 | 2021-07-14 04:21:35 | New Brunswick, Canada | ||
3740849 | 3740849 | 2021-07-12 | Canada | New Brunswick | 2336 | 46 | 2284 | 6 | 46.5653 | -66.4619 | 2021-07-13 04:21:18 | New Brunswick, Canada | ||
3659362 | 3659362 | 2021-07-11 | Canada | New Brunswick | 2336 | 46 | 2283 | 7 | 46.5653 | -66.4619 | 2021-07-12 04:21:34 | New Brunswick, Canada | ||
625646 | 625646 | 2021-07-10 | Canada | New Brunswick | 2336 | 46 | 2283 | 7 | 46.5653 | -66.4619 | 2021-07-11 04:21:43 | New Brunswick, Canada | ||
829365 | 829365 | 2021-07-09 | Canada | New Brunswick | 2336 | 46 | 2282 | 8 | 46.5653 | -66.4619 | 2021-07-10 04:21:25 | New Brunswick, Canada | ||
778129 | 778129 | 2021-07-08 | Canada | New Brunswick | 2336 | 46 | 2280 | 10 | 46.5653 | -66.4619 | 2021-07-09 04:21:21 | New Brunswick, Canada | ||
1440351 | 1440351 | 2021-07-07 | Canada | New Brunswick | 2336 | 46 | 2279 | 11 | 46.5653 | -66.4619 | 2021-07-08 04:21:26 | New Brunswick, Canada | ||
2693456 | 2693456 | 2021-07-06 | Canada | New Brunswick | 2336 | 46 | 2274 | 16 | 46.5653 | -66.4619 | 2021-07-07 04:21:20 | New Brunswick, Canada | ||
1932205 | 1932205 | 2021-07-05 | Canada | New Brunswick | 2338 | 46 | 2273 | 19 | 46.5653 | -66.4619 | 2021-07-06 04:21:32 | New Brunswick, Canada | ||
1164936 | 1164936 | 2021-07-04 | Canada | New Brunswick | 2337 | 46 | 2269 | 22 | 46.5653 | -66.4619 | 2021-07-05 04:21:28 | New Brunswick, Canada | ||
1495370 | 1495370 | 2021-07-03 | Canada | New Brunswick | 2336 | 45 | 2268 | 23 | 46.5653 | -66.4619 | 2021-07-04 04:21:38 | New Brunswick, Canada | ||
2071685 | 2071685 | 2021-07-02 | Canada | New Brunswick | 2336 | 45 | 2265 | 26 | 46.5653 | -66.4619 | 2021-07-03 04:21:37 | New Brunswick, Canada | ||
2764701 | 2764701 | 2021-07-01 | Canada | New Brunswick | 2332 | 45 | 2262 | 25 | 46.5653 | -66.4619 | 2021-07-02 04:21:47 | New Brunswick, Canada | ||
1892909 | 1892909 | 2021-06-30 | Canada | New Brunswick | 2332 | 45 | 2262 | 25 | 46.5653 | -66.4619 | 2021-07-01 04:21:19 | New Brunswick, Canada | ||
400032 | 400032 | 2021-06-29 | Canada | New Brunswick | 2329 | 45 | 2258 | 26 | 46.5653 | -66.4619 | 2021-06-30 04:21:41 | New Brunswick, Canada | ||
3125275 | 3125275 | 2021-06-28 | Canada | New Brunswick | 2326 | 45 | 2254 | 27 | 46.5653 | -66.4619 | 2021-06-29 04:21:28 | New Brunswick, Canada | ||
2589770 | 2589770 | 2021-06-27 | Canada | New Brunswick | 2325 | 45 | 2254 | 26 | 46.5653 | -66.4619 | 2021-06-28 04:21:29 | New Brunswick, Canada | ||
3958274 | 3958274 | 2021-06-26 | Canada | New Brunswick | 2324 | 45 | 2245 | 34 | 46.5653 | -66.4619 | 2021-06-27 04:21:39 | New Brunswick, Canada | ||
1712093 | 1712093 | 2021-06-25 | Canada | New Brunswick | 2323 | 45 | 2239 | 39 | 46.5653 | -66.4619 | 2021-06-26 04:21:43 | New Brunswick, Canada | ||
2295218 | 2295218 | 2021-06-24 | Canada | New Brunswick | 2322 | 45 | 2236 | 41 | 46.5653 | -66.4619 | 2021-06-25 04:21:33 | New Brunswick, Canada | ||
2422658 | 2422658 | 2021-06-23 | Canada | New Brunswick | 2320 | 45 | 2231 | 44 | 46.5653 | -66.4619 | 2021-06-24 04:21:55 | New Brunswick, Canada | ||
562735 | 562735 | 2021-06-22 | Canada | New Brunswick | 2319 | 45 | 2224 | 50 | 46.5653 | -66.4619 | 2021-06-23 04:21:46 | New Brunswick, Canada | ||
3358437 | 3358437 | 2021-06-21 | Canada | New Brunswick | 2318 | 45 | 2218 | 55 | 46.5653 | -66.4619 | 2021-06-22 04:21:34 | New Brunswick, Canada | ||
2884136 | 2884136 | 2021-06-20 | Canada | New Brunswick | 2318 | 45 | 2216 | 57 | 46.5653 | -66.4619 | 2021-06-21 04:21:41 | New Brunswick, Canada | ||
107219 | 107219 | 2021-06-19 | Canada | New Brunswick | 2316 | 45 | 2215 | 56 | 46.5653 | -66.4619 | 2021-06-20 04:21:48 | New Brunswick, Canada | ||
1125362 | 1125362 | 2021-06-18 | Canada | New Brunswick | 2311 | 45 | 2211 | 55 | 46.5653 | -66.4619 | 2021-06-19 04:22:33 | New Brunswick, Canada | ||
2910940 | 2910940 | 2021-06-17 | Canada | New Brunswick | 2309 | 45 | 2202 | 62 | 46.5653 | -66.4619 | 2021-06-18 04:22:16 | New Brunswick, Canada | ||
3030058 | 3030058 | 2021-06-16 | Canada | New Brunswick | 2305 | 45 | 2201 | 59 | 46.5653 | -66.4619 | 2021-06-17 04:22:36 | New Brunswick, Canada | ||
2339164 | 2339164 | 2021-06-15 | Canada | New Brunswick | 2302 | 45 | 2171 | 86 | 46.5653 | -66.4619 | 2021-06-16 04:22:32 | New Brunswick, Canada | ||
1563860 | 1563860 | 2021-06-14 | Canada | New Brunswick | 2299 | 45 | 2163 | 91 | 46.5653 | -66.4619 | 2021-06-15 04:22:22 | New Brunswick, Canada | ||
3381143 | 3381143 | 2021-06-13 | Canada | New Brunswick | 2298 | 45 | 2155 | 98 | 46.5653 | -66.4619 | 2021-06-14 04:22:46 | New Brunswick, Canada | ||
1736277 | 1736277 | 2021-06-12 | Canada | New Brunswick | 2291 | 45 | 2152 | 94 | 46.5653 | -66.4619 | 2021-06-13 04:22:44 | New Brunswick, Canada | ||
3970318 | 3970318 | 2021-06-11 | Canada | New Brunswick | 2284 | 44 | 2142 | 98 | 46.5653 | -66.4619 | 2021-06-12 04:22:22 | New Brunswick, Canada | ||
2716740 | 2716740 | 2021-06-10 | Canada | New Brunswick | 2283 | 44 | 2137 | 102 | 46.5653 | -66.4619 | 2021-06-11 04:23:20 | New Brunswick, Canada | ||
522625 | 522625 | 2021-06-09 | Canada | New Brunswick | 2280 | 44 | 2130 | 106 | 46.5653 | -66.4619 | 2021-06-10 04:23:17 | New Brunswick, Canada | ||
3472065 | 3472065 | 2021-06-08 | Canada | New Brunswick | 2267 | 44 | 2123 | 100 | 46.5653 | -66.4619 | 2021-06-09 04:23:31 | New Brunswick, Canada | ||
3145349 | 3145349 | 2021-06-07 | Canada | New Brunswick | 2266 | 44 | 2110 | 112 | 46.5653 | -66.4619 | 2021-06-08 04:22:35 | New Brunswick, Canada |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);