participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,953 rows where station_code = "NZ001C" 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 |
---|---|---|---|---|---|
5131098 | 5131098 | 20240915174132_N7PyZ | NZ001C | 2024-09-19T12:14:21.363Z | 2024-09-19T12:14:21.363Z |
5130976 | 5130976 | 20240917171032_V7PTa | NZ001C | 2024-09-19T12:14:02.272Z | 2024-09-19T12:14:02.272Z |
5130512 | 5130512 | 20240917124002_730lH | NZ001C | 2024-09-19T12:13:29.823Z | 2024-09-19T12:13:29.823Z |
5130172 | 5130172 | 20240917095647_HIUkJ | NZ001C | 2024-09-19T12:12:42.786Z | 2024-09-19T12:12:42.786Z |
5123369 | 5123369 | 20240914095235_tIb6K | NZ001C | 2024-09-18T12:11:47.097Z | 2024-09-19T12:20:10.593Z |
5123181 | 5123181 | 20240914091327_ytjSO | NZ001C | 2024-09-18T12:11:41.846Z | 2024-09-19T12:20:08.859Z |
5122746 | 5122746 | 20240914074828_ed2p6 | NZ001C | 2024-09-18T12:11:30.069Z | 2024-09-19T12:20:05.947Z |
5068885 | 5068885 | 20240910125515_63LZ7 | NZ001C | 2024-09-14T12:19:22.593Z | 2024-09-18T12:15:26.784Z |
5068830 | 5068830 | 20240910123743_rwz3Q | NZ001C | 2024-09-14T12:19:21.855Z | 2024-09-18T12:15:26.722Z |
5068703 | 5068703 | 20240910120624_PFiJb | NZ001C | 2024-09-14T12:19:20.461Z | 2024-09-18T12:15:26.502Z |
5068688 | 5068688 | 20240910120545_36euH | NZ001C | 2024-09-14T12:19:20.363Z | 2024-09-18T12:15:26.498Z |
5068605 | 5068605 | 20240910115411_kUvSr | NZ001C | 2024-09-14T12:19:19.248Z | 2024-09-18T12:15:26.387Z |
5067215 | 5067215 | 20240910090748_0r1HX | NZ001C | 2024-09-14T12:18:35.979Z | 2024-09-18T12:15:23.601Z |
5062335 | 5062335 | 20240909171101_LB4gd | NZ001C | 2024-09-14T12:12:10.420Z | 2024-09-18T12:15:10.915Z |
5059388 | 5059388 | 20240910173600_w79g5 | NZ001C | 2024-09-14T12:05:50.227Z | 2024-09-19T12:21:30.711Z |
5059374 | 5059374 | 20240910173517_92TFQ | NZ001C | 2024-09-14T12:05:49.383Z | 2024-09-19T12:21:30.705Z |
5059336 | 5059336 | 20240910173245_2vcbr | NZ001C | 2024-09-14T12:05:46.653Z | 2024-09-19T12:21:30.643Z |
5059193 | 5059193 | 20240910172158_Kuytc | NZ001C | 2024-09-14T12:05:25.458Z | 2024-09-19T12:21:30.420Z |
5058970 | 5058970 | 20240910170532_1LBmk | NZ001C | 2024-09-14T12:05:02.916Z | 2024-09-19T12:21:30.283Z |
5058667 | 5058667 | 20240910163510_bjFr3 | NZ001C | 2024-09-14T12:04:17.671Z | 2024-09-19T12:21:29.811Z |
5058646 | 5058646 | 20240910163251_oH7O3 | NZ001C | 2024-09-14T12:04:15.002Z | 2024-09-19T12:21:29.800Z |
5058183 | 5058183 | 20240910155030_6JCIY | NZ001C | 2024-09-14T12:03:06.425Z | 2024-09-19T12:21:29.258Z |
5058161 | 5058161 | 20240910154900_Zxd4l | NZ001C | 2024-09-14T12:03:03.923Z | 2024-09-19T12:21:29.246Z |
5058055 | 5058055 | 20240910154011_2SsOi | NZ001C | 2024-09-14T12:02:44.337Z | 2024-09-19T12:21:29.059Z |
5057753 | 5057753 | 20240910151036_b9l26 | NZ001C | 2024-09-14T12:01:53.326Z | 2024-09-19T12:21:28.687Z |
5057260 | 5057260 | 20240910140606_Cr8vw | NZ001C | 2024-09-14T12:00:42.239Z | 2024-09-19T12:21:27.468Z |
5050481 | 5050481 | 20240907152440_OHZlX | NZ001C | 2024-09-13T12:13:33.174Z | 2024-09-16T12:20:57.811Z |
5050430 | 5050430 | 20240907152102_3Q2os | NZ001C | 2024-09-13T12:13:31.648Z | 2024-09-16T12:20:57.680Z |
5043220 | 5043220 | 20240907141011_JxAQb | NZ001C | 2024-09-12T12:17:25.362Z | 2024-09-16T12:20:55.917Z |
5042535 | 5042535 | 20240907115736_mx4CJ | NZ001C | 2024-09-12T12:17:14.836Z | 2024-09-16T12:20:53.555Z |
5017919 | 5017919 | 20240904165315_BRmTb | NZ001C | 2024-09-10T12:09:44.917Z | 2024-09-13T12:19:47.131Z |
5016809 | 5016809 | 20240904145827_BPdZE | NZ001C | 2024-09-10T12:08:19.937Z | 2024-09-13T12:19:46.333Z |
5016557 | 5016557 | 20240904142709_vcMEU | NZ001C | 2024-09-10T12:07:57.718Z | 2024-09-13T12:19:45.860Z |
5016489 | 5016489 | 20240904142034_cQg2e | NZ001C | 2024-09-10T12:07:53.375Z | 2024-09-13T12:19:45.821Z |
5016206 | 5016206 | 20240904134354_hBGSv | NZ001C | 2024-09-10T12:07:34.066Z | 2024-09-13T12:19:45.344Z |
5012067 | 5012067 | 20240904083507_P3Krd | NZ001C | 2024-09-09T12:10:19.976Z | 2024-09-12T12:19:34.651Z |
5011988 | 5011988 | 20240904082336_f9ZiS | NZ001C | 2024-09-09T12:10:13.492Z | 2024-09-12T12:19:34.445Z |
5006554 | 5006554 | 20240903175130_jlUE2 | NZ001C | 2024-09-09T12:04:45.782Z | 2024-09-12T12:19:08.736Z |
5006389 | 5006389 | 20240903173203_zOv8k | NZ001C | 2024-09-09T12:04:36.117Z | 2024-09-12T12:19:08.231Z |
5006179 | 5006179 | 20240903170313_9GbVA | NZ001C | 2024-09-09T12:04:23.683Z | 2024-09-12T12:19:07.742Z |
5006114 | 5006114 | 20240903165535_uB8uV | NZ001C | 2024-09-09T12:04:21.442Z | 2024-09-12T12:19:07.642Z |
5005877 | 5005877 | 20240903162535_2OhDd | NZ001C | 2024-09-09T12:04:10.680Z | 2024-09-12T12:19:06.978Z |
5005868 | 5005868 | 20240903162521_edVTp | NZ001C | 2024-09-09T12:04:10.494Z | 2024-09-12T12:19:06.975Z |
5005825 | 5005825 | 20240903161631_qjEr6 | NZ001C | 2024-09-09T12:04:08.708Z | 2024-09-12T12:19:06.947Z |
5005722 | 5005722 | 20240903160052_KGuBG | NZ001C | 2024-09-09T12:03:59.495Z | 2024-09-12T12:19:06.508Z |
5005663 | 5005663 | 20240903155212_CvVrc | NZ001C | 2024-09-09T12:03:53.803Z | 2024-09-12T12:19:06.387Z |
5005655 | 5005655 | 20240903155100_EiyRw | NZ001C | 2024-09-09T12:03:53.406Z | 2024-09-12T12:19:06.363Z |
5005599 | 5005599 | 20240903154144_ESN94 | NZ001C | 2024-09-09T12:03:50.713Z | 2024-09-12T12:19:06.241Z |
5005587 | 5005587 | 20240903154040_RH2Wt | NZ001C | 2024-09-09T12:03:50.070Z | 2024-09-12T12:19:06.213Z |
5005583 | 5005583 | 20240903154013_iesDx | NZ001C | 2024-09-09T12:03:49.718Z | 2024-09-12T12:19:06.208Z |
5005491 | 5005491 | 20240903152017_Z5QA3 | NZ001C | 2024-09-09T12:03:45.570Z | 2024-09-12T12:19:06.033Z |
5005272 | 5005272 | 20240903144314_LaPMY | NZ001C | 2024-09-09T12:03:32.795Z | 2024-09-12T12:19:05.617Z |
5005236 | 5005236 | 20240903143539_Ep1fm | NZ001C | 2024-09-09T12:03:30.645Z | 2024-09-12T12:19:05.508Z |
5004619 | 5004619 | 20240903115533_26C1Z | NZ001C | 2024-09-09T12:02:51.100Z | 2024-09-12T12:19:03.218Z |
5002955 | 5002955 | 20240904110005_P331Y | NZ001C | 2024-09-09T12:01:13.450Z | 2024-09-13T12:19:42.512Z |
5002214 | 5002214 | 20240904092345_qwmVn | NZ001C | 2024-09-09T12:00:13.253Z | 2024-09-13T12:19:40.019Z |
4910705 | 4910705 | 20240809183115_vLUKM | NZ001C | 2024-08-29T12:06:32.218Z | 2024-09-02T12:21:03.915Z |
4910252 | 4910252 | 20240809175357_2A647 | NZ001C | 2024-08-29T12:05:59.700Z | 2024-09-02T12:20:35.650Z |
4910219 | 4910219 | 20240809174941_pIRO5 | NZ001C | 2024-08-29T12:05:56.139Z | 2024-09-02T12:20:34.660Z |
4910104 | 4910104 | 20240809174112_jqaDG | NZ001C | 2024-08-29T12:05:49.251Z | 2024-09-02T12:20:30.979Z |
4910010 | 4910010 | 20240809173704_kTtTD | NZ001C | 2024-08-29T12:05:43.895Z | 2024-09-02T12:20:28.568Z |
4909935 | 4909935 | 20240809173314_wfStJ | NZ001C | 2024-08-29T12:05:40.761Z | 2024-09-02T12:20:27.351Z |
4909877 | 4909877 | 20240809172705_aJecH | NZ001C | 2024-08-29T12:05:37.241Z | 2024-09-02T12:20:25.697Z |
4909434 | 4909434 | 20240809165743_4Js93 | NZ001C | 2024-08-29T12:05:09.534Z | 2024-09-02T12:19:58.480Z |
4909289 | 4909289 | 20240809164749_Cu0xA | NZ001C | 2024-08-29T12:04:57.667Z | 2024-09-02T12:19:52.531Z |
4909238 | 4909238 | 20240809164219_H7Qs5 | NZ001C | 2024-08-29T12:04:54.636Z | 2024-09-02T12:19:50.636Z |
4909043 | 4909043 | 20240809162614_vwO7V | NZ001C | 2024-08-29T12:04:42.223Z | 2024-09-02T12:19:40.502Z |
4908843 | 4908843 | 20240809160953_Y2GJw | NZ001C | 2024-08-29T12:04:30.152Z | 2024-09-02T12:19:28.495Z |
4908752 | 4908752 | 20240809160027_sdkLu | NZ001C | 2024-08-29T12:04:24.404Z | 2024-09-02T12:19:25.487Z |
4908748 | 4908748 | 20240809160022_6GP0b | NZ001C | 2024-08-29T12:04:24.190Z | 2024-09-02T12:19:25.374Z |
4908477 | 4908477 | 20240809153933_y2Pei | NZ001C | 2024-08-29T12:04:07.879Z | 2024-09-02T12:19:14.543Z |
4908376 | 4908376 | 20240809153622_J03RK | NZ001C | 2024-08-29T12:04:02.411Z | 2024-09-02T12:19:11.848Z |
4908276 | 4908276 | 20240809152759_hkED7 | NZ001C | 2024-08-29T12:03:55.725Z | 2024-09-02T12:19:08.660Z |
4908213 | 4908213 | 20240809152303_i8YNr | NZ001C | 2024-08-29T12:03:51.690Z | 2024-09-02T12:19:06.799Z |
4908003 | 4908003 | 20240809151018_XN2gX | NZ001C | 2024-08-29T12:03:36.702Z | 2024-09-02T12:18:50.511Z |
4907483 | 4907483 | 20240809142445_7PwvK | NZ001C | 2024-08-29T12:03:05.641Z | 2024-09-02T12:18:31.789Z |
4907479 | 4907479 | 20240809142418_KE29M | NZ001C | 2024-08-29T12:03:05.488Z | 2024-09-02T12:18:31.713Z |
4907473 | 4907473 | 20240809142401_v5VIb | NZ001C | 2024-08-29T12:03:05.277Z | 2024-09-02T12:18:31.516Z |
4907032 | 4907032 | 20240809134203_QudcH | NZ001C | 2024-08-29T12:02:35.635Z | 2024-09-02T12:18:06.422Z |
4906869 | 4906869 | 20240809132113_mYJ37 | NZ001C | 2024-08-29T12:02:22.091Z | 2024-09-02T12:18:00.556Z |
4906807 | 4906807 | 20240809131714_7SPy4 | NZ001C | 2024-08-29T12:02:18.250Z | 2024-09-02T12:17:58.687Z |
4905806 | 4905806 | 20240809112647_GDw82 | NZ001C | 2024-08-29T12:01:00.674Z | 2024-09-02T12:17:13.814Z |
4905715 | 4905715 | 20240809111737_ZwuQo | NZ001C | 2024-08-29T12:00:51.467Z | 2024-09-02T12:17:01.988Z |
4905621 | 4905621 | 20240809110853_90OVC | NZ001C | 2024-08-29T12:00:42.531Z | 2024-09-02T12:16:53.465Z |
4905412 | 4905412 | 20240809104440_fp9Y6 | NZ001C | 2024-08-29T12:00:15.344Z | 2024-09-02T12:16:43.753Z |
4893611 | 4893611 | 20240809101549_touqw | NZ001C | 2024-08-28T12:11:34.914Z | 2024-08-30T12:23:03.403Z |
4893548 | 4893548 | 20240809100249_t32JX | NZ001C | 2024-08-28T12:11:32.473Z | 2024-08-30T12:23:00.736Z |
4870982 | 4870982 | 20240806183814_AgTA5 | NZ001C | 2024-08-19T12:08:24.929Z | 2024-08-27T12:09:12.972Z |
4870973 | 4870973 | 20240806183809_h2PTG | NZ001C | 2024-08-19T12:08:24.618Z | 2024-08-27T12:09:12.845Z |
4870958 | 4870958 | 20240806183706_LZXd6 | NZ001C | 2024-08-19T12:08:22.119Z | 2024-08-27T12:09:12.345Z |
4870939 | 4870939 | 20240806183608_0eiuj | NZ001C | 2024-08-19T12:08:21.027Z | 2024-08-27T12:09:11.804Z |
4870907 | 4870907 | 20240806183445_7srD5 | NZ001C | 2024-08-19T12:08:16.991Z | 2024-08-27T12:09:10.356Z |
4870783 | 4870783 | 20240806182117_Lb9Qa | NZ001C | 2024-08-19T12:08:07.778Z | 2024-08-27T12:09:00.156Z |
4870774 | 4870774 | 20240806182103_22ry4 | NZ001C | 2024-08-19T12:08:07.534Z | 2024-08-27T12:08:59.810Z |
4870661 | 4870661 | 20240806181137_3U2o3 | NZ001C | 2024-08-19T12:08:00.915Z | 2024-08-27T12:08:54.336Z |
4870352 | 4870352 | 20240806175725_l1D2w | NZ001C | 2024-08-19T12:07:49.649Z | 2024-08-27T12:08:43.810Z |
4869378 | 4869378 | 20240806171511_vmlhq | NZ001C | 2024-08-19T12:07:06.752Z | 2024-08-27T12:08:07.020Z |
4869330 | 4869330 | 20240806171232_WyGY0 | NZ001C | 2024-08-19T12:07:04.141Z | 2024-08-27T12:08:05.323Z |
4869231 | 4869231 | 20240806170816_gV3Ru | NZ001C | 2024-08-19T12:06:55.707Z | 2024-08-27T12:08:01.921Z |
4869117 | 4869117 | 20240806170153_Ht3av | NZ001C | 2024-08-19T12:06:48.747Z | 2024-08-27T12:07:53.533Z |
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);