participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,827 rows where station_code = "NZ003E" 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 |
---|---|---|---|---|---|
5460914 | 5460914 | 20241101151916_2tBxh | NZ003E | 2024-11-03T14:14:34.040Z | 2024-11-03T14:19:33.636Z |
5460840 | 5460840 | 20241101151226_Pq4RB | NZ003E | 2024-11-03T14:14:31.180Z | 2024-11-03T14:19:33.623Z |
5460825 | 5460825 | 20241101150908_TECO7 | NZ003E | 2024-11-03T14:14:29.900Z | 2024-11-03T14:19:33.620Z |
5460819 | 5460819 | 20241101150905_g8CCv | NZ003E | 2024-11-03T14:14:29.419Z | 2024-11-03T14:19:33.619Z |
5460785 | 5460785 | 20241101150300_xA2W6 | NZ003E | 2024-11-03T14:14:25.421Z | 2024-11-03T14:19:33.613Z |
5460678 | 5460678 | 20241101144726_dPXDx | NZ003E | 2024-11-03T14:14:12.824Z | 2024-11-03T14:19:33.595Z |
5460640 | 5460640 | 20241101144105_DDqo8 | NZ003E | 2024-11-03T14:14:06.865Z | 2024-11-03T14:19:33.588Z |
5460614 | 5460614 | 20241101143823_fAcqh | NZ003E | 2024-11-03T14:14:03.411Z | 2024-11-03T14:19:33.584Z |
5460543 | 5460543 | 20241101142908_t83CK | NZ003E | 2024-11-03T14:13:57.614Z | 2024-11-03T14:19:33.571Z |
5460532 | 5460532 | 20241101142749_ij2UR | NZ003E | 2024-11-03T14:13:56.311Z | 2024-11-03T14:19:33.568Z |
5460524 | 5460524 | 20241101142705_jj2Bt | NZ003E | 2024-11-03T14:13:54.635Z | 2024-11-03T14:19:33.567Z |
5460520 | 5460520 | 20241101142645_eN177 | NZ003E | 2024-11-03T14:13:54.509Z | 2024-11-03T14:19:33.566Z |
5460414 | 5460414 | 20241101140407_lJGpx | NZ003E | 2024-11-03T14:13:42.616Z | 2024-11-03T14:19:33.541Z |
5460282 | 5460282 | 20241101133130_mRgwp | NZ003E | 2024-11-03T14:13:32.968Z | 2024-11-03T14:19:33.514Z |
5460177 | 5460177 | 20241101130224_Ka0Xy | NZ003E | 2024-11-03T14:13:26.648Z | 2024-11-03T14:19:33.493Z |
5460107 | 5460107 | 20241101124644_xvEFt | NZ003E | 2024-11-03T14:13:21.605Z | 2024-11-03T14:19:33.478Z |
5460072 | 5460072 | 20241101123818_vNGlG | NZ003E | 2024-11-03T14:13:19.229Z | 2024-11-03T14:19:33.472Z |
5459989 | 5459989 | 20241101122744_oOmN3 | NZ003E | 2024-11-03T14:13:03.524Z | 2024-11-03T14:19:33.459Z |
5459773 | 5459773 | 20241101114853_RJHle | NZ003E | 2024-11-03T14:12:34.949Z | 2024-11-03T14:19:33.416Z |
5459690 | 5459690 | 20241101113732_ufiRz | NZ003E | 2024-11-03T14:12:28.335Z | 2024-11-03T14:19:33.398Z |
5459666 | 5459666 | 20241101113210_HeVAw | NZ003E | 2024-11-03T14:12:26.302Z | 2024-11-03T14:19:33.393Z |
5459627 | 5459627 | 20241101112533_WYv86 | NZ003E | 2024-11-03T14:12:22.853Z | 2024-11-03T14:19:33.384Z |
5459613 | 5459613 | 20241101112410_Gn4aP | NZ003E | 2024-11-03T14:12:21.788Z | 2024-11-03T14:19:33.380Z |
5459466 | 5459466 | 20241101110254_lcJ8t | NZ003E | 2024-11-03T14:11:58.934Z | 2024-11-03T14:19:33.348Z |
5459274 | 5459274 | 20241101103430_QJu2c | NZ003E | 2024-11-03T14:11:36.758Z | 2024-11-03T14:19:33.310Z |
5459233 | 5459233 | 20241101102639_sdlc4 | NZ003E | 2024-11-03T14:11:32.063Z | 2024-11-03T14:19:33.299Z |
5459082 | 5459082 | 20241101100542_I22Pb | NZ003E | 2024-11-03T14:11:17.369Z | 2024-11-03T14:19:33.264Z |
5459074 | 5459074 | 20241101100442_nOZH5 | NZ003E | 2024-11-03T14:11:16.517Z | 2024-11-03T14:19:33.262Z |
5459034 | 5459034 | 20241101100028_CSxEG | NZ003E | 2024-11-03T14:11:04.312Z | 2024-11-03T14:19:33.254Z |
5458953 | 5458953 | 20241101095052_8hShO | NZ003E | 2024-11-03T14:10:51.961Z | 2024-11-03T14:19:33.237Z |
5458907 | 5458907 | 20241101094106_U8Bve | NZ003E | 2024-11-03T14:10:48.172Z | 2024-11-03T14:19:33.227Z |
5458830 | 5458830 | 20241101092337_woTF6 | NZ003E | 2024-11-03T14:10:40.769Z | 2024-11-03T14:19:33.208Z |
5458826 | 5458826 | 20241101092336_7ke4D | NZ003E | 2024-11-03T14:10:40.608Z | 2024-11-03T14:19:33.207Z |
5458718 | 5458718 | 20241101090546_i4RRs | NZ003E | 2024-11-03T14:10:30.202Z | 2024-11-03T14:19:33.182Z |
5458458 | 5458458 | 20241101082934_nuPHe | NZ003E | 2024-11-03T14:09:47.253Z | 2024-11-03T14:19:33.128Z |
5458333 | 5458333 | 20241101081058_YcxyB | NZ003E | 2024-11-03T14:09:36.408Z | 2024-11-03T14:19:33.106Z |
5457483 | 5457483 | 20241102143639_ov7WT | NZ003E | 2024-11-03T14:07:31.800Z | 2024-11-03T14:07:31.800Z |
5457470 | 5457470 | 20241102143405_G9V6l | NZ003E | 2024-11-03T14:07:24.634Z | 2024-11-03T14:07:24.634Z |
5457459 | 5457459 | 20241102143347_o27AT | NZ003E | 2024-11-03T14:07:22.655Z | 2024-11-03T14:07:22.655Z |
5457437 | 5457437 | 20241102143029_ti26q | NZ003E | 2024-11-03T14:07:19.264Z | 2024-11-03T14:07:19.264Z |
5457399 | 5457399 | 20241102142322_g5i3G | NZ003E | 2024-11-03T14:07:14.497Z | 2024-11-03T14:07:14.497Z |
5457384 | 5457384 | 20241102142254_VGRR3 | NZ003E | 2024-11-03T14:07:12.181Z | 2024-11-03T14:07:12.181Z |
5457376 | 5457376 | 20241102142127_eShV1 | NZ003E | 2024-11-03T14:07:11.341Z | 2024-11-03T14:07:11.341Z |
5457251 | 5457251 | 20241102135831_njFcK | NZ003E | 2024-11-03T14:06:59.566Z | 2024-11-03T14:06:59.566Z |
5457192 | 5457192 | 20241102134444_Gxbhy | NZ003E | 2024-11-03T14:06:44.042Z | 2024-11-03T14:06:44.042Z |
5456056 | 5456056 | 20241102101516_xOuVb | NZ003E | 2024-11-03T14:03:13.356Z | 2024-11-03T14:03:13.356Z |
5449509 | 5449509 | 20241031154541_wLO6O | NZ003E | 2024-11-02T12:13:02.111Z | 2024-11-03T14:20:53.946Z |
5449428 | 5449428 | 20241031153515_BrPpc | NZ003E | 2024-11-02T12:12:52.444Z | 2024-11-03T14:20:52.791Z |
5449376 | 5449376 | 20241031152707_ncGx2 | NZ003E | 2024-11-02T12:12:48.088Z | 2024-11-03T14:20:52.110Z |
5449159 | 5449159 | 20241031150047_tmdTC | NZ003E | 2024-11-02T12:12:10.956Z | 2024-11-03T14:20:49.202Z |
5449049 | 5449049 | 20241031144703_qOupH | NZ003E | 2024-11-02T12:12:00.657Z | 2024-11-03T14:20:47.679Z |
5449006 | 5449006 | 20241031144022_XhjPH | NZ003E | 2024-11-02T12:11:57.174Z | 2024-11-03T14:20:46.696Z |
5448806 | 5448806 | 20241031141755_7M21d | NZ003E | 2024-11-02T12:11:29.925Z | 2024-11-03T14:20:42.682Z |
5448576 | 5448576 | 20241031134910_0hRiY | NZ003E | 2024-11-02T12:11:08.115Z | 2024-11-03T14:20:39.946Z |
5448564 | 5448564 | 20241031134711_3h251 | NZ003E | 2024-11-02T12:11:06.953Z | 2024-11-03T14:20:39.619Z |
5448399 | 5448399 | 20241031132455_22VLI | NZ003E | 2024-11-02T12:10:41.220Z | 2024-11-03T14:20:36.692Z |
5448360 | 5448360 | 20241031132004_L8poH | NZ003E | 2024-11-02T12:10:36.796Z | 2024-11-03T14:20:36.320Z |
5448233 | 5448233 | 20241031130132_VUrNm | NZ003E | 2024-11-02T12:10:23.470Z | 2024-11-03T14:20:34.423Z |
5448231 | 5448231 | 20241031130131_2Aqap | NZ003E | 2024-11-02T12:10:23.184Z | 2024-11-03T14:20:34.395Z |
5448076 | 5448076 | 20241031124133_GZjNs | NZ003E | 2024-11-02T12:09:53.990Z | 2024-11-03T14:20:32.392Z |
5447063 | 5447063 | 20241031110333_dbiYL | NZ003E | 2024-11-02T12:07:05.393Z | 2024-11-03T14:20:15.279Z |
5446906 | 5446906 | 20241031104619_KDXPB | NZ003E | 2024-11-02T12:06:41.812Z | 2024-11-03T14:20:11.629Z |
5446307 | 5446307 | 20241031094706_t2BYl | NZ003E | 2024-11-02T12:04:50.012Z | 2024-11-03T14:20:00.015Z |
5446056 | 5446056 | 20241031092108_ZazVU | NZ003E | 2024-11-02T12:04:05.274Z | 2024-11-03T14:19:54.565Z |
5445970 | 5445970 | 20241031091106_Q2RsC | NZ003E | 2024-11-02T12:03:51.043Z | 2024-11-03T14:19:53.002Z |
5445752 | 5445752 | 20241031084114_7A33U | NZ003E | 2024-11-02T12:03:00.166Z | 2024-11-03T14:19:49.356Z |
5445711 | 5445711 | 20241031083825_sRWoD | NZ003E | 2024-11-02T12:02:53.109Z | 2024-11-03T14:19:48.572Z |
5437790 | 5437790 | 20241030154214_SXrIe | NZ003E | 2024-11-01T12:10:19.716Z | 2024-11-03T14:22:40.591Z |
5437727 | 5437727 | 20241030153741_J22vL | NZ003E | 2024-11-01T12:10:15.518Z | 2024-11-03T14:22:40.394Z |
5436996 | 5436996 | 20241030141618_y2JYi | NZ003E | 2024-11-01T12:08:41.155Z | 2024-11-03T14:22:38.245Z |
5436925 | 5436925 | 20241030140619_GCGgs | NZ003E | 2024-11-01T12:08:36.015Z | 2024-11-03T14:22:38.100Z |
5436826 | 5436826 | 20241030135211_ZRh85 | NZ003E | 2024-11-01T12:08:26.548Z | 2024-11-03T14:22:37.828Z |
5436803 | 5436803 | 20241030134900_VQhFo | NZ003E | 2024-11-01T12:08:24.337Z | 2024-11-03T14:22:37.760Z |
5436534 | 5436534 | 20241030131839_50u4H | NZ003E | 2024-11-01T12:07:50.210Z | 2024-11-03T14:22:37.012Z |
5436448 | 5436448 | 20241030130843_Oc23w | NZ003E | 2024-11-01T12:07:41.359Z | 2024-11-03T14:22:36.695Z |
5436418 | 5436418 | 20241030130511_TsMR5 | NZ003E | 2024-11-01T12:07:31.844Z | 2024-11-03T14:22:36.528Z |
5436390 | 5436390 | 20241030125901_khfBU | NZ003E | 2024-11-01T12:07:26.175Z | 2024-11-03T14:22:36.402Z |
5436337 | 5436337 | 20241030125417_vQS33 | NZ003E | 2024-11-01T12:07:21.080Z | 2024-11-03T14:22:36.308Z |
5436126 | 5436126 | 20241030123046_xTqHU | NZ003E | 2024-11-01T12:06:50.206Z | 2024-11-03T14:22:35.369Z |
5435946 | 5435946 | 20241030121304_S2dnv | NZ003E | 2024-11-01T12:06:25.753Z | 2024-11-03T14:22:34.640Z |
5435454 | 5435454 | 20241030113034_4GTA1 | NZ003E | 2024-11-01T12:05:12.361Z | 2024-11-03T14:22:32.764Z |
5434054 | 5434054 | 20241030081203_rXIVK | NZ003E | 2024-11-01T12:01:03.501Z | 2024-11-03T14:22:15.870Z |
5427879 | 5427879 | 20241028155615_3stMk | NZ003E | 2024-10-31T12:14:08.481Z | 2024-11-03T14:24:49.245Z |
5427852 | 5427852 | 20241028155253_lV8UL | NZ003E | 2024-10-31T12:14:06.561Z | 2024-11-03T14:24:49.211Z |
5427708 | 5427708 | 20241028153522_3Qm6E | NZ003E | 2024-10-31T12:13:50.823Z | 2024-11-03T14:24:48.466Z |
5427587 | 5427587 | 20241028151952_js2oR | NZ003E | 2024-10-31T12:13:39.456Z | 2024-11-03T14:24:48.067Z |
5427523 | 5427523 | 20241028151340_3FAh0 | NZ003E | 2024-10-31T12:13:35.873Z | 2024-11-03T14:24:47.982Z |
5427416 | 5427416 | 20241028150337_B5ZVK | NZ003E | 2024-10-31T12:13:31.096Z | 2024-11-03T14:24:47.643Z |
5427392 | 5427392 | 20241028150155_5Lm5k | NZ003E | 2024-10-31T12:13:30.035Z | 2024-11-03T14:24:47.603Z |
5427276 | 5427276 | 20241028145401_UAc9E | NZ003E | 2024-10-31T12:13:23.852Z | 2024-11-03T14:24:46.507Z |
5427263 | 5427263 | 20241028145227_AGdaf | NZ003E | 2024-10-31T12:13:23.246Z | 2024-11-03T14:24:46.416Z |
5427205 | 5427205 | 20241028144318_3OJrx | NZ003E | 2024-10-31T12:13:19.897Z | 2024-11-03T14:24:46.339Z |
5427201 | 5427201 | 20241028144316_281dX | NZ003E | 2024-10-31T12:13:19.685Z | 2024-11-03T14:24:46.338Z |
5427193 | 5427193 | 20241028144145_Ke99I | NZ003E | 2024-10-31T12:13:19.220Z | 2024-11-03T14:24:46.333Z |
5427133 | 5427133 | 20241028143345_Tj2sR | NZ003E | 2024-10-31T12:13:12.373Z | 2024-11-03T14:24:45.968Z |
5427028 | 5427028 | 20241028142339_kQRvx | NZ003E | 2024-10-31T12:12:55.422Z | 2024-11-03T14:24:45.686Z |
5426981 | 5426981 | 20241028141758_3H9fY | NZ003E | 2024-10-31T12:12:46.046Z | 2024-11-03T14:24:45.573Z |
5426919 | 5426919 | 20241028141036_mQe24 | NZ003E | 2024-10-31T12:12:38.572Z | 2024-11-03T14:24:45.449Z |
5424913 | 5424913 | 20241029153200_qhQMw | NZ003E | 2024-10-31T12:06:29.264Z | 2024-11-03T14:23:39.756Z |
5424723 | 5424723 | 20241029150435_cnrl3 | NZ003E | 2024-10-31T12:05:54.415Z | 2024-11-03T14:23:38.634Z |
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);