participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,173 rows where station_code = "NZ003N" 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 |
---|---|---|---|---|---|
5096978 | 5096978 | 20240912132128_3aGvk | NZ003N | 2024-09-16T12:16:41.276Z | 2024-09-16T12:17:31.987Z |
5096411 | 5096411 | 20240912104613_KwIoD | NZ003N | 2024-09-16T12:16:22.970Z | 2024-09-16T12:17:31.759Z |
5096236 | 5096236 | 20240912102251_7A6HF | NZ003N | 2024-09-16T12:16:16.615Z | 2024-09-16T12:17:31.722Z |
5095990 | 5095990 | 20240912093837_pVfbu | NZ003N | 2024-09-16T12:16:04.379Z | 2024-09-16T12:17:31.661Z |
5095945 | 5095945 | 20240912093121_kOfGJ | NZ003N | 2024-09-16T12:16:02.905Z | 2024-09-16T12:17:31.653Z |
5095379 | 5095379 | 20240912072327_IHsPG | NZ003N | 2024-09-16T12:15:37.981Z | 2024-09-16T12:17:31.515Z |
5083688 | 5083688 | 20240911141204_Si0Tk | NZ003N | 2024-09-15T12:18:45.499Z | 2024-09-16T12:19:20.141Z |
5083673 | 5083673 | 20240911141024_A2pBw | NZ003N | 2024-09-15T12:18:45.395Z | 2024-09-16T12:19:20.102Z |
5083612 | 5083612 | 20240911135715_xkjIf | NZ003N | 2024-09-15T12:18:44.578Z | 2024-09-16T12:19:19.761Z |
5083455 | 5083455 | 20240911132552_xLONI | NZ003N | 2024-09-15T12:18:42.253Z | 2024-09-16T12:19:18.575Z |
5083431 | 5083431 | 20240911131705_KQ2i8 | NZ003N | 2024-09-15T12:18:41.909Z | 2024-09-16T12:19:18.537Z |
5083384 | 5083384 | 20240911130718_QVgLe | NZ003N | 2024-09-15T12:18:40.622Z | 2024-09-16T12:19:18.156Z |
5083226 | 5083226 | 20240911123314_v5dvX | NZ003N | 2024-09-15T12:18:37.077Z | 2024-09-16T12:19:17.268Z |
5083193 | 5083193 | 20240911122151_rjdEH | NZ003N | 2024-09-15T12:18:36.667Z | 2024-09-16T12:19:17.180Z |
5083137 | 5083137 | 20240911121420_l1xvU | NZ003N | 2024-09-15T12:18:36.137Z | 2024-09-16T12:19:16.872Z |
5083027 | 5083027 | 20240911114850_z2HZH | NZ003N | 2024-09-15T12:18:33.791Z | 2024-09-16T12:19:16.363Z |
5082696 | 5082696 | 20240911104449_jsGfO | NZ003N | 2024-09-15T12:18:22.792Z | 2024-09-16T12:19:14.063Z |
5082643 | 5082643 | 20240911103914_zoNsv | NZ003N | 2024-09-15T12:18:21.666Z | 2024-09-16T12:19:13.803Z |
5082520 | 5082520 | 20240911101949_RQQqT | NZ003N | 2024-09-15T12:18:17.103Z | 2024-09-16T12:19:12.623Z |
5082106 | 5082106 | 20240911092401_GDUZ7 | NZ003N | 2024-09-15T12:18:03.714Z | 2024-09-16T12:19:08.981Z |
5081889 | 5081889 | 20240911085938_OW3j2 | NZ003N | 2024-09-15T12:17:53.448Z | 2024-09-16T12:19:06.933Z |
5081754 | 5081754 | 20240911083912_5AIIX | NZ003N | 2024-09-15T12:17:46.158Z | 2024-09-16T12:19:05.475Z |
5081682 | 5081682 | 20240911082402_6MbbD | NZ003N | 2024-09-15T12:17:41.472Z | 2024-09-16T12:19:04.656Z |
5081291 | 5081291 | 20240911071348_7NZWU | NZ003N | 2024-09-15T12:17:29.530Z | 2024-09-16T12:18:59.004Z |
5071529 | 5071529 | 20240911171206_ZE9Tb | NZ003N | 2024-09-15T12:02:49.190Z | 2024-09-16T12:17:28.855Z |
5071471 | 5071471 | 20240911165952_im3ZG | NZ003N | 2024-09-15T12:02:38.754Z | 2024-09-16T12:17:28.839Z |
5071343 | 5071343 | 20240911163554_xYSkP | NZ003N | 2024-09-15T12:02:20.513Z | 2024-09-16T12:17:28.788Z |
5071139 | 5071139 | 20240911160332_HUlVE | NZ003N | 2024-09-15T12:01:45.953Z | 2024-09-16T12:17:28.743Z |
5071087 | 5071087 | 20240911155911_YY3pe | NZ003N | 2024-09-15T12:01:37.567Z | 2024-09-16T12:17:28.730Z |
5071010 | 5071010 | 20240911154135_1xyg1 | NZ003N | 2024-09-15T12:01:21.212Z | 2024-09-16T12:17:28.711Z |
5071006 | 5071006 | 20240911154053_S1lxI | NZ003N | 2024-09-15T12:01:20.774Z | 2024-09-16T12:17:28.711Z |
5070849 | 5070849 | 20240911151546_APycO | NZ003N | 2024-09-15T12:01:00.381Z | 2024-09-16T12:17:28.676Z |
5070803 | 5070803 | 20240911151123_FI0Ja | NZ003N | 2024-09-15T12:00:54.080Z | 2024-09-16T12:17:28.667Z |
5070778 | 5070778 | 20240911151044_q3h7a | NZ003N | 2024-09-15T12:00:48.386Z | 2024-09-16T12:17:28.664Z |
5070731 | 5070731 | 20240911150145_o5F3o | NZ003N | 2024-09-15T12:00:43.233Z | 2024-09-16T12:17:28.655Z |
5070705 | 5070705 | 20240911145640_Kj1OV | NZ003N | 2024-09-15T12:00:38.717Z | 2024-09-16T12:17:28.649Z |
5070573 | 5070573 | 20240911143413_ldNi8 | NZ003N | 2024-09-15T12:00:20.203Z | 2024-09-16T12:17:28.620Z |
5070509 | 5070509 | 20240911142615_wqe4K | NZ003N | 2024-09-15T12:00:11.123Z | 2024-09-16T12:17:28.606Z |
5070497 | 5070497 | 20240911142335_2CWtj | NZ003N | 2024-09-15T12:00:09.191Z | 2024-09-16T12:17:28.602Z |
5070488 | 5070488 | 20240908092738_5qi3V | NZ003N | 2024-09-14T12:21:57.412Z | 2024-09-16T12:21:22.856Z |
5058535 | 5058535 | 20240910162056_siDbn | NZ003N | 2024-09-14T12:03:52.753Z | 2024-09-16T12:17:55.829Z |
5058456 | 5058456 | 20240910161329_ANk2u | NZ003N | 2024-09-14T12:03:44.072Z | 2024-09-16T12:17:54.806Z |
5058419 | 5058419 | 20240910161136_x1KSf | NZ003N | 2024-09-14T12:03:40.378Z | 2024-09-16T12:17:54.288Z |
5058257 | 5058257 | 20240910155927_Y0cjK | NZ003N | 2024-09-14T12:03:17.056Z | 2024-09-16T12:17:52.100Z |
5058210 | 5058210 | 20240910155350_5WMji | NZ003N | 2024-09-14T12:03:09.483Z | 2024-09-16T12:17:51.779Z |
5057902 | 5057902 | 20240910152407_lHGZY | NZ003N | 2024-09-14T12:02:22.126Z | 2024-09-16T12:17:48.268Z |
5057781 | 5057781 | 20240910151321_6MRzd | NZ003N | 2024-09-14T12:01:59.812Z | 2024-09-16T12:17:47.374Z |
5057588 | 5057588 | 20240910145256_phOTG | NZ003N | 2024-09-14T12:01:29.238Z | 2024-09-16T12:17:45.149Z |
5057457 | 5057457 | 20240910143141_vNLpM | NZ003N | 2024-09-14T12:01:06.409Z | 2024-09-16T12:17:44.161Z |
5057162 | 5057162 | 20240910135121_Gpnw5 | NZ003N | 2024-09-14T12:00:23.850Z | 2024-09-16T12:17:39.735Z |
5057094 | 5057094 | 20240908121037_xEYRl | NZ003N | 2024-09-13T12:17:44.809Z | 2024-09-16T12:21:28.767Z |
5057045 | 5057045 | 20240908120056_W5FHt | NZ003N | 2024-09-13T12:17:44.219Z | 2024-09-16T12:21:28.629Z |
5056862 | 5056862 | 20240908113342_JHuOO | NZ003N | 2024-09-13T12:17:40.233Z | 2024-09-16T12:21:27.583Z |
5056765 | 5056765 | 20240908112129_33RjH | NZ003N | 2024-09-13T12:17:39.154Z | 2024-09-16T12:21:27.223Z |
5056754 | 5056754 | 20240908111933_AUNfT | NZ003N | 2024-09-13T12:17:39.060Z | 2024-09-16T12:21:27.155Z |
5056596 | 5056596 | 20240908104844_0Ry3z | NZ003N | 2024-09-13T12:17:36.019Z | 2024-09-16T12:21:26.049Z |
5056362 | 5056362 | 20240908101715_CTBTE | NZ003N | 2024-09-13T12:17:30.804Z | 2024-09-16T12:21:24.547Z |
5056325 | 5056325 | 20240908101215_DtW67 | NZ003N | 2024-09-13T12:17:30.329Z | 2024-09-16T12:21:24.432Z |
5056105 | 5056105 | 20240908094239_7hM5K | NZ003N | 2024-09-13T12:17:27.510Z | 2024-09-16T12:21:23.303Z |
5056073 | 5056073 | 20240908093702_yeOE7 | NZ003N | 2024-09-13T12:17:27.330Z | 2024-09-16T12:21:23.136Z |
5055995 | 5055995 | 20240908093044_PfpT5 | NZ003N | 2024-09-13T12:17:26.462Z | 2024-09-16T12:21:22.992Z |
5055699 | 5055699 | 20240908084217_CF8g1 | NZ003N | 2024-09-13T12:17:20.436Z | 2024-09-16T12:21:21.654Z |
5055485 | 5055485 | 20240908081007_CBZVg | NZ003N | 2024-09-13T12:17:15.251Z | 2024-09-16T12:21:19.951Z |
5055305 | 5055305 | 20240908074505_uXi3F | NZ003N | 2024-09-13T12:17:09.374Z | 2024-09-16T12:21:18.677Z |
5055236 | 5055236 | 20240908073022_tGeqL | NZ003N | 2024-09-13T12:17:08.265Z | 2024-09-16T12:21:18.511Z |
5051492 | 5051492 | 20240907173418_uYuaS | NZ003N | 2024-09-13T12:14:18.886Z | 2024-09-16T12:21:00.576Z |
5051257 | 5051257 | 20240907171003_GpiPS | NZ003N | 2024-09-13T12:14:08.103Z | 2024-09-16T12:20:59.939Z |
5051136 | 5051136 | 20240907165258_1M0fK | NZ003N | 2024-09-13T12:14:03.483Z | 2024-09-16T12:20:59.637Z |
5051101 | 5051101 | 20240907164745_y1R7l | NZ003N | 2024-09-13T12:14:01.751Z | 2024-09-16T12:20:59.583Z |
5050770 | 5050770 | 20240907160602_LgXTI | NZ003N | 2024-09-13T12:13:46.497Z | 2024-09-16T12:20:58.501Z |
5050602 | 5050602 | 20240907154700_A0GiJ | NZ003N | 2024-09-13T12:13:38.497Z | 2024-09-16T12:20:58.083Z |
5050572 | 5050572 | 20240907154144_Tjvg0 | NZ003N | 2024-09-13T12:13:37.332Z | 2024-09-16T12:20:58.039Z |
5050470 | 5050470 | 20240907152346_L9JWP | NZ003N | 2024-09-13T12:13:32.811Z | 2024-09-16T12:20:57.742Z |
5050465 | 5050465 | 20240907152331_Ybno6 | NZ003N | 2024-09-13T12:13:32.720Z | 2024-09-16T12:20:57.730Z |
5050372 | 5050372 | 20240907151449_MD5yK | NZ003N | 2024-09-13T12:13:28.956Z | 2024-09-16T12:20:57.386Z |
5050294 | 5050294 | 20240907150453_dZbm8 | NZ003N | 2024-09-13T12:13:22.906Z | 2024-09-16T12:20:56.961Z |
5050176 | 5050176 | 20240907144539_fUF36 | NZ003N | 2024-09-13T12:13:15.505Z | 2024-09-16T12:20:56.632Z |
5045387 | 5045387 | 20240908165944_UM612 | NZ003N | 2024-09-13T12:04:04.845Z | 2024-09-16T12:20:25.575Z |
5045338 | 5045338 | 20240908165302_5C37m | NZ003N | 2024-09-13T12:04:00.473Z | 2024-09-16T12:20:25.453Z |
5045303 | 5045303 | 20240908165117_YYrBG | NZ003N | 2024-09-13T12:03:55.403Z | 2024-09-16T12:20:25.423Z |
5045277 | 5045277 | 20240908164852_Za6bf | NZ003N | 2024-09-13T12:03:50.182Z | 2024-09-16T12:20:25.306Z |
5045218 | 5045218 | 20240908163543_Igvyg | NZ003N | 2024-09-13T12:03:43.059Z | 2024-09-16T12:20:24.983Z |
5045162 | 5045162 | 20240908162730_3H2WI | NZ003N | 2024-09-13T12:03:36.996Z | 2024-09-16T12:20:24.813Z |
5045094 | 5045094 | 20240908161545_9a25V | NZ003N | 2024-09-13T12:03:32.520Z | 2024-09-16T12:20:24.495Z |
5045072 | 5045072 | 20240908161455_i53ky | NZ003N | 2024-09-13T12:03:30.582Z | 2024-09-16T12:20:24.458Z |
5044954 | 5044954 | 20240908155805_7zaPc | NZ003N | 2024-09-13T12:03:16.651Z | 2024-09-16T12:20:23.916Z |
5044950 | 5044950 | 20240908155730_EO86h | NZ003N | 2024-09-13T12:03:15.355Z | 2024-09-16T12:20:23.905Z |
5044855 | 5044855 | 20240908155017_fGGxb | NZ003N | 2024-09-13T12:03:03.167Z | 2024-09-16T12:20:23.603Z |
5044793 | 5044793 | 20240908154415_ixRm8 | NZ003N | 2024-09-13T12:02:57.423Z | 2024-09-16T12:20:23.541Z |
5044783 | 5044783 | 20240908154317_PFm08 | NZ003N | 2024-09-13T12:02:56.289Z | 2024-09-16T12:20:23.533Z |
5044773 | 5044773 | 20240908154053_3YMcg | NZ003N | 2024-09-13T12:02:55.056Z | 2024-09-16T12:20:23.526Z |
5044726 | 5044726 | 20240908153513_MFMvz | NZ003N | 2024-09-13T12:02:51.372Z | 2024-09-16T12:20:23.431Z |
5044615 | 5044615 | 20240908152209_sQx02 | NZ003N | 2024-09-13T12:02:33.727Z | 2024-09-16T12:20:22.830Z |
5044607 | 5044607 | 20240908152127_mPbFe | NZ003N | 2024-09-13T12:02:29.872Z | 2024-09-16T12:20:22.802Z |
5044523 | 5044523 | 20240908151040_pcphH | NZ003N | 2024-09-13T12:02:19.810Z | 2024-09-16T12:20:22.487Z |
5044436 | 5044436 | 20240908150149_jMYOL | NZ003N | 2024-09-13T12:02:11.393Z | 2024-09-16T12:20:21.939Z |
5044089 | 5044089 | 20240908141228_UaK35 | NZ003N | 2024-09-13T12:01:26.754Z | 2024-09-16T12:20:19.893Z |
5044020 | 5044020 | 20240908135400_7I1Jm | NZ003N | 2024-09-13T12:01:15.906Z | 2024-09-16T12:20:19.685Z |
5043988 | 5043988 | 20240908134620_dB7gk | NZ003N | 2024-09-13T12:01:09.252Z | 2024-09-16T12:20:19.584Z |
5043959 | 5043959 | 20240908134136_VVWTX | NZ003N | 2024-09-13T12:01:03.784Z | 2024-09-16T12:20:19.567Z |
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);