participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,084 rows where station_code = "NZ003U" 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 |
---|---|---|---|---|---|
5461066 | 5461066 | 20241101154531_4jm5c | NZ003U | 2024-11-03T14:14:41.697Z | 2024-11-03T14:19:33.665Z |
5461054 | 5461054 | 20241101154212_6rtaR | NZ003U | 2024-11-03T14:14:41.033Z | 2024-11-03T14:19:33.663Z |
5461024 | 5461024 | 20241101153700_pWZ2r | NZ003U | 2024-11-03T14:14:39.627Z | 2024-11-03T14:19:33.656Z |
5460993 | 5460993 | 20241101153112_n1XkE | NZ003U | 2024-11-03T14:14:38.112Z | 2024-11-03T14:19:33.651Z |
5460977 | 5460977 | 20241101153007_2yk6p | NZ003U | 2024-11-03T14:14:37.663Z | 2024-11-03T14:19:33.649Z |
5460959 | 5460959 | 20241101152551_R1zSu | NZ003U | 2024-11-03T14:14:36.220Z | 2024-11-03T14:19:33.645Z |
5460922 | 5460922 | 20241101152022_54f3m | NZ003U | 2024-11-03T14:14:34.357Z | 2024-11-03T14:19:33.637Z |
5460725 | 5460725 | 20241101145603_4BjVT | NZ003U | 2024-11-03T14:14:17.299Z | 2024-11-03T14:19:33.602Z |
5460634 | 5460634 | 20241101144036_Hj271 | NZ003U | 2024-11-03T14:14:05.917Z | 2024-11-03T14:19:33.586Z |
5460599 | 5460599 | 20241101143708_ndLY2 | NZ003U | 2024-11-03T14:14:01.295Z | 2024-11-03T14:19:33.581Z |
5460589 | 5460589 | 20241101143416_bzDUn | NZ003U | 2024-11-03T14:14:00.730Z | 2024-11-03T14:19:33.580Z |
5460531 | 5460531 | 20241101142746_gy6P6 | NZ003U | 2024-11-03T14:13:55.965Z | 2024-11-03T14:19:33.568Z |
5460511 | 5460511 | 20241101142520_ftSYz | NZ003U | 2024-11-03T14:13:53.859Z | 2024-11-03T14:19:33.564Z |
5460448 | 5460448 | 20241101141209_O74MY | NZ003U | 2024-11-03T14:13:45.214Z | 2024-11-03T14:19:33.549Z |
5457997 | 5457997 | 20241102155558_cpvsg | NZ003U | 2024-11-03T14:08:31.269Z | 2024-11-03T14:08:31.269Z |
5457977 | 5457977 | 20241102155148_uimCX | NZ003U | 2024-11-03T14:08:27.242Z | 2024-11-03T14:08:27.242Z |
5457965 | 5457965 | 20241102154959_4yjvY | NZ003U | 2024-11-03T14:08:24.865Z | 2024-11-03T14:08:24.865Z |
5457949 | 5457949 | 20241102154543_mK3Ai | NZ003U | 2024-11-03T14:08:23.368Z | 2024-11-03T14:08:23.368Z |
5457928 | 5457928 | 20241102154052_lxTiR | NZ003U | 2024-11-03T14:08:21.687Z | 2024-11-03T14:08:21.687Z |
5457756 | 5457756 | 20241102152121_YG4fJ | NZ003U | 2024-11-03T14:07:59.747Z | 2024-11-03T14:07:59.747Z |
5457713 | 5457713 | 20241102151456_yUaxz | NZ003U | 2024-11-03T14:07:53.959Z | 2024-11-03T14:07:53.959Z |
5457648 | 5457648 | 20241102150224_XoOgf | NZ003U | 2024-11-03T14:07:46.441Z | 2024-11-03T14:07:46.441Z |
5457635 | 5457635 | 20241102145917_CDDKK | NZ003U | 2024-11-03T14:07:45.618Z | 2024-11-03T14:07:45.618Z |
5457507 | 5457507 | 20241102143925_Cr90B | NZ003U | 2024-11-03T14:07:34.838Z | 2024-11-03T14:07:34.838Z |
5457289 | 5457289 | 20241102140355_1Txgd | NZ003U | 2024-11-03T14:07:03.376Z | 2024-11-03T14:07:03.376Z |
5457260 | 5457260 | 20241102135944_mzdSF | NZ003U | 2024-11-03T14:07:00.096Z | 2024-11-03T14:07:00.096Z |
5457247 | 5457247 | 20241102135734_2Jp5U | NZ003U | 2024-11-03T14:06:59.242Z | 2024-11-03T14:06:59.242Z |
5457195 | 5457195 | 20241102134554_TyAwV | NZ003U | 2024-11-03T14:06:44.508Z | 2024-11-03T14:06:44.508Z |
5457180 | 5457180 | 20241102134329_Uwyjf | NZ003U | 2024-11-03T14:06:43.198Z | 2024-11-03T14:06:43.198Z |
5457089 | 5457089 | 20241102132942_T3inI | NZ003U | 2024-11-03T14:06:32.529Z | 2024-11-03T14:06:32.529Z |
5457086 | 5457086 | 20241102132901_Ovdqn | NZ003U | 2024-11-03T14:06:31.631Z | 2024-11-03T14:06:31.631Z |
5457068 | 5457068 | 20241102132603_UHXhs | NZ003U | 2024-11-03T14:06:29.371Z | 2024-11-03T14:06:29.371Z |
5457026 | 5457026 | 20241102131504_YV0W4 | NZ003U | 2024-11-03T14:06:23.451Z | 2024-11-03T14:06:23.451Z |
5456999 | 5456999 | 20241102131239_2i1ty | NZ003U | 2024-11-03T14:06:20.387Z | 2024-11-03T14:06:20.387Z |
5456918 | 5456918 | 20241102125052_JPiDK | NZ003U | 2024-11-03T14:06:00.448Z | 2024-11-03T14:06:00.448Z |
5456896 | 5456896 | 20241102124433_tdnRX | NZ003U | 2024-11-03T14:05:54.126Z | 2024-11-03T14:05:54.126Z |
5456830 | 5456830 | 20241102123414_VIqWg | NZ003U | 2024-11-03T14:05:46.196Z | 2024-11-03T14:05:46.196Z |
5456707 | 5456707 | 20241102120706_0j2Kc | NZ003U | 2024-11-03T14:05:31.582Z | 2024-11-03T14:05:31.582Z |
5456648 | 5456648 | 20241102115751_REK0D | NZ003U | 2024-11-03T14:05:13.305Z | 2024-11-03T14:05:13.305Z |
5456393 | 5456393 | 20241102111214_S7LO3 | NZ003U | 2024-11-03T14:04:23.304Z | 2024-11-03T14:04:23.304Z |
5456376 | 5456376 | 20241102110831_as0pB | NZ003U | 2024-11-03T14:04:19.901Z | 2024-11-03T14:04:19.901Z |
5449700 | 5449700 | 20241031160957_M2byj | NZ003U | 2024-11-02T12:13:24.180Z | 2024-11-03T14:20:57.677Z |
5449457 | 5449457 | 20241031153819_g3OVb | NZ003U | 2024-11-02T12:12:56.170Z | 2024-11-03T14:20:53.304Z |
5449248 | 5449248 | 20241031150956_SidMs | NZ003U | 2024-11-02T12:12:20.248Z | 2024-11-03T14:20:49.846Z |
5449209 | 5449209 | 20241031150429_M3MOa | NZ003U | 2024-11-02T12:12:17.820Z | 2024-11-03T14:20:49.480Z |
5449038 | 5449038 | 20241031144631_T3eFl | NZ003U | 2024-11-02T12:11:59.896Z | 2024-11-03T14:20:47.638Z |
5449035 | 5449035 | 20241031144553_lDTWk | NZ003U | 2024-11-02T12:11:59.720Z | 2024-11-03T14:20:47.637Z |
5448642 | 5448642 | 20241031140015_1pQVg | NZ003U | 2024-11-02T12:11:14.184Z | 2024-11-03T14:20:40.571Z |
5448453 | 5448453 | 20241031133320_jp9uX | NZ003U | 2024-11-02T12:10:47.520Z | 2024-11-03T14:20:37.922Z |
5448163 | 5448163 | 20241031125019_qm2z0 | NZ003U | 2024-11-02T12:10:08.542Z | 2024-11-03T14:20:33.753Z |
5447940 | 5447940 | 20241031122450_IWZDt | NZ003U | 2024-11-02T12:09:28.237Z | 2024-11-03T14:20:30.620Z |
5447903 | 5447903 | 20241031122208_lQ4f3 | NZ003U | 2024-11-02T12:09:24.583Z | 2024-11-03T14:20:30.115Z |
5438028 | 5438028 | 20241030161534_AGtke | NZ003U | 2024-11-01T12:10:52.873Z | 2024-11-03T14:22:41.261Z |
5437949 | 5437949 | 20241030160504_T8048 | NZ003U | 2024-11-01T12:10:45.509Z | 2024-11-03T14:22:41.046Z |
5437935 | 5437935 | 20241030160400_pGTaU | NZ003U | 2024-11-01T12:10:44.461Z | 2024-11-03T14:22:40.999Z |
5437812 | 5437812 | 20241030154626_Uv7vs | NZ003U | 2024-11-01T12:10:23.332Z | 2024-11-03T14:22:40.637Z |
5437779 | 5437779 | 20241030154202_ULyY3 | NZ003U | 2024-11-01T12:10:18.731Z | 2024-11-03T14:22:40.563Z |
5437767 | 5437767 | 20241030154044_mv4tn | NZ003U | 2024-11-01T12:10:17.905Z | 2024-11-03T14:22:40.494Z |
5437677 | 5437677 | 20241030153430_QBg4y | NZ003U | 2024-11-01T12:10:11.114Z | 2024-11-03T14:22:40.273Z |
5437654 | 5437654 | 20241030153222_PTpzY | NZ003U | 2024-11-01T12:10:09.360Z | 2024-11-03T14:22:40.224Z |
5437629 | 5437629 | 20241030153033_iP6AR | NZ003U | 2024-11-01T12:10:07.321Z | 2024-11-03T14:22:40.164Z |
5437516 | 5437516 | 20241030151630_sxkLh | NZ003U | 2024-11-01T12:09:56.402Z | 2024-11-03T14:22:39.805Z |
5437495 | 5437495 | 20241030151341_FG0ru | NZ003U | 2024-11-01T12:09:53.376Z | 2024-11-03T14:22:39.751Z |
5437318 | 5437318 | 20241030145423_iFiT4 | NZ003U | 2024-11-01T12:09:23.882Z | 2024-11-03T14:22:39.152Z |
5437280 | 5437280 | 20241030144948_jLusP | NZ003U | 2024-11-01T12:09:19.920Z | 2024-11-03T14:22:39.032Z |
5437257 | 5437257 | 20241030144829_3GR96 | NZ003U | 2024-11-01T12:09:18.164Z | 2024-11-03T14:22:38.949Z |
5437231 | 5437231 | 20241030144516_ogOC3 | NZ003U | 2024-11-01T12:09:16.350Z | 2024-11-03T14:22:38.930Z |
5437193 | 5437193 | 20241030143958_n2g2p | NZ003U | 2024-11-01T12:09:13.311Z | 2024-11-03T14:22:38.857Z |
5437176 | 5437176 | 20241030143636_AKvTU | NZ003U | 2024-11-01T12:09:12.012Z | 2024-11-03T14:22:38.813Z |
5437103 | 5437103 | 20241030142846_UfRSk | NZ003U | 2024-11-01T12:08:55.084Z | 2024-11-03T14:22:38.575Z |
5437073 | 5437073 | 20241030142516_Wm4pW | NZ003U | 2024-11-01T12:08:49.858Z | 2024-11-03T14:22:38.500Z |
5437054 | 5437054 | 20241030142343_HvFjY | NZ003U | 2024-11-01T12:08:48.570Z | 2024-11-03T14:22:38.458Z |
5437022 | 5437022 | 20241030142120_aKiBv | NZ003U | 2024-11-01T12:08:45.397Z | 2024-11-03T14:22:38.356Z |
5437009 | 5437009 | 20241030141801_vlBhe | NZ003U | 2024-11-01T12:08:42.847Z | 2024-11-03T14:22:38.270Z |
5437004 | 5437004 | 20241030141717_5AeHW | NZ003U | 2024-11-01T12:08:42.139Z | 2024-11-03T14:22:38.267Z |
5437001 | 5437001 | 20241030141649_LbmGP | NZ003U | 2024-11-01T12:08:41.632Z | 2024-11-03T14:22:38.263Z |
5436964 | 5436964 | 20241030141127_bsknh | NZ003U | 2024-11-01T12:08:38.337Z | 2024-11-03T14:22:38.159Z |
5436936 | 5436936 | 20241030140712_4BmZ2 | NZ003U | 2024-11-01T12:08:36.315Z | 2024-11-03T14:22:38.102Z |
5436664 | 5436664 | 20241030133322_cLSC2 | NZ003U | 2024-11-01T12:08:01.943Z | 2024-11-03T14:22:37.414Z |
5436649 | 5436649 | 20241030133058_yE1v3 | NZ003U | 2024-11-01T12:08:01.063Z | 2024-11-03T14:22:37.394Z |
5436622 | 5436622 | 20241030132835_J5EcE | NZ003U | 2024-11-01T12:07:58.608Z | 2024-11-03T14:22:37.296Z |
5436584 | 5436584 | 20241030132411_njlR2 | NZ003U | 2024-11-01T12:07:55.374Z | 2024-11-03T14:22:37.146Z |
5436405 | 5436405 | 20241030130200_9zRTQ | NZ003U | 2024-11-01T12:07:29.156Z | 2024-11-03T14:22:36.506Z |
5436378 | 5436378 | 20241030125843_TreLy | NZ003U | 2024-11-01T12:07:24.621Z | 2024-11-03T14:22:36.384Z |
5436289 | 5436289 | 20241030124645_8xLon | NZ003U | 2024-11-01T12:07:14.113Z | 2024-11-03T14:22:36.141Z |
5436237 | 5436237 | 20241030124129_VDROF | NZ003U | 2024-11-01T12:07:09.651Z | 2024-11-03T14:22:35.973Z |
5435954 | 5435954 | 20241030121314_zcPFi | NZ003U | 2024-11-01T12:06:26.083Z | 2024-11-03T14:22:34.656Z |
5435844 | 5435844 | 20241030120304_nyexi | NZ003U | 2024-11-01T12:06:03.653Z | 2024-11-03T14:22:34.295Z |
5435813 | 5435813 | 20241030115901_YoPJJ | NZ003U | 2024-11-01T12:05:57.794Z | 2024-11-03T14:22:34.119Z |
5435334 | 5435334 | 20241030111851_Becwl | NZ003U | 2024-11-01T12:04:56.043Z | 2024-11-03T14:22:32.110Z |
5435250 | 5435250 | 20241030110852_wgQjd | NZ003U | 2024-11-01T12:04:35.896Z | 2024-11-03T14:22:31.666Z |
5435088 | 5435088 | 20241030104905_rdolS | NZ003U | 2024-11-01T12:04:17.033Z | 2024-11-03T14:22:29.599Z |
5435030 | 5435030 | 20241030104035_I8T2t | NZ003U | 2024-11-01T12:04:00.991Z | 2024-11-03T14:22:28.696Z |
5434820 | 5434820 | 20241030101715_E9s8P | NZ003U | 2024-11-01T12:03:28.921Z | 2024-11-03T14:22:26.455Z |
5434812 | 5434812 | 20241030101539_5pN3A | NZ003U | 2024-11-01T12:03:27.482Z | 2024-11-03T14:22:26.436Z |
5434704 | 5434704 | 20241030100441_3sOi9 | NZ003U | 2024-11-01T12:03:11.257Z | 2024-11-03T14:22:25.617Z |
5427558 | 5427558 | 20241028151713_RurLq | NZ003U | 2024-10-31T12:13:37.891Z | 2024-11-03T14:24:48.019Z |
5427421 | 5427421 | 20241028150404_5pzQb | NZ003U | 2024-10-31T12:13:31.258Z | 2024-11-03T14:24:47.649Z |
5427371 | 5427371 | 20241028150039_22Go2 | NZ003U | 2024-10-31T12:13:28.847Z | 2024-11-03T14:24:47.583Z |
5427317 | 5427317 | 20241028145650_8g3n0 | NZ003U | 2024-10-31T12:13:25.961Z | 2024-11-03T14:24:46.574Z |
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);