participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,009 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 |
---|---|---|---|---|---|
5603404 | 5603404 | 20241125152114_r2ARU | NZ001Q | 2024-11-26T14:11:04.002Z | 2024-11-26T14:11:04.002Z |
5603358 | 5603358 | 20241125151006_TtFJV | NZ001Q | 2024-11-26T14:10:59.540Z | 2024-11-26T14:10:59.540Z |
5603302 | 5603302 | 20241125145746_Wy5br | NZ001Q | 2024-11-26T14:10:54.019Z | 2024-11-26T14:10:54.019Z |
5603281 | 5603281 | 20241125145040_HVfjV | NZ001Q | 2024-11-26T14:10:49.837Z | 2024-11-26T14:10:49.837Z |
5603159 | 5603159 | 20241125142718_ZlGBU | NZ001Q | 2024-11-26T14:10:25.212Z | 2024-11-26T14:10:25.212Z |
5603151 | 5603151 | 20241125142553_4nbpo | NZ001Q | 2024-11-26T14:10:23.543Z | 2024-11-26T14:10:23.543Z |
5603133 | 5603133 | 20241125142021_220R5 | NZ001Q | 2024-11-26T14:10:20.599Z | 2024-11-26T14:10:20.599Z |
5603115 | 5603115 | 20241125141522_bGFdz | NZ001Q | 2024-11-26T14:10:18.750Z | 2024-11-26T14:10:18.750Z |
5603005 | 5603005 | 20241125134745_u0mJY | NZ001Q | 2024-11-26T14:10:06.731Z | 2024-11-26T14:10:06.731Z |
5603000 | 5603000 | 20241125134744_RJbwx | NZ001Q | 2024-11-26T14:10:06.532Z | 2024-11-26T14:10:06.532Z |
5602823 | 5602823 | 20241125130733_7mKv2 | NZ001Q | 2024-11-26T14:09:37.059Z | 2024-11-26T14:09:37.059Z |
5602762 | 5602762 | 20241125125511_wyHrL | NZ001Q | 2024-11-26T14:09:30.879Z | 2024-11-26T14:09:30.879Z |
5602621 | 5602621 | 20241125122704_S729z | NZ001Q | 2024-11-26T14:09:03.069Z | 2024-11-26T14:09:03.069Z |
5602599 | 5602599 | 20241125122247_HZGZF | NZ001Q | 2024-11-26T14:08:55.898Z | 2024-11-26T14:08:55.898Z |
5602528 | 5602528 | 20241125121010_zB91A | NZ001Q | 2024-11-26T14:08:44.634Z | 2024-11-26T14:08:44.634Z |
5602474 | 5602474 | 20241125120107_FWzI5 | NZ001Q | 2024-11-26T14:08:39.617Z | 2024-11-26T14:08:39.617Z |
5602448 | 5602448 | 20241125115524_k4I4u | NZ001Q | 2024-11-26T14:08:36.080Z | 2024-11-26T14:08:36.080Z |
5602356 | 5602356 | 20241125114233_Itdhg | NZ001Q | 2024-11-26T14:08:27.071Z | 2024-11-26T14:08:27.071Z |
5602019 | 5602019 | 20241125104452_r7Sdb | NZ001Q | 2024-11-26T14:07:30.013Z | 2024-11-26T14:07:30.013Z |
5597440 | 5597440 | 20241124152419_rg2lL | NZ001Q | 2024-11-25T14:11:29.237Z | 2024-11-26T14:18:44.598Z |
5597386 | 5597386 | 20241124152042_owJBH | NZ001Q | 2024-11-25T14:11:26.218Z | 2024-11-26T14:18:44.588Z |
5597344 | 5597344 | 20241124151856_chnw8 | NZ001Q | 2024-11-25T14:11:24.123Z | 2024-11-26T14:18:44.582Z |
5597212 | 5597212 | 20241124151021_K1yRI | NZ001Q | 2024-11-25T14:11:15.988Z | 2024-11-26T14:18:44.561Z |
5597177 | 5597177 | 20241124150846_Pk6Y7 | NZ001Q | 2024-11-25T14:11:14.456Z | 2024-11-26T14:18:44.557Z |
5596687 | 5596687 | 20241124141445_L4Xui | NZ001Q | 2024-11-25T14:10:27.490Z | 2024-11-26T14:18:44.465Z |
5596542 | 5596542 | 20241124140218_XE6Y5 | NZ001Q | 2024-11-25T14:10:17.619Z | 2024-11-26T14:18:44.443Z |
5596311 | 5596311 | 20241124133551_f7LQl | NZ001Q | 2024-11-25T14:09:48.437Z | 2024-11-26T14:18:44.409Z |
5595506 | 5595506 | 20241124122639_z9YEd | NZ001Q | 2024-11-25T14:08:23.902Z | 2024-11-26T14:18:44.279Z |
5595293 | 5595293 | 20241124120314_Uykib | NZ001Q | 2024-11-25T14:07:54.943Z | 2024-11-26T14:18:44.244Z |
5595158 | 5595158 | 20241124114903_Q32pU | NZ001Q | 2024-11-25T14:07:40.763Z | 2024-11-26T14:18:44.217Z |
5594979 | 5594979 | 20241124112733_LFpbC | NZ001Q | 2024-11-25T14:07:03.949Z | 2024-11-26T14:18:44.184Z |
5593881 | 5593881 | 20241124090525_al8pt | NZ001Q | 2024-11-25T14:04:00.120Z | 2024-11-26T14:18:43.968Z |
5584030 | 5584030 | 20241117153241_fDt63 | NZ001Q | 2024-11-23T14:25:21.452Z | 2024-11-26T14:28:38.048Z |
5583678 | 5583678 | 20241118085536_eN5Bl | NZ001Q | 2024-11-23T14:24:51.826Z | 2024-11-26T14:27:59.452Z |
5576834 | 5576834 | 20241122135121_oDfmD | NZ001Q | 2024-11-23T14:10:36.559Z | 2024-11-26T14:22:53.103Z |
5576829 | 5576829 | 20241122134845_oQaHD | NZ001Q | 2024-11-23T14:10:35.922Z | 2024-11-23T14:10:35.922Z |
5576798 | 5576798 | 20241122132836_80ll7 | NZ001Q | 2024-11-23T14:10:28.258Z | 2024-11-26T14:22:52.552Z |
5576790 | 5576790 | 20241122132621_MKg2I | NZ001Q | 2024-11-23T14:10:26.470Z | 2024-11-26T14:22:52.474Z |
5576739 | 5576739 | 20241122130421_ytYfn | NZ001Q | 2024-11-23T14:10:17.391Z | 2024-11-26T14:22:52.020Z |
5576729 | 5576729 | 20241122130330_lIoFC | NZ001Q | 2024-11-23T14:10:16.620Z | 2024-11-26T14:22:51.955Z |
5575787 | 5575787 | 20241122101852_xFA3E | NZ001Q | 2024-11-23T14:07:36.263Z | 2024-11-26T14:22:43.941Z |
5560882 | 5560882 | 20241120150918_xvBFn | NZ001Q | 2024-11-21T14:09:55.245Z | 2024-11-26T14:26:08.400Z |
5560693 | 5560693 | 20241120135703_snFZQ | NZ001Q | 2024-11-21T14:09:29.009Z | 2024-11-26T14:26:07.573Z |
5560686 | 5560686 | 20241120135605_EmGor | NZ001Q | 2024-11-21T14:09:26.643Z | 2024-11-26T14:26:07.568Z |
5560459 | 5560459 | 20241120125354_xZubJ | NZ001Q | 2024-11-21T14:08:54.246Z | 2024-11-26T14:26:06.563Z |
5550663 | 5550663 | 20241118110455_8wdg2 | NZ001Q | 2024-11-19T14:02:53.644Z | 2024-11-26T14:28:03.446Z |
5550227 | 5550227 | 20241118094956_i19TH | NZ001Q | 2024-11-19T14:01:51.028Z | 2024-11-26T14:28:01.137Z |
5549949 | 5549949 | 20241118085535_WdKvc | NZ001Q | 2024-11-19T14:01:20.920Z | 2024-11-26T14:27:59.436Z |
5546278 | 5546278 | 20241117101000_vvjfa | NZ001Q | 2024-11-18T14:02:40.332Z | 2024-11-26T14:28:26.652Z |
5546000 | 5546000 | 20241117083925_sMQ0X | NZ001Q | 2024-11-18T14:01:41.536Z | 2024-11-26T14:28:24.640Z |
5545994 | 5545994 | 20241117083837_oOyL3 | NZ001Q | 2024-11-18T14:01:41.107Z | 2024-11-26T14:28:24.637Z |
5535861 | 5535861 | 20241112143806_tx8l7 | NZ001Q | 2024-11-14T14:08:55.323Z | 2024-11-21T14:25:53.893Z |
5535850 | 5535850 | 20241112143730_gMerp | NZ001Q | 2024-11-14T14:08:54.602Z | 2024-11-21T14:25:53.832Z |
5535796 | 5535796 | 20241112142332_eDXXw | NZ001Q | 2024-11-14T14:08:50.531Z | 2024-11-21T14:25:53.498Z |
5535348 | 5535348 | 20241112121819_jUShL | NZ001Q | 2024-11-14T14:07:50.430Z | 2024-11-21T14:25:46.526Z |
5535091 | 5535091 | 20241112113606_RYipF | NZ001Q | 2024-11-14T14:07:13.317Z | 2024-11-21T14:25:43.848Z |
5520210 | 5520210 | 20241111145829_hhRtS | NZ001Q | 2024-11-12T14:05:58.257Z | 2024-11-20T14:25:05.823Z |
5514442 | 5514442 | 20241110155113_2ViWX | NZ001Q | 2024-11-11T14:06:38.258Z | 2024-11-19T14:21:47.939Z |
5514296 | 5514296 | 20241110152650_FluwF | NZ001Q | 2024-11-11T14:06:26.665Z | 2024-11-19T14:21:45.724Z |
5514100 | 5514100 | 20241110142655_vAwJy | NZ001Q | 2024-11-11T14:06:08.449Z | 2024-11-19T14:21:43.397Z |
5473759 | 5473759 | 20241103145923_n3922 | NZ001Q | 2024-11-05T14:09:41.694Z | 2024-11-12T14:27:49.993Z |
5473749 | 5473749 | 20241103145858_ivuTz | NZ001Q | 2024-11-05T14:09:41.029Z | 2024-11-12T14:27:49.990Z |
5473693 | 5473693 | 20241103145030_QUdTL | NZ001Q | 2024-11-05T14:09:27.013Z | 2024-11-12T14:27:49.915Z |
5473330 | 5473330 | 20241103140328_wBJYz | NZ001Q | 2024-11-05T14:08:48.355Z | 2024-11-12T14:27:48.704Z |
5473300 | 5473300 | 20241103135534_evrmL | NZ001Q | 2024-11-05T14:08:46.264Z | 2024-11-12T14:27:48.433Z |
5473276 | 5473276 | 20241103135303_LjEQ7 | NZ001Q | 2024-11-05T14:08:44.371Z | 2024-11-12T14:27:48.418Z |
5473163 | 5473163 | 20241103133622_zt2tW | NZ001Q | 2024-11-05T14:08:27.141Z | 2024-11-12T14:27:48.128Z |
5472829 | 5472829 | 20241103125001_2LiO1 | NZ001Q | 2024-11-05T14:07:46.331Z | 2024-11-12T14:27:46.795Z |
5472774 | 5472774 | 20241103123600_OpG4t | NZ001Q | 2024-11-05T14:07:41.404Z | 2024-11-12T14:27:46.595Z |
5472724 | 5472724 | 20241103123038_9zUok | NZ001Q | 2024-11-05T14:07:37.476Z | 2024-11-12T14:27:46.459Z |
5472703 | 5472703 | 20241103122505_0oVdi | NZ001Q | 2024-11-05T14:07:33.706Z | 2024-11-12T14:27:46.349Z |
5471244 | 5471244 | 20241104111441_IH6Fq | NZ001Q | 2024-11-05T14:03:11.328Z | 2024-11-13T14:27:23.972Z |
5471214 | 5471214 | 20241104110401_8WWl4 | NZ001Q | 2024-11-05T14:03:08.748Z | 2024-11-13T14:27:23.920Z |
5470801 | 5470801 | 20241104095046_GLdKn | NZ001Q | 2024-11-05T14:01:54.286Z | 2024-11-13T14:27:22.943Z |
5465140 | 5465140 | 20241103104555_cCJcX | NZ001Q | 2024-11-04T14:02:55.457Z | 2024-11-12T14:27:45.172Z |
5465097 | 5465097 | 20241103103757_c6dXM | NZ001Q | 2024-11-04T14:02:44.888Z | 2024-11-12T14:27:44.551Z |
5464825 | 5464825 | 20241103092332_WpjWH | NZ001Q | 2024-11-04T14:01:46.680Z | 2024-11-12T14:27:43.286Z |
5449302 | 5449302 | 20241031151752_wqN1W | NZ001Q | 2024-11-02T12:12:27.889Z | 2024-11-09T14:24:10.138Z |
5449290 | 5449290 | 20241031151711_zI31l | NZ001Q | 2024-11-02T12:12:26.616Z | 2024-11-09T14:24:10.102Z |
5449172 | 5449172 | 20241031150153_6rg4X | NZ001Q | 2024-11-02T12:12:12.769Z | 2024-11-09T14:24:09.631Z |
5448740 | 5448740 | 20241031141212_9gS30 | NZ001Q | 2024-11-02T12:11:23.105Z | 2024-11-09T14:24:07.228Z |
5448558 | 5448558 | 20241031134611_DEn2g | NZ001Q | 2024-11-02T12:11:05.712Z | 2024-11-09T14:24:06.435Z |
5448516 | 5448516 | 20241031134147_pu6mD | NZ001Q | 2024-11-02T12:10:59.125Z | 2024-11-09T14:24:06.259Z |
5448429 | 5448429 | 20241031133113_H0o8D | NZ001Q | 2024-11-02T12:10:45.501Z | 2024-11-09T14:24:05.854Z |
5448259 | 5448259 | 20241031130356_IGqyp | NZ001Q | 2024-11-02T12:10:25.663Z | 2024-11-09T14:24:04.115Z |
5437680 | 5437680 | 20241030153442_C3qct | NZ001Q | 2024-11-01T12:10:11.442Z | 2024-11-08T14:22:57.799Z |
5437399 | 5437399 | 20241030150320_xf2tb | NZ001Q | 2024-11-01T12:09:31.872Z | 2024-11-08T14:22:57.094Z |
5437338 | 5437338 | 20241030145707_rt3Ib | NZ001Q | 2024-11-01T12:09:25.978Z | 2024-11-08T14:22:56.999Z |
5436794 | 5436794 | 20241030134834_vAbAA | NZ001Q | 2024-11-01T12:08:21.756Z | 2024-11-08T14:22:55.601Z |
5435121 | 5435121 | 20241030105212_kN3bl | NZ001Q | 2024-11-01T12:04:20.969Z | 2024-11-08T14:22:49.356Z |
5426791 | 5426791 | 20241028135652_rBV46 | NZ001Q | 2024-10-31T12:12:28.465Z | 2024-11-06T14:27:10.631Z |
5422589 | 5422589 | 20241028131957_ILUxQ | NZ001Q | 2024-10-30T12:20:28.284Z | 2024-11-06T14:27:10.338Z |
5422540 | 5422540 | 20241028131254_H285K | NZ001Q | 2024-10-30T12:20:27.603Z | 2024-11-06T14:27:10.294Z |
5422410 | 5422410 | 20241028125953_wbzeD | NZ001Q | 2024-10-30T12:20:26.422Z | 2024-11-06T14:27:10.140Z |
5422327 | 5422327 | 20241028124941_Hb23r | NZ001Q | 2024-10-30T12:20:25.520Z | 2024-11-06T14:27:10.052Z |
5422248 | 5422248 | 20241028123712_UCgji | NZ001Q | 2024-10-30T12:20:24.472Z | 2024-11-06T14:27:09.883Z |
5422012 | 5422012 | 20241028120843_jtPx7 | NZ001Q | 2024-10-30T12:20:20.164Z | 2024-11-06T14:27:09.057Z |
5421882 | 5421882 | 20241028115537_QrlbK | NZ001Q | 2024-10-30T12:20:17.035Z | 2024-11-06T14:27:08.661Z |
5421779 | 5421779 | 20241028113649_Iu3ba | NZ001Q | 2024-10-30T12:20:14.836Z | 2024-11-06T14:27:08.418Z |
5416385 | 5416385 | 20241027154642_jGPSO | NZ001Q | 2024-10-30T12:11:31.821Z | 2024-11-05T14:27:04.801Z |
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);