participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,195 rows where station_code = "NZ0026" 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 |
---|---|---|---|---|---|
5544422 | 5544422 | 20241116105646_ZR6oL | NZ0026 | 2024-11-17T14:01:05.886Z | 2024-11-22T14:23:02.671Z |
5542845 | 5542845 | 20241115142216_4yIi8 | NZ0026 | 2024-11-16T14:02:45.172Z | 2024-11-22T14:23:31.685Z |
5542833 | 5542833 | 20241115131448_QZqoZ | NZ0026 | 2024-11-16T14:02:42.864Z | 2024-11-22T14:23:31.606Z |
5542816 | 5542816 | 20241115124619_WQ70N | NZ0026 | 2024-11-16T14:02:40.549Z | 2024-11-22T14:23:31.496Z |
5536143 | 5536143 | 20241112154908_gOHar | NZ0026 | 2024-11-14T14:09:14.762Z | 2024-11-21T14:25:56.990Z |
5536127 | 5536127 | 20241112154546_0PakV | NZ0026 | 2024-11-14T14:09:13.019Z | 2024-11-21T14:25:56.916Z |
5536104 | 5536104 | 20241112154033_3gB8T | NZ0026 | 2024-11-14T14:09:11.870Z | 2024-11-21T14:25:56.725Z |
5536099 | 5536099 | 20241112154020_7WY6g | NZ0026 | 2024-11-14T14:09:11.731Z | 2024-11-21T14:25:56.722Z |
5536090 | 5536090 | 20241112153823_EXiz1 | NZ0026 | 2024-11-14T14:09:11.263Z | 2024-11-21T14:25:56.654Z |
5536062 | 5536062 | 20241112153227_7Tb53 | NZ0026 | 2024-11-14T14:09:09.651Z | 2024-11-21T14:25:56.447Z |
5535776 | 5535776 | 20241112141837_iav97 | NZ0026 | 2024-11-14T14:08:48.976Z | 2024-11-21T14:25:53.073Z |
5535728 | 5535728 | 20241112140057_pXQs8 | NZ0026 | 2024-11-14T14:08:36.060Z | 2024-11-21T14:25:52.743Z |
5535533 | 5535533 | 20241112124557_s5U3V | NZ0026 | 2024-11-14T14:08:02.716Z | 2024-11-21T14:25:49.475Z |
5535452 | 5535452 | 20241112123154_iiuTH | NZ0026 | 2024-11-14T14:07:57.338Z | 2024-11-21T14:25:48.442Z |
5535315 | 5535315 | 20241112120728_svePk | NZ0026 | 2024-11-14T14:07:47.991Z | 2024-11-21T14:25:46.221Z |
5526788 | 5526788 | 20241112101550_vnnmV | NZ0026 | 2024-11-13T14:04:09.978Z | 2024-11-21T14:25:38.557Z |
5526738 | 5526738 | 20241112100820_n4c23 | NZ0026 | 2024-11-13T14:04:02.618Z | 2024-11-21T14:25:37.530Z |
5514430 | 5514430 | 20241110155030_m5kAP | NZ0026 | 2024-11-11T14:06:37.316Z | 2024-11-19T14:21:47.770Z |
5514408 | 5514408 | 20241110154446_sAofI | NZ0026 | 2024-11-11T14:06:34.858Z | 2024-11-19T14:21:47.433Z |
5514327 | 5514327 | 20241110153109_iPgkf | NZ0026 | 2024-11-11T14:06:29.705Z | 2024-11-19T14:21:46.385Z |
5514316 | 5514316 | 20241110153011_RVGgR | NZ0026 | 2024-11-11T14:06:28.821Z | 2024-11-19T14:21:46.329Z |
5514304 | 5514304 | 20241110152747_d2w5i | NZ0026 | 2024-11-11T14:06:27.250Z | 2024-11-19T14:21:46.030Z |
5514265 | 5514265 | 20241110152011_hCovw | NZ0026 | 2024-11-11T14:06:24.477Z | 2024-11-19T14:21:45.539Z |
5514244 | 5514244 | 20241110151746_e3XEd | NZ0026 | 2024-11-11T14:06:23.483Z | 2024-11-19T14:21:45.291Z |
5514207 | 5514207 | 20241110150719_Z5QZ8 | NZ0026 | 2024-11-11T14:06:20.563Z | 2024-11-19T14:21:44.866Z |
5514174 | 5514174 | 20241110145819_Tkha3 | NZ0026 | 2024-11-11T14:06:18.651Z | 2024-11-19T14:21:44.625Z |
5514126 | 5514126 | 20241110143656_XBr31 | NZ0026 | 2024-11-11T14:06:14.714Z | 2024-11-19T14:21:43.946Z |
5514089 | 5514089 | 20241110142354_X7xkl | NZ0026 | 2024-11-11T14:06:05.531Z | 2024-11-19T14:21:43.306Z |
5514054 | 5514054 | 20241110135925_QJcKu | NZ0026 | 2024-11-11T14:05:57.822Z | 2024-11-19T14:21:42.577Z |
5514028 | 5514028 | 20241110134745_236Yv | NZ0026 | 2024-11-11T14:05:50.760Z | 2024-11-19T14:21:42.160Z |
5514022 | 5514022 | 20241110134228_Pie2D | NZ0026 | 2024-11-11T14:05:49.170Z | 2024-11-19T14:21:41.891Z |
5514009 | 5514009 | 20241110133339_pnOrP | NZ0026 | 2024-11-11T14:05:47.560Z | 2024-11-19T14:21:41.704Z |
5513972 | 5513972 | 20241110131306_kzXl2 | NZ0026 | 2024-11-11T14:05:44.656Z | 2024-11-19T14:21:41.105Z |
5513968 | 5513968 | 20241110131056_I8PGH | NZ0026 | 2024-11-11T14:05:44.406Z | 2024-11-19T14:21:41.089Z |
5513958 | 5513958 | 20241110125748_zdfK2 | NZ0026 | 2024-11-11T14:05:42.757Z | 2024-11-19T14:21:40.794Z |
5513906 | 5513906 | 20241110124137_9DYa5 | NZ0026 | 2024-11-11T14:05:38.043Z | 2024-11-19T14:21:39.627Z |
5513894 | 5513894 | 20241110123855_KW88Z | NZ0026 | 2024-11-11T14:05:36.665Z | 2024-11-19T14:21:39.444Z |
5513714 | 5513714 | 20241110120905_3vAks | NZ0026 | 2024-11-11T14:05:21.407Z | 2024-11-19T14:21:37.088Z |
5474015 | 5474015 | 20241103153816_PqRmN | NZ0026 | 2024-11-05T14:10:00.324Z | 2024-11-12T14:27:50.448Z |
5473984 | 5473984 | 20241103153426_fg5UA | NZ0026 | 2024-11-05T14:09:58.082Z | 2024-11-12T14:27:50.406Z |
5473722 | 5473722 | 20241103145512_xEz1v | NZ0026 | 2024-11-05T14:09:34.275Z | 2024-11-12T14:27:49.971Z |
5473686 | 5473686 | 20241103144908_8mAZP | NZ0026 | 2024-11-05T14:09:24.495Z | 2024-11-12T14:27:49.911Z |
5473680 | 5473680 | 20241103144853_J8lxx | NZ0026 | 2024-11-05T14:09:23.398Z | 2024-11-12T14:27:49.883Z |
5473654 | 5473654 | 20241103144606_g5Ad3 | NZ0026 | 2024-11-05T14:09:19.795Z | 2024-11-12T14:27:49.852Z |
5473642 | 5473642 | 20241103144444_yUSuA | NZ0026 | 2024-11-05T14:09:18.823Z | 2024-11-12T14:27:49.848Z |
5471161 | 5471161 | 20241104105515_IAIte | NZ0026 | 2024-11-05T14:03:00.603Z | 2024-11-13T14:27:23.801Z |
5471074 | 5471074 | 20241104104224_9FLdV | NZ0026 | 2024-11-05T14:02:43.885Z | 2024-11-13T14:27:23.603Z |
5471058 | 5471058 | 20241104104122_Hkbky | NZ0026 | 2024-11-05T14:02:40.285Z | 2024-11-13T14:27:23.586Z |
5470720 | 5470720 | 20241104093232_e5Ix2 | NZ0026 | 2024-11-05T14:01:39.841Z | 2024-11-13T14:27:22.753Z |
5470687 | 5470687 | 20241104091950_ueunG | NZ0026 | 2024-11-05T14:01:33.196Z | 2024-11-13T14:27:22.633Z |
5470682 | 5470682 | 20241104091932_ROrZE | NZ0026 | 2024-11-05T14:01:32.088Z | 2024-11-13T14:27:22.613Z |
5461136 | 5461136 | 20241101160827_ihXAP | NZ0026 | 2024-11-03T14:14:45.325Z | 2024-11-10T14:26:26.822Z |
5461080 | 5461080 | 20241101155018_Z9PMu | NZ0026 | 2024-11-03T14:14:42.304Z | 2024-11-10T14:26:26.673Z |
5460990 | 5460990 | 20241101153112_n1XkE | NZ0026 | 2024-11-03T14:14:38.112Z | 2024-11-10T14:26:26.473Z |
5460935 | 5460935 | 20241101152302_PkZCf | NZ0026 | 2024-11-03T14:14:35.108Z | 2024-11-10T14:26:25.965Z |
5460710 | 5460710 | 20241101145547_IFU2T | NZ0026 | 2024-11-03T14:14:16.745Z | 2024-11-10T14:26:25.178Z |
5460622 | 5460622 | 20241101143906_PXT9b | NZ0026 | 2024-11-03T14:14:04.590Z | 2024-11-10T14:26:24.883Z |
5460604 | 5460604 | 20241101143747_i0Gvx | NZ0026 | 2024-11-03T14:14:02.734Z | 2024-11-10T14:26:24.854Z |
5460557 | 5460557 | 20241101143025_DvbXH | NZ0026 | 2024-11-03T14:13:58.979Z | 2024-11-10T14:26:24.807Z |
5458045 | 5458045 | 20241102160253_J9LuO | NZ0026 | 2024-11-03T14:08:36.581Z | 2024-11-11T14:22:38.560Z |
5458002 | 5458002 | 20241102155654_Kpy2Q | NZ0026 | 2024-11-03T14:08:31.975Z | 2024-11-11T14:22:38.464Z |
5457969 | 5457969 | 20241102155108_SF30s | NZ0026 | 2024-11-03T14:08:25.464Z | 2024-11-11T14:22:37.468Z |
5457919 | 5457919 | 20241102154003_dwBKN | NZ0026 | 2024-11-03T14:08:20.996Z | 2024-11-11T14:22:37.271Z |
5457888 | 5457888 | 20241102153459_BEpYC | NZ0026 | 2024-11-03T14:08:18.548Z | 2024-11-11T14:22:37.188Z |
5457853 | 5457853 | 20241102153007_SrxYn | NZ0026 | 2024-11-03T14:08:16.364Z | 2024-11-11T14:22:37.102Z |
5457693 | 5457693 | 20241102151010_P5MuQ | NZ0026 | 2024-11-03T14:07:51.839Z | 2024-11-11T14:22:36.023Z |
5457661 | 5457661 | 20241102150407_EqPcI | NZ0026 | 2024-11-03T14:07:47.802Z | 2024-11-11T14:22:35.925Z |
5457574 | 5457574 | 20241102144758_IWJzX | NZ0026 | 2024-11-03T14:07:41.079Z | 2024-11-11T14:22:35.565Z |
5457534 | 5457534 | 20241102144028_M3LV4 | NZ0026 | 2024-11-03T14:07:36.543Z | 2024-11-11T14:22:35.091Z |
5457497 | 5457497 | 20241102143842_xw2hV | NZ0026 | 2024-11-03T14:07:34.368Z | 2024-11-11T14:22:35.018Z |
5457423 | 5457423 | 20241102142849_1njXB | NZ0026 | 2024-11-03T14:07:17.474Z | 2024-11-11T14:22:34.787Z |
5457259 | 5457259 | 20241102135944_mzdSF | NZ0026 | 2024-11-03T14:07:00.096Z | 2024-11-11T14:22:33.862Z |
5457236 | 5457236 | 20241102135435_BQcO2 | NZ0026 | 2024-11-03T14:06:57.878Z | 2024-11-11T14:22:33.762Z |
5457223 | 5457223 | 20241102135352_hy7vN | NZ0026 | 2024-11-03T14:06:57.321Z | 2024-11-11T14:22:33.759Z |
5457213 | 5457213 | 20241102135102_PpNf4 | NZ0026 | 2024-11-03T14:06:54.461Z | 2024-11-11T14:22:33.737Z |
5457141 | 5457141 | 20241102133705_pgj14 | NZ0026 | 2024-11-03T14:06:38.303Z | 2024-11-11T14:22:33.149Z |
5457094 | 5457094 | 20241102132958_2NIaB | NZ0026 | 2024-11-03T14:06:33.038Z | 2024-11-11T14:22:32.764Z |
5457067 | 5457067 | 20241102132603_UHXhs | NZ0026 | 2024-11-03T14:06:29.371Z | 2024-11-11T14:22:32.636Z |
5457062 | 5457062 | 20241102132408_nIllQ | NZ0026 | 2024-11-03T14:06:28.417Z | 2024-11-11T14:22:32.625Z |
5456992 | 5456992 | 20241102131119_r9T5U | NZ0026 | 2024-11-03T14:06:19.829Z | 2024-11-11T14:22:32.337Z |
5456989 | 5456989 | 20241102130622_7UlJg | NZ0026 | 2024-11-03T14:06:19.453Z | 2024-11-11T14:22:32.319Z |
5456971 | 5456971 | 20241102130253_0tB5k | NZ0026 | 2024-11-03T14:06:13.951Z | 2024-11-11T14:22:32.259Z |
5456917 | 5456917 | 20241102125052_JPiDK | NZ0026 | 2024-11-03T14:06:00.448Z | 2024-11-11T14:22:32.060Z |
5456735 | 5456735 | 20241102121212_KeABw | NZ0026 | 2024-11-03T14:05:35.092Z | 2024-11-11T14:22:30.972Z |
5455554 | 5455554 | 20241102082437_LkDPW | NZ0026 | 2024-11-03T14:01:22.121Z | 2024-11-11T14:22:22.251Z |
5448641 | 5448641 | 20241031140015_1pQVg | NZ0026 | 2024-11-02T12:11:14.184Z | 2024-11-09T14:24:06.875Z |
5448610 | 5448610 | 20241031135411_MCJdr | NZ0026 | 2024-11-02T12:11:10.883Z | 2024-11-09T14:24:06.655Z |
5448526 | 5448526 | 20241031134337_cIA5i | NZ0026 | 2024-11-02T12:11:00.769Z | 2024-11-09T14:24:06.328Z |
5448451 | 5448451 | 20241031133320_jp9uX | NZ0026 | 2024-11-02T12:10:47.520Z | 2024-11-09T14:24:05.915Z |
5448387 | 5448387 | 20241031132342_DQ5TO | NZ0026 | 2024-11-02T12:10:40.421Z | 2024-11-09T14:24:05.737Z |
5448204 | 5448204 | 20241031125842_expEE | NZ0026 | 2024-11-02T12:10:15.977Z | 2024-11-09T14:24:03.924Z |
5448004 | 5448004 | 20241031123205_SFPfC | NZ0026 | 2024-11-02T12:09:43.202Z | 2024-11-09T14:24:02.313Z |
5447844 | 5447844 | 20241031121632_kJO3Y | NZ0026 | 2024-11-02T12:09:17.082Z | 2024-11-09T14:24:01.519Z |
5447751 | 5447751 | 20241031120833_NExrX | NZ0026 | 2024-11-02T12:09:02.120Z | 2024-11-09T14:24:01.315Z |
5447738 | 5447738 | 20241031120618_23DNd | NZ0026 | 2024-11-02T12:09:00.520Z | 2024-11-09T14:24:01.151Z |
5447598 | 5447598 | 20241031115457_9KBrX | NZ0026 | 2024-11-02T12:08:33.818Z | 2024-11-09T14:24:00.550Z |
5447082 | 5447082 | 20241031110711_KGgSn | NZ0026 | 2024-11-02T12:07:14.061Z | 2024-11-09T14:23:57.899Z |
5446871 | 5446871 | 20241031104125_EZWYA | NZ0026 | 2024-11-02T12:06:34.900Z | 2024-11-09T14:23:56.896Z |
5445649 | 5445649 | 20241031083100_mhpem | NZ0026 | 2024-11-02T12:02:45.021Z | 2024-11-09T14:23:51.053Z |
5438052 | 5438052 | 20241030161749_untm3 | NZ0026 | 2024-11-01T12:10:55.077Z | 2024-11-08T14:22:58.769Z |
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);