participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,050 rows where station_code = "NZ000R" 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 |
---|---|---|---|---|---|
5135047 | 5135047 | 20240916154342_Ew9n9 | NZ000R | 2024-09-19T12:18:13.405Z | 2024-09-19T12:18:13.405Z |
5130648 | 5130648 | 20240917140712_vTUOc | NZ000R | 2024-09-19T12:13:42.211Z | 2024-09-19T12:13:42.211Z |
5124126 | 5124126 | 20240914153016_Dr6aP | NZ000R | 2024-09-18T12:12:08.671Z | 2024-09-19T12:20:18.211Z |
5071651 | 5071651 | 20240911173604_oI2VT | NZ000R | 2024-09-15T12:03:10.365Z | 2024-09-19T12:21:02.275Z |
5071573 | 5071573 | 20240911171824_83CPO | NZ000R | 2024-09-15T12:02:59.857Z | 2024-09-19T12:21:02.126Z |
5071568 | 5071568 | 20240911171811_7CE60 | NZ000R | 2024-09-15T12:02:59.161Z | 2024-09-19T12:21:02.119Z |
5070476 | 5070476 | 20240909125823_2PCz6 | NZ000R | 2024-09-14T12:21:21.994Z | 2024-09-17T12:19:12.520Z |
5069084 | 5069084 | 20240910134053_52i6w | NZ000R | 2024-09-14T12:19:25.461Z | 2024-09-18T12:15:27.113Z |
5068992 | 5068992 | 20240910131930_enJaH | NZ000R | 2024-09-14T12:19:23.495Z | 2024-09-18T12:15:26.959Z |
5062691 | 5062691 | 20240909180127_2SK9c | NZ000R | 2024-09-14T12:12:43.367Z | 2024-09-18T12:15:11.929Z |
5062419 | 5062419 | 20240909172239_132qM | NZ000R | 2024-09-14T12:12:19.020Z | 2024-09-18T12:15:11.317Z |
5062352 | 5062352 | 20240909171429_xgUKI | NZ000R | 2024-09-14T12:12:12.661Z | 2024-09-18T12:15:11.015Z |
5062269 | 5062269 | 20240909170507_6zdZi | NZ000R | 2024-09-14T12:12:03.340Z | 2024-09-18T12:15:10.826Z |
5061936 | 5061936 | 20240909162455_oeTN8 | NZ000R | 2024-09-14T12:11:39.837Z | 2024-09-18T12:15:10.170Z |
5061915 | 5061915 | 20240909162251_FojmG | NZ000R | 2024-09-14T12:11:38.549Z | 2024-09-18T12:15:10.155Z |
5061466 | 5061466 | 20240909151009_DODaD | NZ000R | 2024-09-14T12:10:51.352Z | 2024-09-18T12:15:09.320Z |
5061337 | 5061337 | 20240909145008_Zthqj | NZ000R | 2024-09-14T12:10:43.076Z | 2024-09-18T12:15:08.938Z |
5060921 | 5060921 | 20240909132323_D29LU | NZ000R | 2024-09-14T12:09:55.735Z | 2024-09-18T12:15:07.292Z |
5059427 | 5059427 | 20240910174124_L4NQV | NZ000R | 2024-09-14T12:05:59.784Z | 2024-09-19T12:21:30.738Z |
5059332 | 5059332 | 20240910173211_X629l | NZ000R | 2024-09-14T12:05:46.417Z | 2024-09-19T12:21:30.640Z |
5059287 | 5059287 | 20240910172808_sYr2k | NZ000R | 2024-09-14T12:05:36.010Z | 2024-09-19T12:21:30.485Z |
5058634 | 5058634 | 20240910163225_U92vP | NZ000R | 2024-09-14T12:04:13.172Z | 2024-09-19T12:21:29.797Z |
5057415 | 5057415 | 20240910142517_2psVQ | NZ000R | 2024-09-14T12:01:01.710Z | 2024-09-19T12:21:27.834Z |
5057337 | 5057337 | 20240910141248_zJ3fM | NZ000R | 2024-09-14T12:00:52.422Z | 2024-09-19T12:21:27.580Z |
5057335 | 5057335 | 20240910141219_QQEpX | NZ000R | 2024-09-14T12:00:52.029Z | 2024-09-19T12:21:27.578Z |
5057326 | 5057326 | 20240910141137_tjkl8 | NZ000R | 2024-09-14T12:00:50.802Z | 2024-09-19T12:21:27.557Z |
5057177 | 5057177 | 20240910135338_wthDR | NZ000R | 2024-09-14T12:00:25.934Z | 2024-09-19T12:21:27.226Z |
5049338 | 5049338 | 20240909104006_Fap2f | NZ000R | 2024-09-13T12:12:01.630Z | 2024-09-17T12:19:10.174Z |
5045024 | 5045024 | 20240908160805_ux6QX | NZ000R | 2024-09-13T12:03:25.020Z | 2024-09-17T12:18:55.623Z |
5044953 | 5044953 | 20240908155758_2R2AW | NZ000R | 2024-09-13T12:03:16.068Z | 2024-09-17T12:18:55.471Z |
5044917 | 5044917 | 20240908155456_e3cD1 | NZ000R | 2024-09-13T12:03:09.894Z | 2024-09-17T12:18:55.417Z |
5044830 | 5044830 | 20240908154823_Fpd9x | NZ000R | 2024-09-13T12:03:00.993Z | 2024-09-17T12:18:55.260Z |
5044765 | 5044765 | 20240908154025_XteyF | NZ000R | 2024-09-13T12:02:54.479Z | 2024-09-17T12:18:54.996Z |
5044128 | 5044128 | 20240908141630_fXDur | NZ000R | 2024-09-13T12:01:31.471Z | 2024-09-17T12:18:53.573Z |
5043974 | 5043974 | 20240908134227_LntuW | NZ000R | 2024-09-13T12:01:06.002Z | 2024-09-17T12:18:53.143Z |
5043372 | 5043372 | 20240907105214_Y2Y06 | NZ000R | 2024-09-12T12:17:32.109Z | 2024-09-15T12:21:41.528Z |
5043236 | 5043236 | 20240907141015_wncDa | NZ000R | 2024-09-12T12:17:25.474Z | 2024-09-16T12:20:55.943Z |
5041351 | 5041351 | 20240906080200_VX2kY | NZ000R | 2024-09-12T12:16:39.283Z | 2024-09-14T12:23:13.311Z |
5036373 | 5036373 | 20240905132123_bddzq | NZ000R | 2024-09-12T12:13:38.128Z | 2024-09-14T12:22:52.379Z |
5036304 | 5036304 | 20240905131325_vsk1I | NZ000R | 2024-09-12T12:13:33.883Z | 2024-09-14T12:22:52.256Z |
5036233 | 5036233 | 20240905130019_4KW2A | NZ000R | 2024-09-12T12:13:30.288Z | 2024-09-14T12:22:52.120Z |
5035849 | 5035849 | 20240907103730_PWonB | NZ000R | 2024-09-12T12:12:34.577Z | 2024-09-15T12:21:41.397Z |
5035781 | 5035781 | 20240907102431_944wk | NZ000R | 2024-09-12T12:12:28.547Z | 2024-09-15T12:21:41.228Z |
5035771 | 5035771 | 20240907102009_oRS3q | NZ000R | 2024-09-12T12:12:27.929Z | 2024-09-15T12:21:41.173Z |
5035691 | 5035691 | 20240907100645_pAjam | NZ000R | 2024-09-12T12:12:22.522Z | 2024-09-15T12:21:40.563Z |
5035484 | 5035484 | 20240907093754_r1duH | NZ000R | 2024-09-12T12:12:09.700Z | 2024-09-15T12:21:39.694Z |
5035455 | 5035455 | 20240907093206_B2FB3 | NZ000R | 2024-09-12T12:12:06.002Z | 2024-09-15T12:21:39.620Z |
5035426 | 5035426 | 20240907092815_XVxYl | NZ000R | 2024-09-12T12:12:04.333Z | 2024-09-15T12:21:39.583Z |
5034700 | 5034700 | 20240907074504_RppPP | NZ000R | 2024-09-12T12:11:12.895Z | 2024-09-15T12:21:35.565Z |
5027979 | 5027979 | 20240905084935_6ol3L | NZ000R | 2024-09-11T12:14:40.910Z | 2024-09-13T12:20:05.106Z |
5022418 | 5022418 | 20240905084935_tbMw8 | NZ000R | 2024-09-10T12:16:18.077Z | 2024-09-13T12:20:05.105Z |
5018380 | 5018380 | 20240904175250_g4Rdz | NZ000R | 2024-09-10T12:10:32.215Z | 2024-09-13T12:19:47.668Z |
5017663 | 5017663 | 20240904162915_kwg00 | NZ000R | 2024-09-10T12:09:21.855Z | 2024-09-13T12:19:47.034Z |
5017181 | 5017181 | 20240904153839_O447f | NZ000R | 2024-09-10T12:08:54.661Z | 2024-09-13T12:19:46.629Z |
5017094 | 5017094 | 20240904153031_M5U2j | NZ000R | 2024-09-10T12:08:47.575Z | 2024-09-13T12:19:46.572Z |
5016980 | 5016980 | 20240904151755_w8EP7 | NZ000R | 2024-09-10T12:08:36.401Z | 2024-09-13T12:19:46.482Z |
5014694 | 5014694 | 20240905132123_6wjVk | NZ000R | 2024-09-10T12:03:41.335Z | 2024-09-11T12:16:31.252Z |
5014625 | 5014625 | 20240905131325_SBT47 | NZ000R | 2024-09-10T12:03:34.938Z | 2024-09-11T12:16:31.230Z |
5014558 | 5014558 | 20240905130019_LD86d | NZ000R | 2024-09-10T12:03:27.339Z | 2024-09-11T12:16:31.203Z |
5006592 | 5006592 | 20240903175710_kGqGO | NZ000R | 2024-09-09T12:04:47.833Z | 2024-09-12T12:19:08.986Z |
5006070 | 5006070 | 20240903165203_ECz2U | NZ000R | 2024-09-09T12:04:19.005Z | 2024-09-12T12:19:07.576Z |
5005574 | 5005574 | 20240903153925_VGLAz | NZ000R | 2024-09-09T12:03:49.341Z | 2024-09-12T12:19:06.203Z |
5005271 | 5005271 | 20240903144314_LaPMY | NZ000R | 2024-09-09T12:03:32.795Z | 2024-09-12T12:19:05.616Z |
5005068 | 5005068 | 20240903135603_feUwQ | NZ000R | 2024-09-09T12:03:18.526Z | 2024-09-12T12:19:05.216Z |
5004881 | 5004881 | 20240903131319_nLBiC | NZ000R | 2024-09-09T12:03:09.707Z | 2024-09-12T12:19:04.423Z |
5004040 | 5004040 | 20240903102856_9geON | NZ000R | 2024-09-09T12:02:18.404Z | 2024-09-12T12:19:00.559Z |
5003818 | 5003818 | 20240903100015_y3P5v | NZ000R | 2024-09-09T12:02:06.617Z | 2024-09-12T12:18:59.440Z |
5003664 | 5003664 | 20240903093006_gaTh3 | NZ000R | 2024-09-09T12:01:56.797Z | 2024-09-12T12:18:58.366Z |
5003459 | 5003459 | 20240903085356_xKygv | NZ000R | 2024-09-09T12:01:45.052Z | 2024-09-12T12:18:56.836Z |
5003314 | 5003314 | 20240904113706_2ixg3 | NZ000R | 2024-09-09T12:01:33.630Z | 2024-09-13T12:19:44.024Z |
5003276 | 5003276 | 20240904113122_9Mzaf | NZ000R | 2024-09-09T12:01:31.427Z | 2024-09-13T12:19:43.951Z |
5003252 | 5003252 | 20240904112812_Uf6Jf | NZ000R | 2024-09-09T12:01:29.746Z | 2024-09-13T12:19:43.768Z |
5002858 | 5002858 | 20240904105006_O8EQL | NZ000R | 2024-09-09T12:01:06.324Z | 2024-09-13T12:19:42.273Z |
5002008 | 5002008 | 20240902072807_4FK9q | NZ000R | 2024-09-08T12:17:06.923Z | 2024-09-10T12:19:35.902Z |
5001991 | 5001991 | 20240902072652_ni7Fw | NZ000R | 2024-09-08T12:17:06.107Z | 2024-09-10T12:19:35.877Z |
4995153 | 4995153 | 20240902162247_SHOl2 | NZ000R | 2024-09-08T12:03:18.282Z | 2024-09-11T12:20:42.499Z |
4995063 | 4995063 | 20240902160810_dJQ3R | NZ000R | 2024-09-08T12:03:13.714Z | 2024-09-11T12:20:41.581Z |
4994570 | 4994570 | 20240902143224_cJrdi | NZ000R | 2024-09-08T12:02:42.844Z | 2024-09-11T12:20:35.115Z |
4993078 | 4993078 | 20240902094641_CbNEU | NZ000R | 2024-09-08T12:01:09.933Z | 2024-09-11T12:20:20.207Z |
4992799 | 4992799 | 20240902085720_Totii | NZ000R | 2024-09-08T12:00:51.960Z | 2024-09-11T12:20:17.398Z |
4992479 | 4992479 | 20240902080925_63m9P | NZ000R | 2024-09-08T12:00:24.932Z | 2024-09-11T12:20:13.365Z |
4985737 | 4985737 | 20240901132727_DjK6Y | NZ000R | 2024-09-07T12:03:42.372Z | 2024-09-10T12:19:08.206Z |
4960381 | 4960381 | 20240811162232_zYPcT | NZ000R | 2024-09-04T12:02:29.653Z | 2024-09-06T12:02:06.688Z |
4956200 | 4956200 | 20240811065417_40aAb | NZ000R | 2024-09-03T12:20:03.350Z | 2024-09-06T12:30:20.690Z |
4931724 | 4931724 | 20240810110120_6dKTi | NZ000R | 2024-08-31T12:24:52.596Z | 2024-09-02T12:31:08.646Z |
4931274 | 4931274 | 20240810100935_WoRGc | NZ000R | 2024-08-31T12:24:27.974Z | 2024-09-02T12:30:46.710Z |
4931219 | 4931219 | 20240810100158_vyZPi | NZ000R | 2024-08-31T12:24:25.246Z | 2024-09-02T12:30:44.722Z |
4931179 | 4931179 | 20240810095646_c7k2E | NZ000R | 2024-08-31T12:24:19.801Z | 2024-09-02T12:30:43.183Z |
4931161 | 4931161 | 20240810095136_y2qS3 | NZ000R | 2024-08-31T12:24:18.397Z | 2024-09-02T12:30:41.376Z |
4930721 | 4930721 | 20240810085306_0sYMU | NZ000R | 2024-08-31T12:23:50.322Z | 2024-09-02T12:30:24.264Z |
4930671 | 4930671 | 20240810084306_or6cF | NZ000R | 2024-08-31T12:23:48.134Z | 2024-09-02T12:30:22.608Z |
4930421 | 4930421 | 20240810081001_DMncn | NZ000R | 2024-08-31T12:23:29.413Z | 2024-09-02T12:30:12.367Z |
4910305 | 4910305 | 20240809175624_L7Qxk | NZ000R | 2024-08-29T12:06:03.304Z | 2024-09-02T12:20:38.622Z |
4910297 | 4910297 | 20240809175544_bgDLU | NZ000R | 2024-08-29T12:06:02.913Z | 2024-09-02T12:20:38.302Z |
4909975 | 4909975 | 20240809173447_JiyF2 | NZ000R | 2024-08-29T12:05:42.439Z | 2024-09-02T12:20:28.014Z |
4909157 | 4909157 | 20240809163523_YjAX2 | NZ000R | 2024-08-29T12:04:49.993Z | 2024-09-02T12:19:47.514Z |
4908331 | 4908331 | 20240809153226_L8Afv | NZ000R | 2024-08-29T12:03:59.225Z | 2024-09-02T12:19:10.348Z |
4908299 | 4908299 | 20240809153107_qmhIA | NZ000R | 2024-08-29T12:03:57.457Z | 2024-09-02T12:19:09.515Z |
4907098 | 4907098 | 20240809134545_Pbxga | NZ000R | 2024-08-29T12:02:39.620Z | 2024-09-02T12:18:08.341Z |
4905213 | 4905213 | 20240808084745_JJOsI | NZ000R | 2024-08-28T12:21:10.569Z | 2024-08-28T12:21:10.569Z |
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);