participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,207 rows where station_code = "NZ0022" 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 |
---|---|---|---|---|---|
5056933 | 5056933 | 20240908114309_rvsuM | NZ0022 | 2024-09-13T12:17:41.311Z | 2024-09-16T12:21:27.905Z |
5056922 | 5056922 | 20240908114242_JO2p7 | NZ0022 | 2024-09-13T12:17:41.283Z | 2024-09-16T12:21:27.862Z |
5056788 | 5056788 | 20240908112726_dv5GQ | NZ0022 | 2024-09-13T12:17:39.390Z | 2024-09-16T12:21:27.310Z |
5056509 | 5056509 | 20240908103717_FyeRI | NZ0022 | 2024-09-13T12:17:34.255Z | 2024-09-16T12:21:25.711Z |
5056147 | 5056147 | 20240908094710_j3vtz | NZ0022 | 2024-09-13T12:17:27.994Z | 2024-09-16T12:21:23.593Z |
5056022 | 5056022 | 20240908093217_wVjhL | NZ0022 | 2024-09-13T12:17:26.840Z | 2024-09-16T12:21:23.044Z |
5055708 | 5055708 | 20240908084545_SzyXK | NZ0022 | 2024-09-13T12:17:20.710Z | 2024-09-16T12:21:21.671Z |
5043866 | 5043866 | 20240908132723_sBi0q | NZ0022 | 2024-09-13T12:00:51.221Z | 2024-09-17T12:18:52.961Z |
5043784 | 5043784 | 20240908130648_oHHtH | NZ0022 | 2024-09-13T12:00:39.952Z | 2024-09-17T12:18:52.830Z |
5043766 | 5043766 | 20240908130309_8Ae4j | NZ0022 | 2024-09-13T12:00:35.930Z | 2024-09-17T12:18:52.819Z |
5043735 | 5043735 | 20240908125358_c2W0i | NZ0022 | 2024-09-13T12:00:32.404Z | 2024-09-17T12:18:52.783Z |
5043700 | 5043700 | 20240908124423_3X688 | NZ0022 | 2024-09-13T12:00:26.776Z | 2024-09-17T12:18:52.709Z |
5043647 | 5043647 | 20240908123214_Zh52Z | NZ0022 | 2024-09-13T12:00:19.529Z | 2024-09-17T12:18:52.567Z |
5043602 | 5043602 | 20240908121938_GYWA1 | NZ0022 | 2024-09-13T12:00:12.591Z | 2024-09-17T12:18:52.469Z |
5038182 | 5038182 | 20240905173803_gosz1 | NZ0022 | 2024-09-12T12:14:25.138Z | 2024-09-14T12:22:55.250Z |
5038112 | 5038112 | 20240905172644_a6F24 | NZ0022 | 2024-09-12T12:14:23.047Z | 2024-09-14T12:22:55.083Z |
5038037 | 5038037 | 20240905171706_Cz9XY | NZ0022 | 2024-09-12T12:14:20.752Z | 2024-09-14T12:22:54.940Z |
5038014 | 5038014 | 20240905171453_Azg31 | NZ0022 | 2024-09-12T12:14:19.987Z | 2024-09-14T12:22:54.919Z |
5037930 | 5037930 | 20240905170606_DCvs5 | NZ0022 | 2024-09-12T12:14:17.592Z | 2024-09-14T12:22:54.804Z |
5037907 | 5037907 | 20240905170319_2gCK6 | NZ0022 | 2024-09-12T12:14:17.064Z | 2024-09-14T12:22:54.778Z |
5037884 | 5037884 | 20240905165917_K3Boq | NZ0022 | 2024-09-12T12:14:16.794Z | 2024-09-14T12:22:54.758Z |
5037827 | 5037827 | 20240905165402_lzVW1 | NZ0022 | 2024-09-12T12:14:15.880Z | 2024-09-14T12:22:54.648Z |
5037800 | 5037800 | 20240905165216_5HIAD | NZ0022 | 2024-09-12T12:14:15.678Z | 2024-09-14T12:22:54.640Z |
5037768 | 5037768 | 20240905164921_sGAI4 | NZ0022 | 2024-09-12T12:14:15.242Z | 2024-09-14T12:22:54.619Z |
5037731 | 5037731 | 20240905164310_0UWHv | NZ0022 | 2024-09-12T12:14:14.661Z | 2024-09-14T12:22:54.542Z |
5037704 | 5037704 | 20240905164139_6oP8Q | NZ0022 | 2024-09-12T12:14:14.452Z | 2024-09-14T12:22:54.533Z |
5037572 | 5037572 | 20240905161018_acAy3 | NZ0022 | 2024-09-12T12:14:09.701Z | 2024-09-14T12:22:54.310Z |
5037533 | 5037533 | 20240905160348_K3EH4 | NZ0022 | 2024-09-12T12:14:08.273Z | 2024-09-14T12:22:54.289Z |
5037515 | 5037515 | 20240905160311_Gz2hc | NZ0022 | 2024-09-12T12:14:07.897Z | 2024-09-14T12:22:54.281Z |
5037458 | 5037458 | 20240905155721_IVemA | NZ0022 | 2024-09-12T12:14:07.072Z | 2024-09-14T12:22:54.217Z |
5037233 | 5037233 | 20240905152731_Y7asf | NZ0022 | 2024-09-12T12:14:03.394Z | 2024-09-14T12:22:54.003Z |
5037048 | 5037048 | 20240905145934_GWFsN | NZ0022 | 2024-09-12T12:13:59.806Z | 2024-09-14T12:22:53.650Z |
5037027 | 5037027 | 20240905145553_92Z7z | NZ0022 | 2024-09-12T12:13:59.346Z | 2024-09-14T12:22:53.629Z |
5036975 | 5036975 | 20240905145009_b7pk8 | NZ0022 | 2024-09-12T12:13:58.419Z | 2024-09-14T12:22:53.594Z |
5036808 | 5036808 | 20240905142853_TL2tu | NZ0022 | 2024-09-12T12:13:55.130Z | 2024-09-14T12:22:53.284Z |
5036758 | 5036758 | 20240905142413_zAqJV | NZ0022 | 2024-09-12T12:13:54.042Z | 2024-09-14T12:22:53.199Z |
5036698 | 5036698 | 20240905141816_o8m53 | NZ0022 | 2024-09-12T12:13:52.586Z | 2024-09-14T12:22:53.110Z |
5036657 | 5036657 | 20240905141303_2lMj3 | NZ0022 | 2024-09-12T12:13:51.709Z | 2024-09-14T12:22:53.081Z |
5036524 | 5036524 | 20240905134226_zm4FC | NZ0022 | 2024-09-12T12:13:45.637Z | 2024-09-14T12:22:52.532Z |
5036272 | 5036272 | 20240905130920_5s6OW | NZ0022 | 2024-09-12T12:13:32.144Z | 2024-09-14T12:22:52.200Z |
5036268 | 5036268 | 20240905130918_iYl4x | NZ0022 | 2024-09-12T12:13:32.091Z | 2024-09-14T12:22:52.194Z |
5036258 | 5036258 | 20240905130728_jDqEi | NZ0022 | 2024-09-12T12:13:31.315Z | 2024-09-14T12:22:52.168Z |
5036180 | 5036180 | 20240905125225_HKhBQ | NZ0022 | 2024-09-12T12:13:28.142Z | 2024-09-14T12:22:51.972Z |
5036111 | 5036111 | 20240905124239_LC97y | NZ0022 | 2024-09-12T12:13:24.329Z | 2024-09-14T12:22:51.901Z |
5036072 | 5036072 | 20240905123647_TYBgE | NZ0022 | 2024-09-12T12:13:22.525Z | 2024-09-14T12:22:51.841Z |
5029062 | 5029062 | 20240905112718_tX5lK | NZ0022 | 2024-09-11T12:16:08.906Z | 2024-09-14T12:22:50.572Z |
5028602 | 5028602 | 20240905102640_30Fxh | NZ0022 | 2024-09-11T12:15:36.814Z | 2024-09-14T12:22:48.429Z |
5028363 | 5028363 | 20240905093116_AuzFJ | NZ0022 | 2024-09-11T12:15:12.098Z | 2024-09-13T12:20:06.056Z |
5028290 | 5028290 | 20240905092435_2ejZl | NZ0022 | 2024-09-11T12:15:07.275Z | 2024-09-13T12:20:05.905Z |
5028239 | 5028239 | 20240905091800_D7eBe | NZ0022 | 2024-09-11T12:15:03.476Z | 2024-09-13T12:20:05.834Z |
5028173 | 5028173 | 20240905091103_GpM47 | NZ0022 | 2024-09-11T12:14:56.495Z | 2024-09-13T12:20:05.638Z |
5028003 | 5028003 | 20240905085221_7USPc | NZ0022 | 2024-09-11T12:14:42.885Z | 2024-09-13T12:20:05.144Z |
5027824 | 5027824 | 20240905082723_JBlow | NZ0022 | 2024-09-11T12:14:33.522Z | 2024-09-13T12:20:04.750Z |
5027708 | 5027708 | 20240905081218_dN7L2 | NZ0022 | 2024-09-11T12:14:25.462Z | 2024-09-13T12:20:04.297Z |
5027660 | 5027660 | 20240905080542_89H1o | NZ0022 | 2024-09-11T12:14:22.711Z | 2024-09-13T12:20:04.190Z |
5027647 | 5027647 | 20240905080424_3oU32 | NZ0022 | 2024-09-11T12:14:22.226Z | 2024-09-13T12:20:04.151Z |
5024000 | 5024000 | 20240905173803_cHHYr | NZ0022 | 2024-09-11T12:02:17.197Z | 2024-09-11T12:16:31.882Z |
5023942 | 5023942 | 20240905172644_GIYMA | NZ0022 | 2024-09-10T12:16:52.357Z | 2024-09-11T12:16:31.856Z |
5023876 | 5023876 | 20240905171706_YXOoD | NZ0022 | 2024-09-10T12:16:51.337Z | 2024-09-14T12:22:54.940Z |
5023857 | 5023857 | 20240905171453_93OQP | NZ0022 | 2024-09-10T12:16:51.165Z | 2024-09-11T12:16:31.819Z |
5023771 | 5023771 | 20240905170606_K6acQ | NZ0022 | 2024-09-10T12:16:50.146Z | 2024-09-11T12:16:31.780Z |
5023748 | 5023748 | 20240905170319_U6Pd2 | NZ0022 | 2024-09-10T12:16:49.816Z | 2024-09-11T12:16:31.766Z |
5023727 | 5023727 | 20240905165917_Sp0D4 | NZ0022 | 2024-09-10T12:16:49.682Z | 2024-09-11T12:16:31.757Z |
5023673 | 5023673 | 20240905165402_s7vgC | NZ0022 | 2024-09-10T12:16:49.015Z | 2024-09-11T12:16:31.740Z |
5023622 | 5023622 | 20240905164921_7nC11 | NZ0022 | 2024-09-10T12:16:48.479Z | 2024-09-14T12:22:54.617Z |
5023589 | 5023589 | 20240905164310_ajBTm | NZ0022 | 2024-09-10T12:16:48.010Z | 2024-09-11T12:16:31.714Z |
5023562 | 5023562 | 20240905164139_PWb3E | NZ0022 | 2024-09-10T12:16:47.790Z | 2024-09-14T12:22:54.535Z |
5023445 | 5023445 | 20240905161018_z2qj1 | NZ0022 | 2024-09-10T12:16:45.239Z | 2024-09-11T12:16:31.661Z |
5023408 | 5023408 | 20240905160348_mjg2d | NZ0022 | 2024-09-10T12:16:44.647Z | 2024-09-11T12:16:31.648Z |
5023390 | 5023390 | 20240905160311_Vkl99 | NZ0022 | 2024-09-10T12:16:44.331Z | 2024-09-11T12:16:31.643Z |
5023333 | 5023333 | 20240905155721_5luLe | NZ0022 | 2024-09-10T12:16:43.839Z | 2024-09-14T12:22:54.217Z |
5023122 | 5023122 | 20240905152731_l72LE | NZ0022 | 2024-09-10T12:16:39.288Z | 2024-09-11T12:16:31.541Z |
5022798 | 5022798 | 20240905093116_w23hF | NZ0022 | 2024-09-10T12:16:30.015Z | 2024-09-10T12:16:55.616Z |
5022725 | 5022725 | 20240905092435_TrRbb | NZ0022 | 2024-09-10T12:16:28.549Z | 2024-09-10T12:16:55.604Z |
5022675 | 5022675 | 20240905091800_cekrS | NZ0022 | 2024-09-10T12:16:27.008Z | 2024-09-10T12:16:55.595Z |
5022609 | 5022609 | 20240905091103_lWI1b | NZ0022 | 2024-09-10T12:16:24.924Z | 2024-09-10T12:16:55.582Z |
5022444 | 5022444 | 20240905085221_Sxwd4 | NZ0022 | 2024-09-10T12:16:18.741Z | 2024-09-10T12:16:55.554Z |
5022440 | 5022440 | 20240905085210_4rsZv | NZ0022 | 2024-09-10T12:16:18.658Z | 2024-09-13T12:20:05.141Z |
5022270 | 5022270 | 20240905082723_juNWs | NZ0022 | 2024-09-10T12:16:13.064Z | 2024-09-10T12:16:55.525Z |
5022149 | 5022149 | 20240905081218_p8vGr | NZ0022 | 2024-09-10T12:16:08.127Z | 2024-09-13T12:20:04.294Z |
5022101 | 5022101 | 20240905080542_wpmTK | NZ0022 | 2024-09-10T12:16:05.180Z | 2024-09-10T12:16:55.493Z |
5022088 | 5022088 | 20240905080424_60cUp | NZ0022 | 2024-09-10T12:16:04.763Z | 2024-09-10T12:16:55.492Z |
5017835 | 5017835 | 20240904164523_XI2JU | NZ0022 | 2024-09-10T12:09:37.341Z | 2024-09-13T12:19:47.098Z |
5017782 | 5017782 | 20240904164117_qS04G | NZ0022 | 2024-09-10T12:09:31.216Z | 2024-09-13T12:19:47.079Z |
5017761 | 5017761 | 20240904163908_8Qu2Q | NZ0022 | 2024-09-10T12:09:29.953Z | 2024-09-13T12:19:47.073Z |
5017648 | 5017648 | 20240904162820_nBYu7 | NZ0022 | 2024-09-10T12:09:21.429Z | 2024-09-13T12:19:47.032Z |
5017466 | 5017466 | 20240904161107_bk033 | NZ0022 | 2024-09-10T12:09:11.780Z | 2024-09-13T12:19:46.890Z |
5017421 | 5017421 | 20240904160759_7LugC | NZ0022 | 2024-09-10T12:09:10.029Z | 2024-09-13T12:19:46.870Z |
5017366 | 5017366 | 20240904160240_o52dS | NZ0022 | 2024-09-10T12:09:06.010Z | 2024-09-13T12:19:46.807Z |
5017346 | 5017346 | 20240904155926_j876M | NZ0022 | 2024-09-10T12:09:04.626Z | 2024-09-13T12:19:46.801Z |
5017208 | 5017208 | 20240904154155_3aQzY | NZ0022 | 2024-09-10T12:08:56.355Z | 2024-09-13T12:19:46.645Z |
5016935 | 5016935 | 20240904151238_A5GUW | NZ0022 | 2024-09-10T12:08:33.473Z | 2024-09-13T12:19:46.455Z |
5016859 | 5016859 | 20240904150608_gNVdt | NZ0022 | 2024-09-10T12:08:25.893Z | 2024-09-13T12:19:46.399Z |
5016741 | 5016741 | 20240904144905_8XtYH | NZ0022 | 2024-09-10T12:08:14.104Z | 2024-09-13T12:19:46.252Z |
5016271 | 5016271 | 20240904135250_65aKe | NZ0022 | 2024-09-10T12:07:37.927Z | 2024-09-13T12:19:45.404Z |
5016216 | 5016216 | 20240904134517_ScGL9 | NZ0022 | 2024-09-10T12:07:34.576Z | 2024-09-13T12:19:45.348Z |
5016173 | 5016173 | 20240904134031_TTPm9 | NZ0022 | 2024-09-10T12:07:31.721Z | 2024-09-13T12:19:45.302Z |
5016086 | 5016086 | 20240904132949_o2QyA | NZ0022 | 2024-09-10T12:07:19.954Z | 2024-09-13T12:19:45.242Z |
5016034 | 5016034 | 20240904132347_rdoC4 | NZ0022 | 2024-09-10T12:07:14.981Z | 2024-09-13T12:19:45.142Z |
5015808 | 5015808 | 20240904123935_YI17B | NZ0022 | 2024-09-10T12:06:48.263Z | 2024-09-13T12:19:44.714Z |
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);