participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
884 rows where station_code = "NZ001S" 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 |
---|---|---|---|---|---|
5569492 | 5569492 | 20241121154244_2h3ZG | NZ001S | 2024-11-22T14:10:59.035Z | 2024-11-22T14:10:59.035Z |
5569307 | 5569307 | 20241121150721_35VJl | NZ001S | 2024-11-22T14:10:44.860Z | 2024-11-22T14:10:44.860Z |
5569133 | 5569133 | 20241121144015_IjYio | NZ001S | 2024-11-22T14:10:23.278Z | 2024-11-22T14:10:23.278Z |
5569110 | 5569110 | 20241121143730_tktJQ | NZ001S | 2024-11-22T14:10:21.876Z | 2024-11-22T14:10:21.876Z |
5568949 | 5568949 | 20241121140847_06H1G | NZ001S | 2024-11-22T14:10:06.520Z | 2024-11-22T14:10:06.520Z |
5568791 | 5568791 | 20241121133723_IVMR2 | NZ001S | 2024-11-22T14:09:43.073Z | 2024-11-22T14:09:43.073Z |
5568708 | 5568708 | 20241121132537_Z28dh | NZ001S | 2024-11-22T14:09:35.999Z | 2024-11-22T14:09:35.999Z |
5568678 | 5568678 | 20241121132041_ZgUGv | NZ001S | 2024-11-22T14:09:33.069Z | 2024-11-22T14:09:33.069Z |
5568485 | 5568485 | 20241121125215_LEddo | NZ001S | 2024-11-22T14:09:04.254Z | 2024-11-22T14:09:04.254Z |
5568460 | 5568460 | 20241121124933_W1JEB | NZ001S | 2024-11-22T14:09:00.271Z | 2024-11-22T14:09:00.271Z |
5568393 | 5568393 | 20241121123837_8nKM2 | NZ001S | 2024-11-22T14:08:51.316Z | 2024-11-22T14:08:51.316Z |
5568282 | 5568282 | 20241121121825_t77EO | NZ001S | 2024-11-22T14:08:38.500Z | 2024-11-22T14:08:38.500Z |
5568189 | 5568189 | 20241121120421_JmYcd | NZ001S | 2024-11-22T14:08:23.640Z | 2024-11-22T14:08:23.640Z |
5568143 | 5568143 | 20241121115527_hBX1A | NZ001S | 2024-11-22T14:08:12.889Z | 2024-11-22T14:08:12.889Z |
5567938 | 5567938 | 20241121113346_D0iWc | NZ001S | 2024-11-22T14:07:49.881Z | 2024-11-22T14:07:49.881Z |
5567769 | 5567769 | 20241121110412_Jt2DF | NZ001S | 2024-11-22T14:07:14.285Z | 2024-11-22T14:07:14.285Z |
5567311 | 5567311 | 20241121100136_wufaw | NZ001S | 2024-11-22T14:05:51.923Z | 2024-11-22T14:05:51.923Z |
5560733 | 5560733 | 20241120141038_EnfFM | NZ001S | 2024-11-21T14:09:40.146Z | 2024-11-22T14:19:21.723Z |
5560695 | 5560695 | 20241120135715_9aBN6 | NZ001S | 2024-11-21T14:09:29.674Z | 2024-11-22T14:19:21.715Z |
5560664 | 5560664 | 20241120135026_peJ6I | NZ001S | 2024-11-21T14:09:22.889Z | 2024-11-22T14:19:21.708Z |
5560619 | 5560619 | 20241120132710_OPo21 | NZ001S | 2024-11-21T14:09:16.280Z | 2024-11-22T14:19:21.698Z |
5560562 | 5560562 | 20241120131006_b0cPw | NZ001S | 2024-11-21T14:09:06.028Z | 2024-11-22T14:19:21.685Z |
5560025 | 5560025 | 20241120114742_wdfHn | NZ001S | 2024-11-21T14:07:53.592Z | 2024-11-22T14:19:21.571Z |
5559946 | 5559946 | 20241120113720_N9vjx | NZ001S | 2024-11-21T14:07:38.794Z | 2024-11-22T14:19:21.555Z |
5559829 | 5559829 | 20241120112221_veMFv | NZ001S | 2024-11-21T14:07:17.907Z | 2024-11-22T14:19:21.533Z |
5559279 | 5559279 | 20241120095431_v96xB | NZ001S | 2024-11-21T14:05:49.508Z | 2024-11-22T14:19:21.405Z |
5555642 | 5555642 | 20241119142004_3HKcU | NZ001S | 2024-11-20T14:06:13.370Z | 2024-11-22T14:20:11.532Z |
5555534 | 5555534 | 20241119134340_znhAf | NZ001S | 2024-11-20T14:05:56.029Z | 2024-11-22T14:20:09.162Z |
5555410 | 5555410 | 20241119130630_OAiyo | NZ001S | 2024-11-20T14:05:34.374Z | 2024-11-22T14:20:05.577Z |
5555364 | 5555364 | 20241119125552_k8Fjn | NZ001S | 2024-11-20T14:05:17.560Z | 2024-11-22T14:20:04.768Z |
5555301 | 5555301 | 20241119123814_v37Vn | NZ001S | 2024-11-20T14:05:07.895Z | 2024-11-22T14:20:03.491Z |
5555261 | 5555261 | 20241119122604_eWQ2D | NZ001S | 2024-11-20T14:05:02.536Z | 2024-11-22T14:20:02.511Z |
5554541 | 5554541 | 20241119093047_Qzjbm | NZ001S | 2024-11-20T14:02:24.899Z | 2024-11-22T14:19:43.225Z |
5551939 | 5551939 | 20241118155302_zNm5d | NZ001S | 2024-11-19T14:05:49.728Z | 2024-11-22T14:22:13.121Z |
5551760 | 5551760 | 20241118150653_Lbn03 | NZ001S | 2024-11-19T14:05:26.458Z | 2024-11-22T14:22:12.421Z |
5551736 | 5551736 | 20241118145842_pTgjK | NZ001S | 2024-11-19T14:05:22.406Z | 2024-11-22T14:22:12.344Z |
5551726 | 5551726 | 20241118145718_LDCAC | NZ001S | 2024-11-19T14:05:21.748Z | 2024-11-22T14:22:12.324Z |
5551623 | 5551623 | 20241118142927_87uVz | NZ001S | 2024-11-19T14:05:05.753Z | 2024-11-22T14:22:11.795Z |
5551614 | 5551614 | 20241118142826_Br9QL | NZ001S | 2024-11-19T14:05:05.025Z | 2024-11-22T14:22:11.720Z |
5551451 | 5551451 | 20241118134030_DVncd | NZ001S | 2024-11-19T14:04:48.536Z | 2024-11-22T14:22:10.767Z |
5551160 | 5551160 | 20241118123608_OQ4z1 | NZ001S | 2024-11-19T14:04:00.660Z | 2024-11-22T14:22:08.790Z |
5550873 | 5550873 | 20241118114029_81Yom | NZ001S | 2024-11-19T14:03:16.664Z | 2024-11-22T14:22:06.380Z |
5550852 | 5550852 | 20241118113642_myxj2 | NZ001S | 2024-11-19T14:03:12.823Z | 2024-11-22T14:22:06.193Z |
5550694 | 5550694 | 20241118111102_EJE36 | NZ001S | 2024-11-19T14:02:55.991Z | 2024-11-22T14:22:04.889Z |
5550410 | 5550410 | 20241118101750_72uPF | NZ001S | 2024-11-19T14:02:18.662Z | 2024-11-22T14:22:02.783Z |
5550097 | 5550097 | 20241118093004_OvQgg | NZ001S | 2024-11-19T14:01:34.467Z | 2024-11-22T14:21:58.122Z |
5550071 | 5550071 | 20241118092716_3SVFx | NZ001S | 2024-11-19T14:01:32.708Z | 2024-11-22T14:21:57.798Z |
5549991 | 5549991 | 20241118090428_JInYS | NZ001S | 2024-11-19T14:01:25.343Z | 2024-11-22T14:21:56.540Z |
5547216 | 5547216 | 20241117150813_4jD5R | NZ001S | 2024-11-18T14:05:17.471Z | 2024-11-22T14:22:38.042Z |
5547073 | 5547073 | 20241117143540_pL5f2 | NZ001S | 2024-11-18T14:04:54.052Z | 2024-11-22T14:22:36.645Z |
5546735 | 5546735 | 20241117123141_X0Lhx | NZ001S | 2024-11-18T14:04:04.549Z | 2024-11-22T14:22:34.317Z |
5546649 | 5546649 | 20241117120606_H3j5B | NZ001S | 2024-11-18T14:03:44.301Z | 2024-11-22T14:22:33.651Z |
5546610 | 5546610 | 20241117115435_w323H | NZ001S | 2024-11-18T14:03:39.321Z | 2024-11-22T14:22:33.402Z |
5544644 | 5544644 | 20241116134312_8UHVL | NZ001S | 2024-11-17T14:01:45.239Z | 2024-11-22T14:23:05.214Z |
5544564 | 5544564 | 20241116123400_4q2tW | NZ001S | 2024-11-17T14:01:34.441Z | 2024-11-22T14:23:04.378Z |
5534277 | 5534277 | 20241113113214_uGMwu | NZ001S | 2024-11-14T14:04:01.477Z | 2024-11-22T14:24:13.257Z |
5520396 | 5520396 | 20241111153507_qrpT9 | NZ001S | 2024-11-12T14:06:15.585Z | 2024-11-20T14:25:07.881Z |
5520379 | 5520379 | 20241111153227_ASotO | NZ001S | 2024-11-12T14:06:14.489Z | 2024-11-20T14:25:07.720Z |
5520021 | 5520021 | 20241111142124_KaSDz | NZ001S | 2024-11-12T14:05:29.022Z | 2024-11-20T14:25:02.435Z |
5519986 | 5519986 | 20241111141115_R2WrB | NZ001S | 2024-11-12T14:05:25.452Z | 2024-11-20T14:25:01.402Z |
5519942 | 5519942 | 20241111140153_Q89JE | NZ001S | 2024-11-12T14:05:21.554Z | 2024-11-20T14:25:00.958Z |
5519920 | 5519920 | 20241111135445_aq81s | NZ001S | 2024-11-12T14:05:19.526Z | 2024-11-20T14:25:00.636Z |
5519856 | 5519856 | 20241111133525_l6MuI | NZ001S | 2024-11-12T14:05:11.749Z | 2024-11-20T14:24:59.973Z |
5519807 | 5519807 | 20241111130914_aILnI | NZ001S | 2024-11-12T14:05:03.966Z | 2024-11-20T14:24:58.173Z |
5519702 | 5519702 | 20241111123515_5hTgQ | NZ001S | 2024-11-12T14:04:47.960Z | 2024-11-20T14:24:55.695Z |
5519510 | 5519510 | 20241111114233_10yft | NZ001S | 2024-11-12T14:04:19.566Z | 2024-11-20T14:24:51.451Z |
5519428 | 5519428 | 20241111112139_9mXEi | NZ001S | 2024-11-12T14:03:59.402Z | 2024-11-20T14:24:50.137Z |
5519184 | 5519184 | 20241111103545_XJquG | NZ001S | 2024-11-12T14:03:16.963Z | 2024-11-20T14:24:46.342Z |
5514276 | 5514276 | 20241110152247_hN5y2 | NZ001S | 2024-11-11T14:06:25.411Z | 2024-11-19T14:21:45.664Z |
5514112 | 5514112 | 20241110143117_W3DZk | NZ001S | 2024-11-11T14:06:13.286Z | 2024-11-19T14:21:43.683Z |
5500430 | 5500430 | 20241108154211_Qsq2K | NZ001S | 2024-11-09T14:06:16.385Z | 2024-11-17T14:23:22.570Z |
5500356 | 5500356 | 20241108152716_Cev36 | NZ001S | 2024-11-09T14:06:10.294Z | 2024-11-17T14:23:22.113Z |
5500181 | 5500181 | 20241108150158_fpfuz | NZ001S | 2024-11-09T14:05:57.571Z | 2024-11-17T14:23:20.048Z |
5500117 | 5500117 | 20241108144918_0y91A | NZ001S | 2024-11-09T14:05:44.106Z | 2024-11-17T14:23:19.404Z |
5499809 | 5499809 | 20241108133821_BAy7C | NZ001S | 2024-11-09T14:04:59.764Z | 2024-11-17T14:23:16.218Z |
5499794 | 5499794 | 20241108133225_cO0ki | NZ001S | 2024-11-09T14:04:58.537Z | 2024-11-17T14:23:16.158Z |
5499749 | 5499749 | 20241108131642_UiJIk | NZ001S | 2024-11-09T14:04:53.683Z | 2024-11-17T14:23:15.806Z |
5499731 | 5499731 | 20241108131500_3lHF2 | NZ001S | 2024-11-09T14:04:51.414Z | 2024-11-17T14:23:15.618Z |
5499708 | 5499708 | 20241108130525_F3eXJ | NZ001S | 2024-11-09T14:04:47.667Z | 2024-11-17T14:23:14.666Z |
5499584 | 5499584 | 20241108123926_2akGy | NZ001S | 2024-11-09T14:04:22.833Z | 2024-11-17T14:23:13.417Z |
5499557 | 5499557 | 20241108123652_JVpA8 | NZ001S | 2024-11-09T14:04:18.888Z | 2024-11-17T14:23:13.016Z |
5499382 | 5499382 | 20241108120921_bKimb | NZ001S | 2024-11-09T14:03:55.715Z | 2024-11-17T14:23:10.777Z |
5499356 | 5499356 | 20241108120420_WvJDr | NZ001S | 2024-11-09T14:03:50.103Z | 2024-11-17T14:23:10.003Z |
5499292 | 5499292 | 20241108115152_kkYj6 | NZ001S | 2024-11-09T14:03:42.211Z | 2024-11-17T14:23:09.022Z |
5499237 | 5499237 | 20241108114214_noYsZ | NZ001S | 2024-11-09T14:03:36.094Z | 2024-11-17T14:23:08.246Z |
5499168 | 5499168 | 20241108112218_GTogO | NZ001S | 2024-11-09T14:03:28.359Z | 2024-11-17T14:23:07.413Z |
5499142 | 5499142 | 20241108111749_ZTI7Q | NZ001S | 2024-11-09T14:03:25.158Z | 2024-11-17T14:23:06.753Z |
5498911 | 5498911 | 20241108102456_elzl2 | NZ001S | 2024-11-09T14:02:46.137Z | 2024-11-17T14:23:01.362Z |
5498681 | 5498681 | 20241108093624_mWOyR | NZ001S | 2024-11-09T14:02:11.010Z | 2024-11-17T14:22:58.890Z |
5494068 | 5494068 | 20241107152718_633ZG | NZ001S | 2024-11-08T14:05:19.808Z | 2024-11-16T14:27:46.257Z |
5494061 | 5494061 | 20241107152605_absGg | NZ001S | 2024-11-08T14:05:19.299Z | 2024-11-16T14:27:46.175Z |
5494050 | 5494050 | 20241107152259_WWIg8 | NZ001S | 2024-11-08T14:05:17.941Z | 2024-11-16T14:27:45.642Z |
5494035 | 5494035 | 20241107151729_NxERD | NZ001S | 2024-11-08T14:05:17.071Z | 2024-11-16T14:27:45.465Z |
5494025 | 5494025 | 20241107151435_LoSWl | NZ001S | 2024-11-08T14:05:16.403Z | 2024-11-16T14:27:45.392Z |
5493976 | 5493976 | 20241107145944_J7iDS | NZ001S | 2024-11-08T14:05:10.193Z | 2024-11-16T14:27:44.123Z |
5486883 | 5486883 | 20241106135131_DcwlZ | NZ001S | 2024-11-07T14:04:19.232Z | 2024-11-15T14:24:35.522Z |
5486308 | 5486308 | 20241106103731_u3T6Z | NZ001S | 2024-11-07T14:02:30.381Z | 2024-11-15T14:24:28.633Z |
5481229 | 5481229 | 20241104155215_gX7Kj | NZ001S | 2024-11-06T14:09:46.458Z | 2024-11-13T14:27:26.515Z |
5480618 | 5480618 | 20241105141823_w1lh1 | NZ001S | 2024-11-06T14:06:03.848Z | 2024-11-14T14:23:05.334Z |
5480539 | 5480539 | 20241105134020_i1G3X | NZ001S | 2024-11-06T14:05:53.410Z | 2024-11-14T14:23:04.752Z |
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);