participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,496 rows where station_code = "NZ003C" 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 |
---|---|---|---|---|---|
5567097 | 5567097 | 20241121092123_41y2x | NZ003C | 2024-11-22T14:05:12.094Z | 2024-11-22T14:05:12.094Z |
5560837 | 5560837 | 20241120143922_WKJx4 | NZ003C | 2024-11-21T14:09:50.073Z | 2024-11-22T14:19:21.742Z |
5560743 | 5560743 | 20241120141154_EFs2v | NZ003C | 2024-11-21T14:09:41.355Z | 2024-11-22T14:19:21.725Z |
5560694 | 5560694 | 20241120135703_snFZQ | NZ003C | 2024-11-21T14:09:29.009Z | 2024-11-22T14:19:21.714Z |
5560688 | 5560688 | 20241120135605_EmGor | NZ003C | 2024-11-21T14:09:26.679Z | 2024-11-22T14:19:21.713Z |
5556228 | 5556228 | 20241118102852_v73to | NZ003C | 2024-11-20T14:08:29.001Z | 2024-11-22T14:22:03.412Z |
5554776 | 5554776 | 20241119103524_uON0m | NZ003C | 2024-11-20T14:03:15.535Z | 2024-11-22T14:19:51.242Z |
5551826 | 5551826 | 20241118152110_dEM2t | NZ003C | 2024-11-19T14:05:39.931Z | 2024-11-22T14:22:12.637Z |
5551791 | 5551791 | 20241118151432_IHua1 | NZ003C | 2024-11-19T14:05:31.656Z | 2024-11-22T14:22:12.508Z |
5551708 | 5551708 | 20241118145211_V9u91 | NZ003C | 2024-11-19T14:05:16.514Z | 2024-11-22T14:22:12.210Z |
5551591 | 5551591 | 20241118142206_85PJn | NZ003C | 2024-11-19T14:05:02.272Z | 2024-11-22T14:22:11.539Z |
5551574 | 5551574 | 20241118141739_7tz31 | NZ003C | 2024-11-19T14:05:00.327Z | 2024-11-22T14:22:11.463Z |
5551572 | 5551572 | 20241118141531_GgzKl | NZ003C | 2024-11-19T14:05:00.156Z | 2024-11-22T14:22:11.446Z |
5551564 | 5551564 | 20241118141320_i317e | NZ003C | 2024-11-19T14:04:59.775Z | 2024-11-22T14:22:11.429Z |
5551547 | 5551547 | 20241118141129_OEUxh | NZ003C | 2024-11-19T14:04:58.939Z | 2024-11-22T14:22:11.383Z |
5551511 | 5551511 | 20241118140432_FBORW | NZ003C | 2024-11-19T14:04:55.775Z | 2024-11-22T14:22:11.183Z |
5551504 | 5551504 | 20241118140043_rYtXK | NZ003C | 2024-11-19T14:04:54.643Z | 2024-11-22T14:22:11.122Z |
5551475 | 5551475 | 20241118135042_jz1ae | NZ003C | 2024-11-19T14:04:51.247Z | 2024-11-22T14:22:10.917Z |
5551248 | 5551248 | 20241118125005_eiqkJ | NZ003C | 2024-11-19T14:04:10.175Z | 2024-11-22T14:22:09.444Z |
5551062 | 5551062 | 20241118121714_KRWPs | NZ003C | 2024-11-19T14:03:51.168Z | 2024-11-22T14:22:07.979Z |
5550664 | 5550664 | 20241118110455_8wdg2 | NZ003C | 2024-11-19T14:02:53.644Z | 2024-11-22T14:22:04.764Z |
5550228 | 5550228 | 20241118094956_i19TH | NZ003C | 2024-11-19T14:01:51.028Z | 2024-11-22T14:22:00.048Z |
5550154 | 5550154 | 20241118094012_h5T7l | NZ003C | 2024-11-19T14:01:39.584Z | 2024-11-22T14:21:59.005Z |
5550094 | 5550094 | 20241118092953_jyICJ | NZ003C | 2024-11-19T14:01:34.256Z | 2024-11-22T14:21:58.100Z |
5549951 | 5549951 | 20241118085535_WdKvc | NZ003C | 2024-11-19T14:01:20.920Z | 2024-11-22T14:21:55.676Z |
5549930 | 5549930 | 20241118084623_g5CCF | NZ003C | 2024-11-19T14:01:15.399Z | 2024-11-22T14:21:55.271Z |
5549902 | 5549902 | 20241118083631_rm2PU | NZ003C | 2024-11-19T14:01:11.401Z | 2024-11-22T14:21:54.848Z |
5547019 | 5547019 | 20241117141443_RmsoX | NZ003C | 2024-11-18T14:04:42.697Z | 2024-11-22T14:22:36.431Z |
5546991 | 5546991 | 20241117140226_Q4Qbh | NZ003C | 2024-11-18T14:04:39.998Z | 2024-11-22T14:22:36.261Z |
5546790 | 5546790 | 20241117124327_Of13k | NZ003C | 2024-11-18T14:04:14.272Z | 2024-11-22T14:22:34.635Z |
5546773 | 5546773 | 20241117124113_iD1Hv | NZ003C | 2024-11-18T14:04:12.754Z | 2024-11-22T14:22:34.583Z |
5546499 | 5546499 | 20241117111701_zQgOL | NZ003C | 2024-11-18T14:03:13.910Z | 2024-11-22T14:22:32.295Z |
5546428 | 5546428 | 20241117105532_34pqK | NZ003C | 2024-11-18T14:03:05.836Z | 2024-11-22T14:22:31.959Z |
5546324 | 5546324 | 20241117102524_6Fjxz | NZ003C | 2024-11-18T14:02:50.683Z | 2024-11-22T14:22:31.116Z |
5546315 | 5546315 | 20241117102331_kmYqw | NZ003C | 2024-11-18T14:02:50.257Z | 2024-11-22T14:22:31.115Z |
5544516 | 5544516 | 20241116120543_I8nVV | NZ003C | 2024-11-17T14:01:23.370Z | 2024-11-22T14:23:03.793Z |
5544468 | 5544468 | 20241116113017_o7O3d | NZ003C | 2024-11-17T14:01:15.000Z | 2024-11-22T14:23:03.167Z |
5544460 | 5544460 | 20241116112651_k3jiD | NZ003C | 2024-11-17T14:01:13.664Z | 2024-11-22T14:23:03.002Z |
5544456 | 5544456 | 20241116112208_gnFYS | NZ003C | 2024-11-17T14:01:12.917Z | 2024-11-22T14:23:02.948Z |
5544289 | 5544289 | 20241116093559_307MA | NZ003C | 2024-11-17T14:00:46.117Z | 2024-11-22T14:23:01.349Z |
5544241 | 5544241 | 20241116090626_kz0XL | NZ003C | 2024-11-17T14:00:35.227Z | 2024-11-22T14:23:00.900Z |
5542782 | 5542782 | 20241115122911_Xed2i | NZ003C | 2024-11-16T14:02:33.002Z | 2024-11-22T14:23:31.070Z |
5542560 | 5542560 | 20241115105557_BhC1m | NZ003C | 2024-11-16T14:01:47.366Z | 2024-11-22T14:23:27.927Z |
5542528 | 5542528 | 20241115104157_Yi4f8 | NZ003C | 2024-11-16T14:01:36.927Z | 2024-11-22T14:23:27.047Z |
5542092 | 5542092 | 20241108114255_2lJwc | NZ003C | 2024-11-15T14:22:27.468Z | 2024-11-17T14:23:08.266Z |
5542090 | 5542090 | 20241108111325_HeTMF | NZ003C | 2024-11-15T14:22:26.240Z | 2024-11-17T14:23:06.357Z |
5508628 | 5508628 | 20241108152824_EKYf1 | NZ003C | 2024-11-10T14:10:39.780Z | 2024-11-17T14:23:22.141Z |
5500344 | 5500344 | 20241108152312_ZOpoE | NZ003C | 2024-11-09T14:06:09.158Z | 2024-11-17T14:23:21.838Z |
5500254 | 5500254 | 20241108150907_03g2T | NZ003C | 2024-11-09T14:06:01.542Z | 2024-11-17T14:23:20.890Z |
5500031 | 5500031 | 20241108142906_DTiHO | NZ003C | 2024-11-09T14:05:32.527Z | 2024-11-17T14:23:18.118Z |
5499952 | 5499952 | 20241108141235_MNT03 | NZ003C | 2024-11-09T14:05:23.468Z | 2024-11-17T14:23:17.535Z |
5499668 | 5499668 | 20241108125452_hC3R8 | NZ003C | 2024-11-09T14:04:41.651Z | 2024-11-17T14:23:14.343Z |
5499649 | 5499649 | 20241108125026_4s2MQ | NZ003C | 2024-11-09T14:04:33.431Z | 2024-11-17T14:23:14.070Z |
5499582 | 5499582 | 20241108123918_lUqYP | NZ003C | 2024-11-09T14:04:22.565Z | 2024-11-17T14:23:13.362Z |
5499546 | 5499546 | 20241108123424_5TfK8 | NZ003C | 2024-11-09T14:04:17.539Z | 2024-11-17T14:23:12.792Z |
5499463 | 5499463 | 20241108122240_Y3Mhs | NZ003C | 2024-11-09T14:04:08.827Z | 2024-11-17T14:23:11.750Z |
5499279 | 5499279 | 20241108114928_87c8M | NZ003C | 2024-11-09T14:03:41.137Z | 2024-11-17T14:23:08.643Z |
5499219 | 5499219 | 20241108113637_GM2Qs | NZ003C | 2024-11-09T14:03:33.687Z | 2024-11-17T14:23:07.838Z |
5499179 | 5499179 | 20241108112514_rmHg9 | NZ003C | 2024-11-09T14:03:29.404Z | 2024-11-17T14:23:07.487Z |
5499135 | 5499135 | 20241108111703_6Dq8T | NZ003C | 2024-11-09T14:03:22.660Z | 2024-11-17T14:23:06.486Z |
5499090 | 5499090 | 20241108110524_xxaKd | NZ003C | 2024-11-09T14:03:08.369Z | 2024-11-17T14:23:05.980Z |
5499072 | 5499072 | 20241108105934_9ctJW | NZ003C | 2024-11-09T14:03:05.647Z | 2024-11-17T14:23:04.839Z |
5499018 | 5499018 | 20241108104555_zzWzi | NZ003C | 2024-11-09T14:02:59.695Z | 2024-11-17T14:23:03.848Z |
5493899 | 5493899 | 20241107143024_ljPN5 | NZ003C | 2024-11-08T14:04:50.560Z | 2024-11-16T14:27:42.918Z |
5493880 | 5493880 | 20241107142446_3PU92 | NZ003C | 2024-11-08T14:04:48.664Z | 2024-11-16T14:27:42.765Z |
5493858 | 5493858 | 20241107142121_xGTUe | NZ003C | 2024-11-08T14:04:46.708Z | 2024-11-16T14:27:42.623Z |
5493847 | 5493847 | 20241107141126_r4hYU | NZ003C | 2024-11-08T14:04:44.187Z | 2024-11-16T14:27:42.232Z |
5493841 | 5493841 | 20241107140626_w9hzV | NZ003C | 2024-11-08T14:04:43.362Z | 2024-11-16T14:27:42.183Z |
5493823 | 5493823 | 20241107135756_X59io | NZ003C | 2024-11-08T14:04:41.924Z | 2024-11-16T14:27:41.729Z |
5493815 | 5493815 | 20241107135639_xYfv2 | NZ003C | 2024-11-08T14:04:41.412Z | 2024-11-16T14:27:41.709Z |
5493803 | 5493803 | 20241107135243_DDGYb | NZ003C | 2024-11-08T14:04:40.453Z | 2024-11-16T14:27:41.588Z |
5493780 | 5493780 | 20241107134149_3Hw7o | NZ003C | 2024-11-08T14:04:38.260Z | 2024-11-16T14:27:40.938Z |
5493774 | 5493774 | 20241107133515_8sKVz | NZ003C | 2024-11-08T14:04:37.702Z | 2024-11-16T14:27:40.924Z |
5493746 | 5493746 | 20241107131639_OTlai | NZ003C | 2024-11-08T14:04:34.081Z | 2024-11-16T14:27:40.027Z |
5493741 | 5493741 | 20241107131353_yQlru | NZ003C | 2024-11-08T14:04:33.523Z | 2024-11-16T14:27:39.730Z |
5493735 | 5493735 | 20241107131308_oAVCZ | NZ003C | 2024-11-08T14:04:33.062Z | 2024-11-16T14:27:39.684Z |
5493708 | 5493708 | 20241107130902_TTqu8 | NZ003C | 2024-11-08T14:04:30.948Z | 2024-11-16T14:27:39.411Z |
5493646 | 5493646 | 20241107125336_eQd38 | NZ003C | 2024-11-08T14:04:25.280Z | 2024-11-16T14:27:37.958Z |
5493619 | 5493619 | 20241107124519_TCYj7 | NZ003C | 2024-11-08T14:04:19.040Z | 2024-11-16T14:27:37.453Z |
5493579 | 5493579 | 20241107123913_Qxxoy | NZ003C | 2024-11-08T14:04:09.433Z | 2024-11-16T14:27:36.297Z |
5493571 | 5493571 | 20241107123745_eNoaF | NZ003C | 2024-11-08T14:04:06.994Z | 2024-11-16T14:27:36.291Z |
5493551 | 5493551 | 20241107123239_3ZvT2 | NZ003C | 2024-11-08T14:04:02.840Z | 2024-11-16T14:27:35.767Z |
5493470 | 5493470 | 20241107121850_vd9uu | NZ003C | 2024-11-08T14:03:50.820Z | 2024-11-16T14:27:34.629Z |
5493401 | 5493401 | 20241107120453_EAwTH | NZ003C | 2024-11-08T14:03:41.757Z | 2024-11-16T14:27:34.036Z |
5493380 | 5493380 | 20241107120048_XXpGm | NZ003C | 2024-11-08T14:03:39.375Z | 2024-11-16T14:27:33.881Z |
5493363 | 5493363 | 20241107115510_Vq9oI | NZ003C | 2024-11-08T14:03:37.318Z | 2024-11-16T14:27:33.806Z |
5493333 | 5493333 | 20241107115014_2xItF | NZ003C | 2024-11-08T14:03:34.340Z | 2024-11-16T14:27:33.593Z |
5493323 | 5493323 | 20241107114809_3I9rm | NZ003C | 2024-11-08T14:03:33.169Z | 2024-11-16T14:27:33.498Z |
5493263 | 5493263 | 20241107112923_m931v | NZ003C | 2024-11-08T14:03:22.770Z | 2024-11-16T14:27:33.210Z |
5493224 | 5493224 | 20241107111920_F2lTS | NZ003C | 2024-11-08T14:03:12.116Z | 2024-11-16T14:27:33.061Z |
5493148 | 5493148 | 20241107110626_Dq5W3 | NZ003C | 2024-11-08T14:02:58.114Z | 2024-11-16T14:27:32.340Z |
5492966 | 5492966 | 20241107102647_LAiPS | NZ003C | 2024-11-08T14:02:38.774Z | 2024-11-16T14:27:31.202Z |
5492941 | 5492941 | 20241107102256_8V8Nn | NZ003C | 2024-11-08T14:02:36.552Z | 2024-11-16T14:27:31.114Z |
5492754 | 5492754 | 20241107095053_YkFRX | NZ003C | 2024-11-08T14:02:02.065Z | 2024-11-16T14:27:28.621Z |
5492726 | 5492726 | 20241107094247_nA9PE | NZ003C | 2024-11-08T14:01:58.530Z | 2024-11-16T14:27:27.822Z |
5492565 | 5492565 | 20241107090310_bxEFY | NZ003C | 2024-11-08T14:01:26.267Z | 2024-11-16T14:27:26.843Z |
5474080 | 5474080 | 20241103154921_dE1uM | NZ003C | 2024-11-05T14:10:07.197Z | 2024-11-12T14:27:50.503Z |
5474065 | 5474065 | 20241103154725_jIB17 | NZ003C | 2024-11-05T14:10:05.192Z | 2024-11-12T14:27:50.496Z |
5474026 | 5474026 | 20241103154102_H2YUe | NZ003C | 2024-11-05T14:10:01.169Z | 2024-11-12T14:27:50.453Z |
5474021 | 5474021 | 20241103153856_A1Yn5 | NZ003C | 2024-11-05T14:10:00.722Z | 2024-11-12T14:27:50.451Z |
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);