participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,223 rows where station_code = "NZ003H" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5481169 | 5481169 | 20241104151113_rt9AB | NZ003H | 2024-11-06T14:09:35.280Z | 2024-11-08T14:17:53.277Z |
5481159 | 5481159 | 20241104150751_wuWpD | NZ003H | 2024-11-06T14:09:32.936Z | 2024-11-08T14:17:52.714Z |
5480936 | 5480936 | 20241104104520_4WDOk | NZ003H | 2024-11-06T14:07:48.636Z | 2024-11-08T14:17:27.143Z |
5480439 | 5480439 | 20241105125922_G9fp2 | NZ003H | 2024-11-06T14:05:38.580Z | 2024-11-08T14:15:26.574Z |
5480416 | 5480416 | 20241105124754_q5yXu | NZ003H | 2024-11-06T14:05:29.440Z | 2024-11-08T14:15:25.360Z |
5480412 | 5480412 | 20241105124704_tFZ7J | NZ003H | 2024-11-06T14:05:28.577Z | 2024-11-08T14:15:25.247Z |
5480399 | 5480399 | 20241105124624_t8XhF | NZ003H | 2024-11-06T14:05:26.204Z | 2024-11-08T14:15:24.604Z |
5480177 | 5480177 | 20241105115655_gip3a | NZ003H | 2024-11-06T14:04:45.330Z | 2024-11-08T14:15:18.184Z |
5479949 | 5479949 | 20241105110714_wby84 | NZ003H | 2024-11-06T14:04:02.266Z | 2024-11-08T14:15:10.289Z |
5479709 | 5479709 | 20241105102408_jaxlg | NZ003H | 2024-11-06T14:03:08.448Z | 2024-11-08T14:15:01.418Z |
5479634 | 5479634 | 20241105100748_welMY | NZ003H | 2024-11-06T14:02:56.680Z | 2024-11-08T14:14:59.253Z |
5479220 | 5479220 | 20241105083357_lrIwb | NZ003H | 2024-11-06T14:01:32.128Z | 2024-11-08T14:14:46.488Z |
5479170 | 5479170 | 20241105082115_rtFJJ | NZ003H | 2024-11-06T14:01:17.862Z | 2024-11-08T14:14:43.696Z |
5479093 | 5479093 | 20241105080226_pkHQz | NZ003H | 2024-11-06T14:00:59.011Z | 2024-11-08T14:14:41.902Z |
5474150 | 5474150 | 20241103161045_LqN85 | NZ003H | 2024-11-05T14:10:13.064Z | 2024-11-08T14:19:21.827Z |
5474135 | 5474135 | 20241103160229_H918M | NZ003H | 2024-11-05T14:10:10.607Z | 2024-11-08T14:19:21.458Z |
5474099 | 5474099 | 20241103155212_2WnMB | NZ003H | 2024-11-05T14:10:08.308Z | 2024-11-08T14:19:20.990Z |
5473971 | 5473971 | 20241103153102_GSduG | NZ003H | 2024-11-05T14:09:57.040Z | 2024-11-08T14:19:19.518Z |
5473876 | 5473876 | 20241103151433_hSsBo | NZ003H | 2024-11-05T14:09:50.190Z | 2024-11-08T14:19:19.158Z |
5473856 | 5473856 | 20241103151224_2KC3b | NZ003H | 2024-11-05T14:09:49.034Z | 2024-11-08T14:19:18.994Z |
5473805 | 5473805 | 20241103150600_1Y2Ti | NZ003H | 2024-11-05T14:09:45.415Z | 2024-11-08T14:19:18.788Z |
5473775 | 5473775 | 20241103150134_M1Msm | NZ003H | 2024-11-05T14:09:43.305Z | 2024-11-08T14:19:18.723Z |
5473741 | 5473741 | 20241103145711_QreSf | NZ003H | 2024-11-05T14:09:39.921Z | 2024-11-08T14:19:18.672Z |
5473583 | 5473583 | 20241103143554_fdP6n | NZ003H | 2024-11-05T14:09:09.280Z | 2024-11-08T14:19:17.842Z |
5473539 | 5473539 | 20241103143006_sm2FL | NZ003H | 2024-11-05T14:09:04.724Z | 2024-11-08T14:19:17.440Z |
5473515 | 5473515 | 20241103142752_l7rGQ | NZ003H | 2024-11-05T14:09:03.672Z | 2024-11-08T14:19:17.370Z |
5473511 | 5473511 | 20241103142750_srWhU | NZ003H | 2024-11-05T14:09:03.146Z | 2024-11-08T14:19:17.180Z |
5473427 | 5473427 | 20241103141501_dTWXR | NZ003H | 2024-11-05T14:08:55.362Z | 2024-11-08T14:19:16.702Z |
5473335 | 5473335 | 20241103140404_51JcP | NZ003H | 2024-11-05T14:08:48.635Z | 2024-11-08T14:19:15.750Z |
5473315 | 5473315 | 20241103135956_08IkS | NZ003H | 2024-11-05T14:08:47.127Z | 2024-11-08T14:19:15.513Z |
5473298 | 5473298 | 20241103135524_GGDuu | NZ003H | 2024-11-05T14:08:45.959Z | 2024-11-08T14:19:14.849Z |
5473185 | 5473185 | 20241103133740_dH0Sc | NZ003H | 2024-11-05T14:08:30.096Z | 2024-11-08T14:19:13.886Z |
5473157 | 5473157 | 20241103133550_dlw5p | NZ003H | 2024-11-05T14:08:25.597Z | 2024-11-08T14:19:13.823Z |
5473152 | 5473152 | 20241103133518_wp8bl | NZ003H | 2024-11-05T14:08:24.787Z | 2024-11-08T14:19:13.818Z |
5473132 | 5473132 | 20241103133231_IIZGK | NZ003H | 2024-11-05T14:08:21.226Z | 2024-11-08T14:19:13.728Z |
5473108 | 5473108 | 20241103132849_gK4ih | NZ003H | 2024-11-05T14:08:17.430Z | 2024-11-08T14:19:13.539Z |
5472947 | 5472947 | 20241103130331_TYLyo | NZ003H | 2024-11-05T14:07:54.226Z | 2024-11-08T14:19:12.195Z |
5472918 | 5472918 | 20241103130001_yFnQv | NZ003H | 2024-11-05T14:07:52.138Z | 2024-11-08T14:19:11.407Z |
5472908 | 5472908 | 20241103125850_EE8da | NZ003H | 2024-11-05T14:07:51.138Z | 2024-11-08T14:19:11.373Z |
5472854 | 5472854 | 20241103125316_baRAy | NZ003H | 2024-11-05T14:07:48.085Z | 2024-11-08T14:19:10.941Z |
5472823 | 5472823 | 20241103124914_vhxWY | NZ003H | 2024-11-05T14:07:45.691Z | 2024-11-08T14:19:10.871Z |
5472803 | 5472803 | 20241103124459_dlH50 | NZ003H | 2024-11-05T14:07:43.804Z | 2024-11-08T14:19:10.509Z |
5472770 | 5472770 | 20241103123559_Bldvl | NZ003H | 2024-11-05T14:07:41.137Z | 2024-11-08T14:19:10.291Z |
5472718 | 5472718 | 20241103122757_byq22 | NZ003H | 2024-11-05T14:07:36.174Z | 2024-11-08T14:19:09.952Z |
5472714 | 5472714 | 20241103122737_95H7b | NZ003H | 2024-11-05T14:07:35.504Z | 2024-11-08T14:19:09.945Z |
5472618 | 5472618 | 20241104155838_pqxHy | NZ003H | 2024-11-05T14:06:20.232Z | 2024-11-08T14:17:57.344Z |
5472604 | 5472604 | 20241104155418_9zxrG | NZ003H | 2024-11-05T14:06:19.418Z | 2024-11-08T14:17:57.176Z |
5472600 | 5472600 | 20241104155327_RqwIm | NZ003H | 2024-11-05T14:06:19.185Z | 2024-11-08T14:17:57.105Z |
5472593 | 5472593 | 20241104155053_PqR2M | NZ003H | 2024-11-05T14:06:18.678Z | 2024-11-08T14:17:56.919Z |
5472536 | 5472536 | 20241104153555_GSGY1 | NZ003H | 2024-11-05T14:06:06.914Z | 2024-11-08T14:17:55.655Z |
5472527 | 5472527 | 20241104153345_FrLse | NZ003H | 2024-11-05T14:06:04.424Z | 2024-11-08T14:17:54.953Z |
5472512 | 5472512 | 20241104153000_ck9X3 | NZ003H | 2024-11-05T14:06:01.395Z | 2024-11-08T14:17:54.502Z |
5472470 | 5472470 | 20241104151323_XhyOi | NZ003H | 2024-11-05T14:05:52.350Z | 2024-11-08T14:17:53.446Z |
5472444 | 5472444 | 20241104150659_hR3A1 | NZ003H | 2024-11-05T14:05:50.237Z | 2024-11-08T14:17:52.576Z |
5472409 | 5472409 | 20241104150002_pg4kE | NZ003H | 2024-11-05T14:05:47.159Z | 2024-11-08T14:17:51.406Z |
5472391 | 5472391 | 20241104145704_5n6oX | NZ003H | 2024-11-05T14:05:44.556Z | 2024-11-08T14:17:51.138Z |
5472259 | 5472259 | 20241104141548_IjvRD | NZ003H | 2024-11-05T14:05:32.116Z | 2024-11-08T14:17:48.523Z |
5472254 | 5472254 | 20241104141440_rRuWf | NZ003H | 2024-11-05T14:05:31.387Z | 2024-11-08T14:17:48.402Z |
5472234 | 5472234 | 20241104141148_6YQJh | NZ003H | 2024-11-05T14:05:28.971Z | 2024-11-08T14:17:48.265Z |
5472182 | 5472182 | 20241104135956_rbeHG | NZ003H | 2024-11-05T14:05:25.044Z | 2024-11-08T14:17:47.788Z |
5472169 | 5472169 | 20241104135822_AL339 | NZ003H | 2024-11-05T14:05:21.824Z | 2024-11-08T14:17:47.684Z |
5472140 | 5472140 | 20241104135205_BfU5N | NZ003H | 2024-11-05T14:05:14.410Z | 2024-11-08T14:17:47.175Z |
5472127 | 5472127 | 20241104134945_PgOwB | NZ003H | 2024-11-05T14:05:12.805Z | 2024-11-08T14:17:47.081Z |
5472116 | 5472116 | 20241104134300_MOFX1 | NZ003H | 2024-11-05T14:05:11.425Z | 2024-11-08T14:17:46.949Z |
5472077 | 5472077 | 20241104133454_2O4G2 | NZ003H | 2024-11-05T14:05:04.658Z | 2024-11-08T14:17:46.603Z |
5472042 | 5472042 | 20241104132917_o81RR | NZ003H | 2024-11-05T14:05:01.142Z | 2024-11-08T14:17:46.066Z |
5472012 | 5472012 | 20241104132109_2FLOI | NZ003H | 2024-11-05T14:04:58.131Z | 2024-11-08T14:17:45.328Z |
5472005 | 5472005 | 20241104132104_eN3np | NZ003H | 2024-11-05T14:04:57.765Z | 2024-11-08T14:17:45.319Z |
5471984 | 5471984 | 20241104131210_Ahffb | NZ003H | 2024-11-05T14:04:54.427Z | 2024-11-08T14:17:44.630Z |
5471926 | 5471926 | 20241104130205_dIDaK | NZ003H | 2024-11-05T14:04:48.827Z | 2024-11-08T14:17:44.011Z |
5471787 | 5471787 | 20241104123950_B3JEB | NZ003H | 2024-11-05T14:04:36.282Z | 2024-11-08T14:17:41.628Z |
5471775 | 5471775 | 20241104123530_0tGdk | NZ003H | 2024-11-05T14:04:34.732Z | 2024-11-08T14:17:40.896Z |
5471763 | 5471763 | 20241104123420_u3IjM | NZ003H | 2024-11-05T14:04:34.041Z | 2024-11-08T14:17:40.744Z |
5471758 | 5471758 | 20241104123414_W04ZE | NZ003H | 2024-11-05T14:04:33.650Z | 2024-11-08T14:17:40.731Z |
5471704 | 5471704 | 20241104122818_cDzbT | NZ003H | 2024-11-05T14:04:26.354Z | 2024-11-08T14:17:39.589Z |
5471653 | 5471653 | 20241104121754_Kjc7k | NZ003H | 2024-11-05T14:04:11.944Z | 2024-11-08T14:17:38.506Z |
5471589 | 5471589 | 20241104120609_K2COV | NZ003H | 2024-11-05T14:03:59.269Z | 2024-11-08T14:17:36.428Z |
5471580 | 5471580 | 20241104120537_fGORq | NZ003H | 2024-11-05T14:03:58.580Z | 2024-11-08T14:17:36.275Z |
5471558 | 5471558 | 20241104120326_zt66S | NZ003H | 2024-11-05T14:03:56.129Z | 2024-11-08T14:17:35.842Z |
5471548 | 5471548 | 20241104120233_Ejb5f | NZ003H | 2024-11-05T14:03:55.249Z | 2024-11-08T14:17:35.712Z |
5471518 | 5471518 | 20241104115822_ilcyz | NZ003H | 2024-11-05T14:03:51.960Z | 2024-11-08T14:17:34.844Z |
5471497 | 5471497 | 20241104115327_eVlav | NZ003H | 2024-11-05T14:03:49.720Z | 2024-11-08T14:17:34.560Z |
5471485 | 5471485 | 20241104115150_fMYCI | NZ003H | 2024-11-05T14:03:48.992Z | 2024-11-08T14:17:34.230Z |
5471452 | 5471452 | 20241104114645_QGtF1 | NZ003H | 2024-11-05T14:03:45.271Z | 2024-11-08T14:17:33.816Z |
5471433 | 5471433 | 20241104114415_2FkTZ | NZ003H | 2024-11-05T14:03:43.625Z | 2024-11-08T14:17:33.521Z |
5471381 | 5471381 | 20241104113452_u2YM0 | NZ003H | 2024-11-05T14:03:34.287Z | 2024-11-08T14:17:32.919Z |
5471370 | 5471370 | 20241104113409_26qpb | NZ003H | 2024-11-05T14:03:33.134Z | 2024-11-08T14:17:32.809Z |
5471341 | 5471341 | 20241104112756_Rzfvh | NZ003H | 2024-11-05T14:03:29.157Z | 2024-11-08T14:17:32.508Z |
5471320 | 5471320 | 20241104112649_soGUq | NZ003H | 2024-11-05T14:03:24.485Z | 2024-11-08T14:17:32.156Z |
5471308 | 5471308 | 20241104112622_2t9no | NZ003H | 2024-11-05T14:03:23.084Z | 2024-11-08T14:17:32.080Z |
5471108 | 5471108 | 20241104104703_t2IQt | NZ003H | 2024-11-05T14:02:54.094Z | 2024-11-08T14:17:27.561Z |
5471092 | 5471092 | 20241104104524_dCbKT | NZ003H | 2024-11-05T14:02:51.728Z | 2024-11-08T14:17:27.297Z |
5470952 | 5470952 | 20241104101217_DvDfw | NZ003H | 2024-11-05T14:02:21.283Z | 2024-11-08T14:17:22.937Z |
5470876 | 5470876 | 20241104095653_ydOCG | NZ003H | 2024-11-05T14:02:09.424Z | 2024-11-08T14:17:20.787Z |
5470816 | 5470816 | 20241104095223_Oouam | NZ003H | 2024-11-05T14:01:55.799Z | 2024-11-08T14:17:20.046Z |
5470733 | 5470733 | 20241104093433_FTD1U | NZ003H | 2024-11-05T14:01:41.557Z | 2024-11-08T14:17:18.663Z |
5470656 | 5470656 | 20241104091350_WRJks | NZ003H | 2024-11-05T14:01:28.272Z | 2024-11-08T14:17:16.514Z |
5470649 | 5470649 | 20241104091334_lHgdW | NZ003H | 2024-11-05T14:01:27.823Z | 2024-11-08T14:17:16.482Z |
5470586 | 5470586 | 20241104085547_t4B3I | NZ003H | 2024-11-05T14:01:09.824Z | 2024-11-08T14:17:14.717Z |
5470447 | 5470447 | 20241104080702_2ya1c | NZ003H | 2024-11-05T14:00:41.349Z | 2024-11-08T14:17:12.509Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);