participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,932 rows where station_code = "NZ001Q" 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 |
---|---|---|---|---|---|
5449302 | 5449302 | 20241031151752_wqN1W | NZ001Q | 2024-11-02T12:12:27.889Z | 2024-11-03T14:20:51.066Z |
5449290 | 5449290 | 20241031151711_zI31l | NZ001Q | 2024-11-02T12:12:26.616Z | 2024-11-03T14:20:50.917Z |
5449172 | 5449172 | 20241031150153_6rg4X | NZ001Q | 2024-11-02T12:12:12.769Z | 2024-11-03T14:20:49.317Z |
5448740 | 5448740 | 20241031141212_9gS30 | NZ001Q | 2024-11-02T12:11:23.105Z | 2024-11-03T14:20:41.863Z |
5448558 | 5448558 | 20241031134611_DEn2g | NZ001Q | 2024-11-02T12:11:05.712Z | 2024-11-03T14:20:39.560Z |
5448516 | 5448516 | 20241031134147_pu6mD | NZ001Q | 2024-11-02T12:10:59.125Z | 2024-11-03T14:20:39.063Z |
5448429 | 5448429 | 20241031133113_H0o8D | NZ001Q | 2024-11-02T12:10:45.501Z | 2024-11-03T14:20:37.676Z |
5448259 | 5448259 | 20241031130356_IGqyp | NZ001Q | 2024-11-02T12:10:25.663Z | 2024-11-03T14:20:34.906Z |
5437680 | 5437680 | 20241030153442_C3qct | NZ001Q | 2024-11-01T12:10:11.442Z | 2024-11-03T14:22:40.276Z |
5437399 | 5437399 | 20241030150320_xf2tb | NZ001Q | 2024-11-01T12:09:31.872Z | 2024-11-03T14:22:39.428Z |
5437338 | 5437338 | 20241030145707_rt3Ib | NZ001Q | 2024-11-01T12:09:25.978Z | 2024-11-03T14:22:39.217Z |
5436794 | 5436794 | 20241030134834_vAbAA | NZ001Q | 2024-11-01T12:08:21.756Z | 2024-11-03T14:22:37.734Z |
5435121 | 5435121 | 20241030105212_kN3bl | NZ001Q | 2024-11-01T12:04:20.969Z | 2024-11-03T14:22:30.434Z |
5426791 | 5426791 | 20241028135652_rBV46 | NZ001Q | 2024-10-31T12:12:28.465Z | 2024-11-03T14:24:45.041Z |
5422589 | 5422589 | 20241028131957_ILUxQ | NZ001Q | 2024-10-30T12:20:28.284Z | 2024-11-03T14:24:42.919Z |
5422540 | 5422540 | 20241028131254_H285K | NZ001Q | 2024-10-30T12:20:27.603Z | 2024-11-03T14:24:42.600Z |
5422410 | 5422410 | 20241028125953_wbzeD | NZ001Q | 2024-10-30T12:20:26.422Z | 2024-11-03T14:24:42.055Z |
5422327 | 5422327 | 20241028124941_Hb23r | NZ001Q | 2024-10-30T12:20:25.520Z | 2024-11-03T14:24:41.894Z |
5422248 | 5422248 | 20241028123712_UCgji | NZ001Q | 2024-10-30T12:20:24.472Z | 2024-11-03T14:24:41.418Z |
5422012 | 5422012 | 20241028120843_jtPx7 | NZ001Q | 2024-10-30T12:20:20.164Z | 2024-11-03T14:24:40.081Z |
5421882 | 5421882 | 20241028115537_QrlbK | NZ001Q | 2024-10-30T12:20:17.035Z | 2024-11-03T14:24:39.670Z |
5421779 | 5421779 | 20241028113649_Iu3ba | NZ001Q | 2024-10-30T12:20:14.836Z | 2024-11-03T14:24:39.222Z |
5416385 | 5416385 | 20241027154642_jGPSO | NZ001Q | 2024-10-30T12:11:31.821Z | 2024-11-03T14:25:42.151Z |
5414603 | 5414603 | 20241027115616_I4CDt | NZ001Q | 2024-10-30T12:07:51.362Z | 2024-11-03T14:25:36.646Z |
5414364 | 5414364 | 20241027113218_G28o2 | NZ001Q | 2024-10-30T12:07:17.162Z | 2024-11-03T14:25:36.131Z |
5413983 | 5413983 | 20241027105242_4666o | NZ001Q | 2024-10-30T12:06:24.271Z | 2024-11-03T14:25:35.243Z |
5413907 | 5413907 | 20241027104215_TKbKr | NZ001Q | 2024-10-30T12:06:08.674Z | 2024-11-03T14:25:34.923Z |
5413143 | 5413143 | 20241028085824_mfSpG | NZ001Q | 2024-10-30T12:02:04.551Z | 2024-11-03T14:24:32.329Z |
5411503 | 5411503 | 20241027084856_tH9YF | NZ001Q | 2024-10-29T12:18:57.131Z | 2024-11-03T14:25:30.341Z |
5346222 | 5346222 | 20241022113702_Ix2sg | NZ001Q | 2024-10-24T12:04:02.553Z | 2024-10-31T12:29:46.437Z |
5345954 | 5345954 | 20241022111239_eSIEO | NZ001Q | 2024-10-24T12:03:17.176Z | 2024-10-31T12:29:45.740Z |
5331393 | 5331393 | 20241021142917_NHtb8 | NZ001Q | 2024-10-22T12:08:59.735Z | 2024-10-30T12:26:39.368Z |
5329961 | 5329961 | 20241021111157_XAMLM | NZ001Q | 2024-10-22T12:05:41.974Z | 2024-10-30T12:26:35.909Z |
5329894 | 5329894 | 20241021110541_DJZOc | NZ001Q | 2024-10-22T12:05:34.061Z | 2024-10-30T12:26:35.751Z |
5324462 | 5324462 | 20241020100221_WWAJo | NZ001Q | 2024-10-21T12:02:54.450Z | 2024-10-29T12:26:28.907Z |
5324262 | 5324262 | 20241020090953_dkmmN | NZ001Q | 2024-10-21T12:02:11.853Z | 2024-10-29T12:26:28.414Z |
5324064 | 5324064 | 20241020083352_RguPG | NZ001Q | 2024-10-21T12:01:35.768Z | 2024-10-29T12:26:28.016Z |
5322522 | 5322522 | 20241019131830_ASFCZ | NZ001Q | 2024-10-20T12:02:18.396Z | 2024-10-28T12:26:40.925Z |
5322199 | 5322199 | 20241019095949_yGkoX | NZ001Q | 2024-10-20T12:01:21.689Z | 2024-10-28T12:26:40.062Z |
5322172 | 5322172 | 20241019094858_VfIKZ | NZ001Q | 2024-10-20T12:01:15.091Z | 2024-10-28T12:26:40.044Z |
5322151 | 5322151 | 20241019093842_wGO9h | NZ001Q | 2024-10-20T12:01:08.733Z | 2024-10-28T12:26:39.938Z |
5319550 | 5319550 | 20241018161243_lDBiJ | NZ001Q | 2024-10-19T12:02:32.945Z | 2024-10-27T12:28:48.634Z |
5319546 | 5319546 | 20241018160754_ccHHe | NZ001Q | 2024-10-19T12:02:32.723Z | 2024-10-27T12:28:48.632Z |
5319527 | 5319527 | 20241018152908_dT2H0 | NZ001Q | 2024-10-19T12:02:29.744Z | 2024-10-27T12:28:48.377Z |
5315431 | 5315431 | 20241015131152_TU2J9 | NZ001Q | 2024-10-17T12:04:41.374Z | 2024-10-24T12:27:52.877Z |
5314763 | 5314763 | 20241016153935_zTApX | NZ001Q | 2024-10-17T12:02:45.931Z | 2024-10-25T12:24:31.876Z |
5314658 | 5314658 | 20241016145318_4Bzz4 | NZ001Q | 2024-10-17T12:02:39.143Z | 2024-10-25T12:24:31.591Z |
5298043 | 5298043 | 20241012152042_k22FF | NZ001Q | 2024-10-14T12:09:48.904Z | 2024-10-21T12:23:24.370Z |
5297985 | 5297985 | 20241012150530_8dcyj | NZ001Q | 2024-10-14T12:09:37.085Z | 2024-10-21T12:23:24.141Z |
5297967 | 5297967 | 20241012150422_qqAMz | NZ001Q | 2024-10-14T12:09:33.333Z | 2024-10-21T12:23:24.077Z |
5297915 | 5297915 | 20241012145259_3fwY8 | NZ001Q | 2024-10-14T12:09:23.634Z | 2024-10-21T12:23:23.504Z |
5297880 | 5297880 | 20241012145043_i5POB | NZ001Q | 2024-10-14T12:09:18.001Z | 2024-10-21T12:23:23.381Z |
5297489 | 5297489 | 20241012133337_3unLC | NZ001Q | 2024-10-14T12:08:30.052Z | 2024-10-21T12:23:18.639Z |
5297431 | 5297431 | 20241012132157_oudKX | NZ001Q | 2024-10-14T12:08:20.704Z | 2024-10-21T12:23:18.273Z |
5297383 | 5297383 | 20241012130752_rCNJD | NZ001Q | 2024-10-14T12:08:15.827Z | 2024-10-21T12:23:17.841Z |
5297299 | 5297299 | 20241012123648_YABu8 | NZ001Q | 2024-10-14T12:08:06.360Z | 2024-10-21T12:23:16.595Z |
5297291 | 5297291 | 20241012123416_Y3vxP | NZ001Q | 2024-10-14T12:08:05.782Z | 2024-10-21T12:23:16.540Z |
5296745 | 5296745 | 20241012110214_4h9zn | NZ001Q | 2024-10-14T12:06:47.305Z | 2024-10-21T12:23:08.617Z |
5296466 | 5296466 | 20241012102513_vrq29 | NZ001Q | 2024-10-14T12:06:14.319Z | 2024-10-21T12:23:04.348Z |
5296243 | 5296243 | 20241012094656_GKewp | NZ001Q | 2024-10-14T12:05:35.400Z | 2024-10-21T12:23:02.143Z |
5296201 | 5296201 | 20241012093831_ThpOx | NZ001Q | 2024-10-14T12:05:30.559Z | 2024-10-21T12:23:00.600Z |
5290081 | 5290081 | 20241011163035_2mP2U | NZ001Q | 2024-10-13T12:11:54.926Z | 2024-10-20T12:24:12.674Z |
5289972 | 5289972 | 20241011162043_v0BEX | NZ001Q | 2024-10-13T12:11:43.732Z | 2024-10-20T12:24:12.199Z |
5289850 | 5289850 | 20241011161049_WXWr5 | NZ001Q | 2024-10-13T12:11:32.139Z | 2024-10-20T12:24:11.636Z |
5289796 | 5289796 | 20241011160510_9n3WH | NZ001Q | 2024-10-13T12:11:26.069Z | 2024-10-20T12:24:10.501Z |
5289656 | 5289656 | 20241011155311_XRsBi | NZ001Q | 2024-10-13T12:11:12.131Z | 2024-10-20T12:24:09.649Z |
5289110 | 5289110 | 20241011145912_4p77K | NZ001Q | 2024-10-13T12:10:24.803Z | 2024-10-20T12:24:04.683Z |
5289013 | 5289013 | 20241011145053_swFAR | NZ001Q | 2024-10-13T12:10:19.524Z | 2024-10-20T12:24:04.109Z |
5288874 | 5288874 | 20241011143733_Wooxn | NZ001Q | 2024-10-13T12:10:06.499Z | 2024-10-20T12:24:03.058Z |
5288656 | 5288656 | 20241011141558_AZNvq | NZ001Q | 2024-10-13T12:09:39.691Z | 2024-10-20T12:24:00.795Z |
5288504 | 5288504 | 20241011140428_ad9fk | NZ001Q | 2024-10-13T12:09:22.181Z | 2024-10-20T12:23:59.640Z |
5288364 | 5288364 | 20241011135045_Xk6M3 | NZ001Q | 2024-10-13T12:09:13.124Z | 2024-10-20T12:23:58.844Z |
5288342 | 5288342 | 20241011134746_O2TXJ | NZ001Q | 2024-10-13T12:09:11.682Z | 2024-10-20T12:23:58.738Z |
5288145 | 5288145 | 20241011130849_cfHs6 | NZ001Q | 2024-10-13T12:08:57.745Z | 2024-10-20T12:23:57.611Z |
5286718 | 5286718 | 20241012091747_Ead38 | NZ001Q | 2024-10-13T12:03:19.781Z | 2024-10-21T12:22:58.774Z |
5280235 | 5280235 | 20241010155137_3Lb9h | NZ001Q | 2024-10-12T12:12:07.397Z | 2024-10-19T12:27:23.133Z |
5279943 | 5279943 | 20241010153121_MHPSj | NZ001Q | 2024-10-12T12:11:36.433Z | 2024-10-19T12:27:21.502Z |
5279756 | 5279756 | 20241010151456_TTfB4 | NZ001Q | 2024-10-12T12:11:17.959Z | 2024-10-19T12:27:18.871Z |
5279207 | 5279207 | 20241010141447_Psfgl | NZ001Q | 2024-10-12T12:10:18.244Z | 2024-10-19T12:27:13.667Z |
5279150 | 5279150 | 20241010140515_lO2k9 | NZ001Q | 2024-10-12T12:10:13.981Z | 2024-10-19T12:27:13.255Z |
5278537 | 5278537 | 20241010124010_1FUUq | NZ001Q | 2024-10-12T12:09:09.735Z | 2024-10-19T12:27:07.703Z |
5277656 | 5277656 | 20241011083339_RJAGt | NZ001Q | 2024-10-12T12:03:57.192Z | 2024-10-20T12:23:30.588Z |
5277524 | 5277524 | 20241011080627_daEk7 | NZ001Q | 2024-10-12T12:03:39.382Z | 2024-10-20T12:23:29.095Z |
5271728 | 5271728 | 20241010123442_IsCrO | NZ001Q | 2024-10-11T12:07:29.061Z | 2024-10-19T12:27:07.474Z |
5271603 | 5271603 | 20241010121455_aM84o | NZ001Q | 2024-10-11T12:07:17.738Z | 2024-10-19T12:27:06.721Z |
5271268 | 5271268 | 20241010113527_Gu3HV | NZ001Q | 2024-10-11T12:06:28.827Z | 2024-10-19T12:27:04.387Z |
5270984 | 5270984 | 20241010105659_nfdje | NZ001Q | 2024-10-11T12:05:47.339Z | 2024-10-19T12:27:01.599Z |
5270830 | 5270830 | 20241010104002_vyf1F | NZ001Q | 2024-10-11T12:05:32.929Z | 2024-10-19T12:27:00.969Z |
5270386 | 5270386 | 20241010093453_ZxW8N | NZ001Q | 2024-10-11T12:04:19.200Z | 2024-10-19T12:26:59.113Z |
5259959 | 5259959 | 20241007151345_7mAIF | NZ001Q | 2024-10-09T12:11:37.309Z | 2024-10-16T12:21:10.019Z |
5259641 | 5259641 | 20241007142940_Ru0xS | NZ001Q | 2024-10-09T12:11:17.113Z | 2024-10-16T12:21:09.169Z |
5259621 | 5259621 | 20241007142543_Ov6MH | NZ001Q | 2024-10-09T12:11:16.059Z | 2024-10-16T12:21:09.141Z |
5259610 | 5259610 | 20241007142427_XYYPD | NZ001Q | 2024-10-09T12:11:15.302Z | 2024-10-16T12:21:09.127Z |
5259585 | 5259585 | 20241007142020_ga3B7 | NZ001Q | 2024-10-09T12:11:13.491Z | 2024-10-16T12:21:09.058Z |
5259561 | 5259561 | 20241007141725_XGIlL | NZ001Q | 2024-10-09T12:11:09.351Z | 2024-10-16T12:21:08.853Z |
5259539 | 5259539 | 20241007141534_X0blm | NZ001Q | 2024-10-09T12:11:03.269Z | 2024-10-16T12:21:08.809Z |
5259420 | 5259420 | 20241007135658_MS7p1 | NZ001Q | 2024-10-09T12:10:43.959Z | 2024-10-16T12:21:08.617Z |
5259077 | 5259077 | 20241007125837_XsJk3 | NZ001Q | 2024-10-09T12:10:19.978Z | 2024-10-16T12:21:08.209Z |
5259057 | 5259057 | 20241007125325_Ehe6O | NZ001Q | 2024-10-09T12:10:18.604Z | 2024-10-16T12:21:08.199Z |
5258972 | 5258972 | 20241007123659_uGZ7r | NZ001Q | 2024-10-09T12:10:14.057Z | 2024-10-16T12:21:08.145Z |
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);