participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,744 rows where station_code = "NZ0014" 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 |
---|---|---|---|---|---|
5569452 | 5569452 | 20241121153413_fpqo1 | NZ0014 | 2024-11-22T14:10:54.356Z | 2024-11-22T14:10:54.356Z |
5569413 | 5569413 | 20241121152555_L1A8u | NZ0014 | 2024-11-22T14:10:51.424Z | 2024-11-22T14:10:51.424Z |
5569405 | 5569405 | 20241121152417_0cHGn | NZ0014 | 2024-11-22T14:10:51.129Z | 2024-11-22T14:10:51.129Z |
5569394 | 5569394 | 20241121152319_qfzzs | NZ0014 | 2024-11-22T14:10:50.647Z | 2024-11-22T14:10:50.647Z |
5569339 | 5569339 | 20241121151328_mQ65m | NZ0014 | 2024-11-22T14:10:46.899Z | 2024-11-22T14:10:46.899Z |
5569234 | 5569234 | 20241121145506_rjDQH | NZ0014 | 2024-11-22T14:10:41.190Z | 2024-11-22T14:10:41.190Z |
5568862 | 5568862 | 20241121135355_PAUMB | NZ0014 | 2024-11-22T14:10:00.572Z | 2024-11-22T14:10:00.572Z |
5568748 | 5568748 | 20241121132934_hxELp | NZ0014 | 2024-11-22T14:09:39.823Z | 2024-11-22T14:09:39.823Z |
5568722 | 5568722 | 20241121132743_thqpP | NZ0014 | 2024-11-22T14:09:37.088Z | 2024-11-22T14:09:37.088Z |
5568626 | 5568626 | 20241121131424_KIqUZ | NZ0014 | 2024-11-22T14:09:27.032Z | 2024-11-22T14:09:27.032Z |
5568572 | 5568572 | 20241121130520_D8SE6 | NZ0014 | 2024-11-22T14:09:22.325Z | 2024-11-22T14:09:22.325Z |
5568566 | 5568566 | 20241121130430_JTm33 | NZ0014 | 2024-11-22T14:09:21.709Z | 2024-11-22T14:09:21.709Z |
5568562 | 5568562 | 20241121130055_g6Qr3 | NZ0014 | 2024-11-22T14:09:21.043Z | 2024-11-22T14:09:21.043Z |
5568184 | 5568184 | 20241121120344_8fz8V | NZ0014 | 2024-11-22T14:08:23.122Z | 2024-11-22T14:08:23.122Z |
5568162 | 5568162 | 20241121115722_Lior0 | NZ0014 | 2024-11-22T14:08:14.891Z | 2024-11-22T14:08:14.891Z |
5568060 | 5568060 | 20241121114528_eTnss | NZ0014 | 2024-11-22T14:08:02.244Z | 2024-11-22T14:08:02.244Z |
5567951 | 5567951 | 20241121113541_pJ4Vl | NZ0014 | 2024-11-22T14:07:51.136Z | 2024-11-22T14:07:51.136Z |
5567914 | 5567914 | 20241121113047_CRAES | NZ0014 | 2024-11-22T14:07:39.828Z | 2024-11-22T14:07:39.828Z |
5567842 | 5567842 | 20241121111845_sbBgf | NZ0014 | 2024-11-22T14:07:22.981Z | 2024-11-22T14:07:22.981Z |
5567704 | 5567704 | 20241121105424_Blyfq | NZ0014 | 2024-11-22T14:07:05.226Z | 2024-11-22T14:07:05.226Z |
5567438 | 5567438 | 20241121101855_KRb6V | NZ0014 | 2024-11-22T14:06:16.836Z | 2024-11-22T14:06:16.836Z |
5567350 | 5567350 | 20241121100600_Px2NJ | NZ0014 | 2024-11-22T14:05:58.511Z | 2024-11-22T14:05:58.511Z |
5559950 | 5559950 | 20241120113820_s9e1D | NZ0014 | 2024-11-21T14:07:40.333Z | 2024-11-22T14:19:21.555Z |
5559803 | 5559803 | 20241120111930_WvFEX | NZ0014 | 2024-11-21T14:07:13.273Z | 2024-11-22T14:19:21.528Z |
5558972 | 5558972 | 20241120090029_aCIhy | NZ0014 | 2024-11-21T14:04:55.591Z | 2024-11-22T14:19:21.339Z |
5558867 | 5558867 | 20241120083645_SzQFb | NZ0014 | 2024-11-21T14:04:41.819Z | 2024-11-22T14:19:21.319Z |
5558809 | 5558809 | 20241120081152_ZRJuw | NZ0014 | 2024-11-21T14:04:27.893Z | 2024-11-22T14:19:21.305Z |
5551885 | 5551885 | 20241118153455_TUWdn | NZ0014 | 2024-11-19T14:05:46.224Z | 2024-11-22T14:22:12.885Z |
5551828 | 5551828 | 20241118152132_TGBsU | NZ0014 | 2024-11-19T14:05:40.536Z | 2024-11-22T14:22:12.642Z |
5551804 | 5551804 | 20241118151849_FEad7 | NZ0014 | 2024-11-19T14:05:33.460Z | 2024-11-22T14:22:12.555Z |
5551457 | 5551457 | 20241118134229_yLCjF | NZ0014 | 2024-11-19T14:04:49.101Z | 2024-11-22T14:22:10.794Z |
5551408 | 5551408 | 20241118132846_ZnhUc | NZ0014 | 2024-11-19T14:04:44.942Z | 2024-11-22T14:22:10.548Z |
5551029 | 5551029 | 20241118121209_qWwEN | NZ0014 | 2024-11-19T14:03:47.767Z | 2024-11-22T14:22:07.774Z |
5550961 | 5550961 | 20241118120305_ho3i3 | NZ0014 | 2024-11-19T14:03:39.407Z | 2024-11-22T14:22:07.152Z |
5550645 | 5550645 | 20241118110307_eyToX | NZ0014 | 2024-11-19T14:02:51.913Z | 2024-11-22T14:22:04.631Z |
5547245 | 5547245 | 20241117151440_KxLxN | NZ0014 | 2024-11-18T14:05:21.049Z | 2024-11-22T14:22:38.195Z |
5547218 | 5547218 | 20241117150830_HdJon | NZ0014 | 2024-11-18T14:05:17.820Z | 2024-11-22T14:22:38.045Z |
5547064 | 5547064 | 20241117143101_eJlPo | NZ0014 | 2024-11-18T14:04:53.138Z | 2024-11-22T14:22:36.625Z |
5546658 | 5546658 | 20241117120641_0bqI2 | NZ0014 | 2024-11-18T14:03:44.925Z | 2024-11-22T14:22:33.655Z |
5546606 | 5546606 | 20241117115257_HXFFC | NZ0014 | 2024-11-18T14:03:38.387Z | 2024-11-22T14:22:33.355Z |
5546198 | 5546198 | 20241117094133_EbgTr | NZ0014 | 2024-11-18T14:02:26.165Z | 2024-11-22T14:22:29.991Z |
5544709 | 5544709 | 20241116143827_hwCVF | NZ0014 | 2024-11-17T14:01:53.574Z | 2024-11-22T14:23:05.899Z |
5542835 | 5542835 | 20241115134125_wbDf9 | NZ0014 | 2024-11-16T14:02:43.648Z | 2024-11-22T14:23:31.617Z |
5542706 | 5542706 | 20241115115742_a71b9 | NZ0014 | 2024-11-16T14:02:14.249Z | 2024-11-22T14:23:30.507Z |
5542479 | 5542479 | 20241115100744_p1qZS | NZ0014 | 2024-11-16T14:01:28.036Z | 2024-11-22T14:23:26.529Z |
5518761 | 5518761 | 20241111090255_3fXXd | NZ0014 | 2024-11-12T14:01:56.389Z | 2024-11-20T14:24:41.044Z |
5507892 | 5507892 | 20241109124734_iPOpr | NZ0014 | 2024-11-10T14:06:24.065Z | 2024-11-18T14:26:16.006Z |
5500496 | 5500496 | 20241108155131_Y2h3X | NZ0014 | 2024-11-09T14:06:22.251Z | 2024-11-17T14:23:22.991Z |
5500435 | 5500435 | 20241108154242_F38TE | NZ0014 | 2024-11-09T14:06:16.994Z | 2024-11-17T14:23:22.695Z |
5500423 | 5500423 | 20241108154059_CV6Np | NZ0014 | 2024-11-09T14:06:15.811Z | 2024-11-17T14:23:22.546Z |
5500153 | 5500153 | 20241108145859_6QsMp | NZ0014 | 2024-11-09T14:05:55.640Z | 2024-11-17T14:23:19.870Z |
5500094 | 5500094 | 20241108144426_zh3E3 | NZ0014 | 2024-11-09T14:05:40.891Z | 2024-11-17T14:23:18.882Z |
5500072 | 5500072 | 20241108143735_iPDWe | NZ0014 | 2024-11-09T14:05:39.066Z | 2024-11-17T14:23:18.476Z |
5499968 | 5499968 | 20241108141635_yI5IJ | NZ0014 | 2024-11-09T14:05:24.939Z | 2024-11-17T14:23:17.725Z |
5499926 | 5499926 | 20241108140422_sBVzp | NZ0014 | 2024-11-09T14:05:20.586Z | 2024-11-17T14:23:17.257Z |
5499920 | 5499920 | 20241108140256_HKHbc | NZ0014 | 2024-11-09T14:05:20.067Z | 2024-11-17T14:23:17.189Z |
5499856 | 5499856 | 20241108134902_cPoXj | NZ0014 | 2024-11-09T14:05:04.153Z | 2024-11-17T14:23:16.474Z |
5480651 | 5480651 | 20241105142959_E0rj7 | NZ0014 | 2024-11-06T14:06:11.546Z | 2024-11-14T14:23:05.430Z |
5479973 | 5479973 | 20241105111127_MaAB4 | NZ0014 | 2024-11-06T14:04:14.056Z | 2024-11-14T14:23:01.355Z |
5474105 | 5474105 | 20241103155341_0OwU0 | NZ0014 | 2024-11-05T14:10:08.925Z | 2024-11-12T14:27:50.568Z |
5474084 | 5474084 | 20241103155045_tJC32 | NZ0014 | 2024-11-05T14:10:07.710Z | 2024-11-12T14:27:50.532Z |
5473986 | 5473986 | 20241103153434_AqdMr | NZ0014 | 2024-11-05T14:09:58.317Z | 2024-11-12T14:27:50.435Z |
5473839 | 5473839 | 20241103151059_Kasqq | NZ0014 | 2024-11-05T14:09:47.978Z | 2024-11-12T14:27:50.113Z |
5473587 | 5473587 | 20241103143613_B0NNI | NZ0014 | 2024-11-05T14:09:09.786Z | 2024-11-12T14:27:49.774Z |
5473531 | 5473531 | 20241103142959_XKwWH | NZ0014 | 2024-11-05T14:09:04.601Z | 2024-11-12T14:27:49.686Z |
5473430 | 5473430 | 20241103141551_IYgsQ | NZ0014 | 2024-11-05T14:08:55.618Z | 2024-11-12T14:27:49.528Z |
5473387 | 5473387 | 20241103140942_UR3LJ | NZ0014 | 2024-11-05T14:08:52.615Z | 2024-11-12T14:27:49.385Z |
5473299 | 5473299 | 20241103135534_evrmL | NZ0014 | 2024-11-05T14:08:46.264Z | 2024-11-12T14:27:48.433Z |
5473207 | 5473207 | 20241103134306_yW2q3 | NZ0014 | 2024-11-05T14:08:34.585Z | 2024-11-12T14:27:48.222Z |
5473044 | 5473044 | 20241103131833_rSvAL | NZ0014 | 2024-11-05T14:08:06.290Z | 2024-11-12T14:27:47.714Z |
5472881 | 5472881 | 20241103125604_hspXG | NZ0014 | 2024-11-05T14:07:49.702Z | 2024-11-12T14:27:46.843Z |
5472850 | 5472850 | 20241103125310_iKydG | NZ0014 | 2024-11-05T14:07:47.831Z | 2024-11-12T14:27:46.822Z |
5472765 | 5472765 | 20241103123452_yT500 | NZ0014 | 2024-11-05T14:07:40.847Z | 2024-11-12T14:27:46.593Z |
5472659 | 5472659 | 20241103121901_U2r2q | NZ0014 | 2024-11-05T14:07:24.281Z | 2024-11-12T14:27:46.303Z |
5472608 | 5472608 | 20241104155704_vaDpk | NZ0014 | 2024-11-05T14:06:20.005Z | 2024-11-13T14:27:26.550Z |
5472563 | 5472563 | 20241104154548_kIght | NZ0014 | 2024-11-05T14:06:15.636Z | 2024-11-13T14:27:26.480Z |
5472545 | 5472545 | 20241104154016_B1bM8 | NZ0014 | 2024-11-05T14:06:12.031Z | 2024-11-13T14:27:26.462Z |
5472489 | 5472489 | 20241104152127_9k1om | NZ0014 | 2024-11-05T14:05:57.672Z | 2024-11-13T14:27:26.364Z |
5472416 | 5472416 | 20241104150047_z8cgZ | NZ0014 | 2024-11-05T14:05:48.106Z | 2024-11-13T14:27:26.260Z |
5472401 | 5472401 | 20241104145946_JOFW3 | NZ0014 | 2024-11-05T14:05:46.634Z | 2024-11-13T14:27:26.256Z |
5472286 | 5472286 | 20241104142630_TEurA | NZ0014 | 2024-11-05T14:05:34.987Z | 2024-11-13T14:27:26.099Z |
5472189 | 5472189 | 20241104140242_TiCDX | NZ0014 | 2024-11-05T14:05:26.014Z | 2024-11-13T14:27:25.882Z |
5472054 | 5472054 | 20241104133209_uZbe3 | NZ0014 | 2024-11-05T14:05:03.039Z | 2024-11-13T14:27:25.661Z |
5471973 | 5471973 | 20241104131125_YsYru | NZ0014 | 2024-11-05T14:04:54.052Z | 2024-11-13T14:27:25.523Z |
5471791 | 5471791 | 20241104124037_wcIFl | NZ0014 | 2024-11-05T14:04:37.083Z | 2024-11-13T14:27:25.090Z |
5471498 | 5471498 | 20241104115357_4anxz | NZ0014 | 2024-11-05T14:03:50.076Z | 2024-11-13T14:27:24.394Z |
5471487 | 5471487 | 20241104115217_zjHUW | NZ0014 | 2024-11-05T14:03:49.281Z | 2024-11-13T14:27:24.379Z |
5471321 | 5471321 | 20241104112700_b3Wxa | NZ0014 | 2024-11-05T14:03:26.138Z | 2024-11-13T14:27:24.086Z |
5471262 | 5471262 | 20241104112112_HpO6I | NZ0014 | 2024-11-05T14:03:15.215Z | 2024-11-13T14:27:24.013Z |
5471239 | 5471239 | 20241104111410_DaTmv | NZ0014 | 2024-11-05T14:03:11.058Z | 2024-11-13T14:27:23.967Z |
5470864 | 5470864 | 20241104095632_Msf37 | NZ0014 | 2024-11-05T14:02:06.837Z | 2024-11-13T14:27:23.076Z |
5470832 | 5470832 | 20241104095433_t4ORR | NZ0014 | 2024-11-05T14:01:59.090Z | 2024-11-13T14:27:22.997Z |
5470740 | 5470740 | 20241104093654_rlAQo | NZ0014 | 2024-11-05T14:01:42.945Z | 2024-11-13T14:27:22.818Z |
5465467 | 5465467 | 20241103121054_KXxFb | NZ0014 | 2024-11-04T14:03:47.093Z | 2024-11-12T14:27:46.249Z |
5465348 | 5465348 | 20241103113211_UWOeW | NZ0014 | 2024-11-04T14:03:32.967Z | 2024-11-12T14:27:46.106Z |
5465330 | 5465330 | 20241103112821_nPy8C | NZ0014 | 2024-11-04T14:03:23.064Z | 2024-11-12T14:27:45.940Z |
5465274 | 5465274 | 20241103111527_w431n | NZ0014 | 2024-11-04T14:03:14.378Z | 2024-11-12T14:27:45.685Z |
5464676 | 5464676 | 20241103084712_74tIb | NZ0014 | 2024-11-04T14:01:19.232Z | 2024-11-12T14:27:42.933Z |
5459317 | 5459317 | 20241101104338_X5f2x | NZ0014 | 2024-11-03T14:11:42.043Z | 2024-11-10T14:26:19.048Z |
5458943 | 5458943 | 20241101094932_G9SWo | NZ0014 | 2024-11-03T14:10:51.638Z | 2024-11-10T14:26:17.215Z |
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);