participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,319 rows where station_code = "NZ003K" 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 |
---|---|---|---|---|---|
5494108 | 5494108 | 20241107153815_vmJ5U | NZ003K | 2024-11-08T14:05:23.235Z | 2024-11-08T14:05:23.235Z |
5494104 | 5494104 | 20241107153547_vzA1h | NZ003K | 2024-11-08T14:05:23.003Z | 2024-11-08T14:05:23.003Z |
5494053 | 5494053 | 20241107152304_8ggb4 | NZ003K | 2024-11-08T14:05:18.162Z | 2024-11-08T14:05:18.162Z |
5494021 | 5494021 | 20241107151306_36aIz | NZ003K | 2024-11-08T14:05:16.026Z | 2024-11-08T14:05:16.026Z |
5493982 | 5493982 | 20241107150033_zRw76 | NZ003K | 2024-11-08T14:05:10.944Z | 2024-11-08T14:05:10.944Z |
5492658 | 5492658 | 20241107092537_31zEy | NZ003K | 2024-11-08T14:01:46.826Z | 2024-11-08T14:01:46.826Z |
5492514 | 5492514 | 20241107084652_g2v0w | NZ003K | 2024-11-08T14:01:19.490Z | 2024-11-08T14:01:19.490Z |
5492418 | 5492418 | 20241107083113_jd9Dk | NZ003K | 2024-11-08T14:01:02.276Z | 2024-11-08T14:01:02.276Z |
5479257 | 5479257 | 20241105084732_thcgu | NZ003K | 2024-11-06T14:01:37.857Z | 2024-11-08T14:14:48.194Z |
5479067 | 5479067 | 20241105075015_uK3md | NZ003K | 2024-11-06T14:00:54.029Z | 2024-11-08T14:14:41.171Z |
5474107 | 5474107 | 20241103155341_0OwU0 | NZ003K | 2024-11-05T14:10:08.925Z | 2024-11-08T14:19:21.319Z |
5474086 | 5474086 | 20241103155045_tJC32 | NZ003K | 2024-11-05T14:10:07.711Z | 2024-11-08T14:19:20.692Z |
5473946 | 5473946 | 20241103152648_iNKXl | NZ003K | 2024-11-05T14:09:55.544Z | 2024-11-08T14:19:19.460Z |
5473697 | 5473697 | 20241103145039_LOPd9 | NZ003K | 2024-11-05T14:09:27.589Z | 2024-11-08T14:19:18.409Z |
5473604 | 5473604 | 20241103143839_1QLLe | NZ003K | 2024-11-05T14:09:11.848Z | 2024-11-08T14:19:17.924Z |
5473542 | 5473542 | 20241103143040_Yf1NK | NZ003K | 2024-11-05T14:09:05.036Z | 2024-11-08T14:19:17.447Z |
5473533 | 5473533 | 20241103142959_XKwWH | NZ003K | 2024-11-05T14:09:04.601Z | 2024-11-08T14:19:17.438Z |
5473436 | 5473436 | 20241103141605_drP11 | NZ003K | 2024-11-05T14:08:56.106Z | 2024-11-08T14:19:16.829Z |
5473432 | 5473432 | 20241103141551_IYgsQ | NZ003K | 2024-11-05T14:08:55.618Z | 2024-11-08T14:19:16.809Z |
5473326 | 5473326 | 20241103140150_27VeN | NZ003K | 2024-11-05T14:08:48.154Z | 2024-11-08T14:19:15.667Z |
5473281 | 5473281 | 20241103135324_EIyrf | NZ003K | 2024-11-05T14:08:44.881Z | 2024-11-08T14:19:14.826Z |
5473209 | 5473209 | 20241103134306_yW2q3 | NZ003K | 2024-11-05T14:08:34.585Z | 2024-11-08T14:19:14.383Z |
5473047 | 5473047 | 20241103131833_rSvAL | NZ003K | 2024-11-05T14:08:06.290Z | 2024-11-08T14:19:13.151Z |
5473033 | 5473033 | 20241103131708_q0Bn3 | NZ003K | 2024-11-05T14:08:04.940Z | 2024-11-08T14:19:13.006Z |
5472997 | 5472997 | 20241103131219_kfrOI | NZ003K | 2024-11-05T14:08:01.827Z | 2024-11-08T14:19:12.710Z |
5472884 | 5472884 | 20241103125604_hspXG | NZ003K | 2024-11-05T14:07:49.702Z | 2024-11-08T14:19:11.279Z |
5472862 | 5472862 | 20241103125332_x0Vdf | NZ003K | 2024-11-05T14:07:48.485Z | 2024-11-08T14:19:10.969Z |
5472851 | 5472851 | 20241103125310_iKydG | NZ003K | 2024-11-05T14:07:47.831Z | 2024-11-08T14:19:10.919Z |
5472767 | 5472767 | 20241103123452_yT500 | NZ003K | 2024-11-05T14:07:40.847Z | 2024-11-08T14:19:10.280Z |
5472726 | 5472726 | 20241103123038_9zUok | NZ003K | 2024-11-05T14:07:37.476Z | 2024-11-08T14:19:10.065Z |
5472681 | 5472681 | 20241103122305_ygvyQ | NZ003K | 2024-11-05T14:07:27.823Z | 2024-11-08T14:19:09.415Z |
5472665 | 5472665 | 20241103121933_K8wlY | NZ003K | 2024-11-05T14:07:24.414Z | 2024-11-08T14:19:09.124Z |
5472662 | 5472662 | 20241103121901_U2r2q | NZ003K | 2024-11-05T14:07:24.281Z | 2024-11-08T14:19:09.111Z |
5472658 | 5472658 | 20241103121817_X6inE | NZ003K | 2024-11-05T14:07:23.949Z | 2024-11-08T14:19:09.079Z |
5472609 | 5472609 | 20241104155704_vaDpk | NZ003K | 2024-11-05T14:06:20.005Z | 2024-11-08T14:17:57.305Z |
5472567 | 5472567 | 20241104154548_kIght | NZ003K | 2024-11-05T14:06:15.636Z | 2024-11-08T14:17:56.337Z |
5472547 | 5472547 | 20241104154016_B1bM8 | NZ003K | 2024-11-05T14:06:12.032Z | 2024-11-08T14:17:55.910Z |
5472287 | 5472287 | 20241104142630_TEurA | NZ003K | 2024-11-05T14:05:34.987Z | 2024-11-08T14:17:49.168Z |
5472192 | 5472192 | 20241104140242_TiCDX | NZ003K | 2024-11-05T14:05:26.014Z | 2024-11-08T14:17:47.950Z |
5472146 | 5472146 | 20241104135453_3q064 | NZ003K | 2024-11-05T14:05:16.232Z | 2024-11-08T14:17:47.480Z |
5472068 | 5472068 | 20241104133348_HOvjw | NZ003K | 2024-11-05T14:05:04.281Z | 2024-11-08T14:17:46.513Z |
5472063 | 5472063 | 20241104133313_HfYPh | NZ003K | 2024-11-05T14:05:03.794Z | 2024-11-08T14:17:46.512Z |
5472023 | 5472023 | 20241104132528_vFnSs | NZ003K | 2024-11-05T14:04:59.979Z | 2024-11-08T14:17:45.720Z |
5472020 | 5472020 | 20241104132431_Ratzc | NZ003K | 2024-11-05T14:04:59.373Z | 2024-11-08T14:17:45.584Z |
5471990 | 5471990 | 20241104131801_4ebsd | NZ003K | 2024-11-05T14:04:55.235Z | 2024-11-08T14:17:44.843Z |
5471974 | 5471974 | 20241104131125_YsYru | NZ003K | 2024-11-05T14:04:54.053Z | 2024-11-08T14:17:44.547Z |
5471961 | 5471961 | 20241104130928_ic3EL | NZ003K | 2024-11-05T14:04:53.414Z | 2024-11-08T14:17:44.446Z |
5471942 | 5471942 | 20241104130631_yw13y | NZ003K | 2024-11-05T14:04:51.486Z | 2024-11-08T14:17:44.134Z |
5471890 | 5471890 | 20241104125628_HUaE2 | NZ003K | 2024-11-05T14:04:46.081Z | 2024-11-08T14:17:43.285Z |
5471857 | 5471857 | 20241104125139_LS08z | NZ003K | 2024-11-05T14:04:43.270Z | 2024-11-08T14:17:42.909Z |
5471793 | 5471793 | 20241104124037_wcIFl | NZ003K | 2024-11-05T14:04:37.083Z | 2024-11-08T14:17:41.711Z |
5471718 | 5471718 | 20241104122931_hduWw | NZ003K | 2024-11-05T14:04:29.885Z | 2024-11-08T14:17:40.180Z |
5471628 | 5471628 | 20241104121258_1K52i | NZ003K | 2024-11-05T14:04:06.753Z | 2024-11-08T14:17:37.901Z |
5471610 | 5471610 | 20241104120903_AJXTe | NZ003K | 2024-11-05T14:04:04.139Z | 2024-11-08T14:17:37.289Z |
5471531 | 5471531 | 20241104115914_QIXPf | NZ003K | 2024-11-05T14:03:53.632Z | 2024-11-08T14:17:35.462Z |
5471528 | 5471528 | 20241104115913_YfOrY | NZ003K | 2024-11-05T14:03:53.190Z | 2024-11-08T14:17:35.443Z |
5471510 | 5471510 | 20241104115659_erxqA | NZ003K | 2024-11-05T14:03:50.838Z | 2024-11-08T14:17:34.766Z |
5471500 | 5471500 | 20241104115357_4anxz | NZ003K | 2024-11-05T14:03:50.076Z | 2024-11-08T14:17:34.706Z |
5471489 | 5471489 | 20241104115217_zjHUW | NZ003K | 2024-11-05T14:03:49.281Z | 2024-11-08T14:17:34.280Z |
5471468 | 5471468 | 20241104114749_8hKQV | NZ003K | 2024-11-05T14:03:47.075Z | 2024-11-08T14:17:34.033Z |
5471442 | 5471442 | 20241104114458_Kmkyi | NZ003K | 2024-11-05T14:03:44.413Z | 2024-11-08T14:17:33.594Z |
5471386 | 5471386 | 20241104113538_f94j5 | NZ003K | 2024-11-05T14:03:37.378Z | 2024-11-08T14:17:32.945Z |
5471323 | 5471323 | 20241104112700_b3Wxa | NZ003K | 2024-11-05T14:03:26.138Z | 2024-11-08T14:17:32.158Z |
5471264 | 5471264 | 20241104112112_HpO6I | NZ003K | 2024-11-05T14:03:15.215Z | 2024-11-08T14:17:31.633Z |
5471240 | 5471240 | 20241104111410_DaTmv | NZ003K | 2024-11-05T14:03:11.058Z | 2024-11-08T14:17:31.173Z |
5471209 | 5471209 | 20241104110312_2bdHJ | NZ003K | 2024-11-05T14:03:07.989Z | 2024-11-08T14:17:30.741Z |
5470884 | 5470884 | 20241104095838_jFoJv | NZ003K | 2024-11-05T14:02:10.236Z | 2024-11-08T14:17:20.807Z |
5470742 | 5470742 | 20241104093654_rlAQo | NZ003K | 2024-11-05T14:01:42.945Z | 2024-11-08T14:17:18.776Z |
5470492 | 5470492 | 20241104081903_A0Ro5 | NZ003K | 2024-11-05T14:00:53.439Z | 2024-11-08T14:17:13.309Z |
5465480 | 5465480 | 20241103121124_AcyJi | NZ003K | 2024-11-04T14:03:47.848Z | 2024-11-08T14:19:08.665Z |
5465470 | 5465470 | 20241103121054_KXxFb | NZ003K | 2024-11-04T14:03:47.093Z | 2024-11-08T14:19:08.659Z |
5465460 | 5465460 | 20241103120934_kVx5Q | NZ003K | 2024-11-04T14:03:46.121Z | 2024-11-08T14:19:08.645Z |
5465434 | 5465434 | 20241103115505_bB6P0 | NZ003K | 2024-11-04T14:03:42.595Z | 2024-11-08T14:19:08.525Z |
5465349 | 5465349 | 20241103113211_UWOeW | NZ003K | 2024-11-04T14:03:32.967Z | 2024-11-08T14:19:07.760Z |
5465332 | 5465332 | 20241103112821_nPy8C | NZ003K | 2024-11-04T14:03:23.064Z | 2024-11-08T14:19:07.488Z |
5465275 | 5465275 | 20241103111527_w431n | NZ003K | 2024-11-04T14:03:14.378Z | 2024-11-08T14:19:06.755Z |
5465234 | 5465234 | 20241103110805_lNQkH | NZ003K | 2024-11-04T14:03:07.977Z | 2024-11-08T14:19:06.311Z |
5465029 | 5465029 | 20241103102448_71BBm | NZ003K | 2024-11-04T14:02:31.128Z | 2024-11-08T14:19:03.596Z |
5464973 | 5464973 | 20241103100848_OA83Y | NZ003K | 2024-11-04T14:02:22.099Z | 2024-11-08T14:19:03.104Z |
5464937 | 5464937 | 20241103095554_Lv1B6 | NZ003K | 2024-11-04T14:02:14.463Z | 2024-11-08T14:19:01.970Z |
5464911 | 5464911 | 20241103095053_s8N9q | NZ003K | 2024-11-04T14:02:09.319Z | 2024-11-08T14:19:01.813Z |
5464884 | 5464884 | 20241103094742_342RN | NZ003K | 2024-11-04T14:02:02.403Z | 2024-11-08T14:19:01.728Z |
5464833 | 5464833 | 20241103092812_ND4Nq | NZ003K | 2024-11-04T14:01:47.995Z | 2024-11-08T14:19:01.361Z |
5464677 | 5464677 | 20241103084712_74tIb | NZ003K | 2024-11-04T14:01:19.232Z | 2024-11-08T14:19:00.058Z |
5464646 | 5464646 | 20241103084257_2Woyy | NZ003K | 2024-11-04T14:01:12.710Z | 2024-11-08T14:18:59.836Z |
5457817 | 5457817 | 20241102152546_fFaI4 | NZ003K | 2024-11-03T14:08:13.793Z | 2024-11-08T14:20:41.333Z |
5457670 | 5457670 | 20241102150656_HxZbv | NZ003K | 2024-11-03T14:07:49.756Z | 2024-11-08T14:20:40.108Z |
5457562 | 5457562 | 20241102144741_8fxlJ | NZ003K | 2024-11-03T14:07:39.741Z | 2024-11-08T14:20:39.555Z |
5457454 | 5457454 | 20241102143328_wicWZ | NZ003K | 2024-11-03T14:07:22.147Z | 2024-11-08T14:20:39.254Z |
5457346 | 5457346 | 20241102141834_vR2ba | NZ003K | 2024-11-03T14:07:09.707Z | 2024-11-08T14:20:38.955Z |
5457329 | 5457329 | 20241102141109_PcWvi | NZ003K | 2024-11-03T14:07:07.875Z | 2024-11-08T14:20:38.935Z |
5457271 | 5457271 | 20241102140228_oY9a2 | NZ003K | 2024-11-03T14:07:01.591Z | 2024-11-08T14:20:38.526Z |
5457206 | 5457206 | 20241102134802_tTUqQ | NZ003K | 2024-11-03T14:06:47.259Z | 2024-11-08T14:20:38.215Z |
5457162 | 5457162 | 20241102134101_j5O3t | NZ003K | 2024-11-03T14:06:40.466Z | 2024-11-08T14:20:38.091Z |
5457118 | 5457118 | 20241102133436_PARxI | NZ003K | 2024-11-03T14:06:35.950Z | 2024-11-08T14:20:37.717Z |
5456776 | 5456776 | 20241102122227_fI9nf | NZ003K | 2024-11-03T14:05:39.916Z | 2024-11-08T14:20:33.550Z |
5456741 | 5456741 | 20241102121258_BOafw | NZ003K | 2024-11-03T14:05:35.905Z | 2024-11-08T14:20:33.307Z |
5456691 | 5456691 | 20241102120437_DCSbh | NZ003K | 2024-11-03T14:05:26.064Z | 2024-11-08T14:20:32.703Z |
5456679 | 5456679 | 20241102120248_ygzbq | NZ003K | 2024-11-03T14:05:21.833Z | 2024-11-08T14:20:32.548Z |
5456675 | 5456675 | 20241102120219_oN788 | NZ003K | 2024-11-03T14:05:21.005Z | 2024-11-08T14:20:32.545Z |
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);