participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,031 rows where station_code = "NZ0042" 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 |
---|---|---|---|---|---|
5569503 | 5569503 | 20241121154505_Sm94P | NZ0042 | 2024-11-22T14:10:59.669Z | 2024-11-22T14:10:59.669Z |
5569482 | 5569482 | 20241121153757_LiTPU | NZ0042 | 2024-11-22T14:10:57.062Z | 2024-11-22T14:10:57.062Z |
5569453 | 5569453 | 20241121153413_fpqo1 | NZ0042 | 2024-11-22T14:10:54.356Z | 2024-11-22T14:10:54.356Z |
5569431 | 5569431 | 20241121152745_llqRw | NZ0042 | 2024-11-22T14:10:52.254Z | 2024-11-22T14:10:52.254Z |
5569406 | 5569406 | 20241121152417_0cHGn | NZ0042 | 2024-11-22T14:10:51.130Z | 2024-11-22T14:10:51.130Z |
5569397 | 5569397 | 20241121152319_qfzzs | NZ0042 | 2024-11-22T14:10:50.647Z | 2024-11-22T14:10:50.647Z |
5569393 | 5569393 | 20241121152319_3rB0f | NZ0042 | 2024-11-22T14:10:50.451Z | 2024-11-22T14:10:50.451Z |
5569380 | 5569380 | 20241121152102_ySKp1 | NZ0042 | 2024-11-22T14:10:49.736Z | 2024-11-22T14:10:49.736Z |
5569344 | 5569344 | 20241121151341_ofr35 | NZ0042 | 2024-11-22T14:10:47.146Z | 2024-11-22T14:10:47.146Z |
5569341 | 5569341 | 20241121151328_mQ65m | NZ0042 | 2024-11-22T14:10:46.899Z | 2024-11-22T14:10:46.899Z |
5569319 | 5569319 | 20241121150806_C2wqk | NZ0042 | 2024-11-22T14:10:45.447Z | 2024-11-22T14:10:45.447Z |
5569203 | 5569203 | 20241121145148_Knj0A | NZ0042 | 2024-11-22T14:10:35.346Z | 2024-11-22T14:10:35.346Z |
5568945 | 5568945 | 20241121140820_tEbHN | NZ0042 | 2024-11-22T14:10:06.277Z | 2024-11-22T14:10:06.277Z |
5568892 | 5568892 | 20241121135902_RPnRK | NZ0042 | 2024-11-22T14:10:02.266Z | 2024-11-22T14:10:02.266Z |
5568752 | 5568752 | 20241121132934_hxELp | NZ0042 | 2024-11-22T14:09:39.823Z | 2024-11-22T14:09:39.823Z |
5568659 | 5568659 | 20241121131830_LrEXe | NZ0042 | 2024-11-22T14:09:31.294Z | 2024-11-22T14:09:31.294Z |
5568623 | 5568623 | 20241121131329_s2Os4 | NZ0042 | 2024-11-22T14:09:26.746Z | 2024-11-22T14:09:26.746Z |
5568568 | 5568568 | 20241121130430_JTm33 | NZ0042 | 2024-11-22T14:09:21.709Z | 2024-11-22T14:09:21.709Z |
5568500 | 5568500 | 20241121125324_fpCQA | NZ0042 | 2024-11-22T14:09:06.902Z | 2024-11-22T14:09:06.902Z |
5568439 | 5568439 | 20241121124816_sQfVs | NZ0042 | 2024-11-22T14:08:57.573Z | 2024-11-22T14:08:57.573Z |
5568187 | 5568187 | 20241121120344_8fz8V | NZ0042 | 2024-11-22T14:08:23.122Z | 2024-11-22T14:08:23.122Z |
5568118 | 5568118 | 20241121115251_Fw7au | NZ0042 | 2024-11-22T14:08:08.102Z | 2024-11-22T14:08:08.102Z |
5568028 | 5568028 | 20241121114221_dwTJR | NZ0042 | 2024-11-22T14:07:57.954Z | 2024-11-22T14:07:57.954Z |
5567873 | 5567873 | 20241121112032_ATC2Z | NZ0042 | 2024-11-22T14:07:28.094Z | 2024-11-22T14:07:28.094Z |
5567515 | 5567515 | 20241121103058_b5BkG | NZ0042 | 2024-11-22T14:06:25.782Z | 2024-11-22T14:06:25.782Z |
5567471 | 5567471 | 20241121102422_qyU3l | NZ0042 | 2024-11-22T14:06:20.939Z | 2024-11-22T14:06:20.939Z |
5566972 | 5566972 | 20241121085106_CSJLk | NZ0042 | 2024-11-22T14:04:48.006Z | 2024-11-22T14:04:48.006Z |
5560890 | 5560890 | 20241120150933_I5O33 | NZ0042 | 2024-11-21T14:09:55.453Z | 2024-11-22T14:19:21.754Z |
5560662 | 5560662 | 20241120134939_nYGVc | NZ0042 | 2024-11-21T14:09:22.686Z | 2024-11-22T14:19:21.708Z |
5560638 | 5560638 | 20241120133541_eDBqy | NZ0042 | 2024-11-21T14:09:19.172Z | 2024-11-22T14:19:21.702Z |
5560116 | 5560116 | 20241120120349_2leRE | NZ0042 | 2024-11-21T14:08:04.495Z | 2024-11-22T14:19:21.590Z |
5559410 | 5559410 | 20241120102002_MVocq | NZ0042 | 2024-11-21T14:06:16.157Z | 2024-11-22T14:19:21.441Z |
5559387 | 5559387 | 20241120101359_2IlsK | NZ0042 | 2024-11-21T14:06:12.855Z | 2024-11-22T14:19:21.434Z |
5559084 | 5559084 | 20241120091805_7TapW | NZ0042 | 2024-11-21T14:05:17.233Z | 2024-11-22T14:19:21.360Z |
5559060 | 5559060 | 20241120090858_dW8LB | NZ0042 | 2024-11-21T14:05:10.741Z | 2024-11-22T14:19:21.354Z |
5558963 | 5558963 | 20241120085952_ZX2uD | NZ0042 | 2024-11-21T14:04:54.319Z | 2024-11-22T14:19:21.336Z |
5558872 | 5558872 | 20241120083645_SzQFb | NZ0042 | 2024-11-21T14:04:41.855Z | 2024-11-22T14:19:21.319Z |
5558814 | 5558814 | 20241120081152_ZRJuw | NZ0042 | 2024-11-21T14:04:27.930Z | 2024-11-22T14:19:21.305Z |
5555379 | 5555379 | 20241119130124_sX75W | NZ0042 | 2024-11-20T14:05:23.498Z | 2024-11-22T14:20:04.993Z |
5554865 | 5554865 | 20241119105102_hLNdc | NZ0042 | 2024-11-20T14:03:39.768Z | 2024-11-22T14:19:52.762Z |
5554686 | 5554686 | 20241119100429_Kxj8Y | NZ0042 | 2024-11-20T14:03:00.691Z | 2024-11-22T14:19:48.697Z |
5551929 | 5551929 | 20241118154235_LJRr1 | NZ0042 | 2024-11-19T14:05:48.598Z | 2024-11-22T14:22:13.056Z |
5551833 | 5551833 | 20241118152132_TGBsU | NZ0042 | 2024-11-19T14:05:40.536Z | 2024-11-22T14:22:12.642Z |
5551803 | 5551803 | 20241118151736_ns2I7 | NZ0042 | 2024-11-19T14:05:32.934Z | 2024-11-22T14:22:12.550Z |
5551775 | 5551775 | 20241118150832_4Vf3D | NZ0042 | 2024-11-19T14:05:28.892Z | 2024-11-22T14:22:12.460Z |
5551701 | 5551701 | 20241118144824_NfJJM | NZ0042 | 2024-11-19T14:05:15.365Z | 2024-11-22T14:22:12.169Z |
5551655 | 5551655 | 20241118143608_5lldX | NZ0042 | 2024-11-19T14:05:07.550Z | 2024-11-22T14:22:11.936Z |
5551466 | 5551466 | 20241118134624_vYzQi | NZ0042 | 2024-11-19T14:04:50.186Z | 2024-11-22T14:22:10.854Z |
5551414 | 5551414 | 20241118132848_VWJB3 | NZ0042 | 2024-11-19T14:04:45.223Z | 2024-11-22T14:22:10.574Z |
5551412 | 5551412 | 20241118132846_ZnhUc | NZ0042 | 2024-11-19T14:04:44.942Z | 2024-11-22T14:22:10.548Z |
5551326 | 5551326 | 20241118130641_63pCm | NZ0042 | 2024-11-19T14:04:25.728Z | 2024-11-22T14:22:10.070Z |
5551245 | 5551245 | 20241118124830_I2UFC | NZ0042 | 2024-11-19T14:04:09.284Z | 2024-11-22T14:22:09.399Z |
5551174 | 5551174 | 20241118123901_LPVVk | NZ0042 | 2024-11-19T14:04:01.850Z | 2024-11-22T14:22:08.902Z |
5550466 | 5550466 | 20241118102354_zlvKQ | NZ0042 | 2024-11-19T14:02:23.171Z | 2024-11-22T14:22:03.217Z |
5550361 | 5550361 | 20241118100931_OqMoA | NZ0042 | 2024-11-19T14:02:14.244Z | 2024-11-22T14:22:01.678Z |
5550307 | 5550307 | 20241118100409_u8EkQ | NZ0042 | 2024-11-19T14:02:10.406Z | 2024-11-22T14:22:01.229Z |
5550299 | 5550299 | 20241118100315_Vcbf1 | NZ0042 | 2024-11-19T14:02:09.348Z | 2024-11-22T14:22:01.095Z |
5550288 | 5550288 | 20241118100014_dZclw | NZ0042 | 2024-11-19T14:02:04.768Z | 2024-11-22T14:22:00.804Z |
5550278 | 5550278 | 20241118095810_CkG3k | NZ0042 | 2024-11-19T14:02:03.069Z | 2024-11-22T14:22:00.655Z |
5550177 | 5550177 | 20241118094333_rrpl2 | NZ0042 | 2024-11-19T14:01:41.458Z | 2024-11-22T14:21:59.256Z |
5547356 | 5547356 | 20241117154635_ex9Ey | NZ0042 | 2024-11-18T14:05:34.137Z | 2024-11-22T14:22:39.111Z |
5547319 | 5547319 | 20241117153751_gLqIR | NZ0042 | 2024-11-18T14:05:30.777Z | 2024-11-22T14:22:38.984Z |
5547286 | 5547286 | 20241117152518_hKSRu | NZ0042 | 2024-11-18T14:05:25.178Z | 2024-11-22T14:22:38.337Z |
5547247 | 5547247 | 20241117151440_KxLxN | NZ0042 | 2024-11-18T14:05:21.049Z | 2024-11-22T14:22:38.195Z |
5547066 | 5547066 | 20241117143101_eJlPo | NZ0042 | 2024-11-18T14:04:53.138Z | 2024-11-22T14:22:36.625Z |
5536041 | 5536041 | 20241112152819_V3A66 | NZ0042 | 2024-11-14T14:09:08.079Z | 2024-11-21T14:25:56.343Z |
5535945 | 5535945 | 20241112145755_ozQo3 | NZ0042 | 2024-11-14T14:09:01.199Z | 2024-11-21T14:25:55.015Z |
5535903 | 5535903 | 20241112144927_ngFhq | NZ0042 | 2024-11-14T14:08:58.215Z | 2024-11-21T14:25:54.574Z |
5535798 | 5535798 | 20241112142332_eDXXw | NZ0042 | 2024-11-14T14:08:50.552Z | 2024-11-21T14:25:53.498Z |
5535755 | 5535755 | 20241112141030_8O7Ku | NZ0042 | 2024-11-14T14:08:42.793Z | 2024-11-21T14:25:52.812Z |
5535508 | 5535508 | 20241112124200_onObY | NZ0042 | 2024-11-14T14:08:01.203Z | 2024-11-21T14:25:48.717Z |
5535462 | 5535462 | 20241112123310_dzbfe | NZ0042 | 2024-11-14T14:07:58.100Z | 2024-11-21T14:25:48.538Z |
5535209 | 5535209 | 20241112115458_Ar4Jj | NZ0042 | 2024-11-14T14:07:30.200Z | 2024-11-21T14:25:45.029Z |
5526192 | 5526192 | 20241112083036_L9CoI | NZ0042 | 2024-11-13T14:02:08.986Z | 2024-11-21T14:25:31.566Z |
5519304 | 5519304 | 20241111105648_5ObWM | NZ0042 | 2024-11-12T14:03:42.579Z | 2024-11-20T14:24:47.204Z |
5507413 | 5507413 | 20241109112507_Nrqr3 | NZ0042 | 2024-11-10T14:05:02.192Z | 2024-11-18T14:26:10.620Z |
5507092 | 5507092 | 20241109102743_XMFQo | NZ0042 | 2024-11-10T14:04:14.557Z | 2024-11-18T14:26:06.898Z |
5500285 | 5500285 | 20241108151230_irD3R | NZ0042 | 2024-11-09T14:06:03.588Z | 2024-11-17T14:23:21.068Z |
5500277 | 5500277 | 20241108151025_EdYtV | NZ0042 | 2024-11-09T14:06:03.070Z | 2024-11-17T14:23:21.025Z |
5500213 | 5500213 | 20241108150437_33TlA | NZ0042 | 2024-11-09T14:05:58.983Z | 2024-11-17T14:23:20.140Z |
5500198 | 5500198 | 20241108150250_5mQQJ | NZ0042 | 2024-11-09T14:05:58.088Z | 2024-11-17T14:23:20.057Z |
5500000 | 5500000 | 20241108142115_b3FiQ | NZ0042 | 2024-11-09T14:05:28.362Z | 2024-11-17T14:23:17.917Z |
5499540 | 5499540 | 20241108123342_Sz3gu | NZ0042 | 2024-11-09T14:04:16.841Z | 2024-11-17T14:23:12.725Z |
5492659 | 5492659 | 20241107092537_31zEy | NZ0042 | 2024-11-08T14:01:46.826Z | 2024-11-16T14:27:27.246Z |
5492650 | 5492650 | 20241107092353_4iMMk | NZ0042 | 2024-11-08T14:01:44.580Z | 2024-11-16T14:27:27.199Z |
5486832 | 5486832 | 20241106133940_iarDA | NZ0042 | 2024-11-07T14:04:13.101Z | 2024-11-15T14:24:35.163Z |
5481237 | 5481237 | 20241104155330_S7GRd | NZ0042 | 2024-11-06T14:09:47.212Z | 2024-11-13T14:27:26.540Z |
5481232 | 5481232 | 20241104155215_gX7Kj | NZ0042 | 2024-11-06T14:09:46.458Z | 2024-11-13T14:27:26.515Z |
5480671 | 5480671 | 20241105143826_P4ng6 | NZ0042 | 2024-11-06T14:06:18.378Z | 2024-11-14T14:23:05.504Z |
5480655 | 5480655 | 20241105142959_E0rj7 | NZ0042 | 2024-11-06T14:06:11.547Z | 2024-11-14T14:23:05.430Z |
5480613 | 5480613 | 20241105141741_1ptq3 | NZ0042 | 2024-11-06T14:06:03.255Z | 2024-11-14T14:23:05.326Z |
5480017 | 5480017 | 20241105111740_hIbIx | NZ0042 | 2024-11-06T14:04:19.348Z | 2024-11-14T14:23:01.540Z |
5479974 | 5479974 | 20241105111127_MaAB4 | NZ0042 | 2024-11-06T14:04:14.074Z | 2024-11-14T14:23:01.355Z |
5479813 | 5479813 | 20241105104420_TgZMR | NZ0042 | 2024-11-06T14:03:38.635Z | 2024-11-14T14:23:00.768Z |
5479185 | 5479185 | 20241105082538_BC6es | NZ0042 | 2024-11-06T14:01:21.459Z | 2024-11-14T14:22:57.935Z |
5473607 | 5473607 | 20241103143839_1QLLe | NZ0042 | 2024-11-05T14:09:11.848Z | 2024-11-12T14:27:49.781Z |
5473588 | 5473588 | 20241103143613_B0NNI | NZ0042 | 2024-11-05T14:09:09.786Z | 2024-11-12T14:27:49.774Z |
5473560 | 5473560 | 20241103143258_wUgi9 | NZ0042 | 2024-11-05T14:09:06.680Z | 2024-11-12T14:27:49.711Z |
5473465 | 5473465 | 20241103142005_kH4pP | NZ0042 | 2024-11-05T14:08:57.942Z | 2024-11-12T14:27:49.625Z |
5473290 | 5473290 | 20241103135359_5QMyP | NZ0042 | 2024-11-05T14:08:45.336Z | 2024-11-12T14:27:48.430Z |
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);