participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,944 rows where station_code = "NZ003F" 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 |
---|---|---|---|---|---|
4645191 | 4645191 | 20240714152548_0uTYY | NZ003F | 2024-07-17T12:03:54.756Z | 2024-07-23T12:08:36.218Z |
4636914 | 4636914 | 20240714140726_BrbHc | NZ003F | 2024-07-16T12:02:04.197Z | 2024-07-23T12:08:35.559Z |
4636870 | 4636870 | 20240714135042_IUfef | NZ003F | 2024-07-16T12:02:00.914Z | 2024-07-23T12:08:35.431Z |
4636831 | 4636831 | 20240714134138_N4fQo | NZ003F | 2024-07-16T12:01:58.718Z | 2024-07-23T12:08:35.369Z |
4636791 | 4636791 | 20240714131834_ujv2H | NZ003F | 2024-07-16T12:01:56.225Z | 2024-07-23T12:08:35.299Z |
4636717 | 4636717 | 20240714124427_VtcGT | NZ003F | 2024-07-16T12:01:50.873Z | 2024-07-23T12:08:35.131Z |
4636702 | 4636702 | 20240714123428_1IY8M | NZ003F | 2024-07-16T12:01:49.960Z | 2024-07-23T12:08:35.091Z |
4636688 | 4636688 | 20240714122359_x68Rm | NZ003F | 2024-07-16T12:01:49.209Z | 2024-07-23T12:08:35.088Z |
4636388 | 4636388 | 20240714100824_12X4G | NZ003F | 2024-07-16T12:01:25.480Z | 2024-07-23T12:08:34.101Z |
4636278 | 4636278 | 20240714094324_7WbGN | NZ003F | 2024-07-16T12:01:16.142Z | 2024-07-23T12:08:33.654Z |
4633841 | 4633841 | 20240712171725_1Nl4u | NZ003F | 2024-07-15T12:06:08.475Z | 2024-07-21T12:13:27.060Z |
4618161 | 4618161 | 20240710185210_FVeo4 | NZ003F | 2024-07-13T12:07:18.296Z | 2024-07-19T12:13:38.092Z |
4618061 | 4618061 | 20240710183541_880Ap | NZ003F | 2024-07-13T12:07:12.987Z | 2024-07-19T12:13:38.037Z |
4617926 | 4617926 | 20240710182510_0C02W | NZ003F | 2024-07-13T12:07:06.761Z | 2024-07-19T12:13:37.960Z |
4617808 | 4617808 | 20240710181536_YaIQA | NZ003F | 2024-07-13T12:07:01.231Z | 2024-07-19T12:13:37.837Z |
4617722 | 4617722 | 20240710180733_lRQZM | NZ003F | 2024-07-13T12:06:54.917Z | 2024-07-19T12:13:37.734Z |
4617484 | 4617484 | 20240710174959_DODA5 | NZ003F | 2024-07-13T12:06:48.480Z | 2024-07-19T12:13:37.544Z |
4617433 | 4617433 | 20240710174502_YaxMT | NZ003F | 2024-07-13T12:06:47.140Z | 2024-07-19T12:13:37.509Z |
4617398 | 4617398 | 20240710173800_7haSE | NZ003F | 2024-07-13T12:06:46.271Z | 2024-07-19T12:13:37.502Z |
4617302 | 4617302 | 20240710172736_Wi5nK | NZ003F | 2024-07-13T12:06:43.556Z | 2024-07-19T12:13:37.446Z |
4617170 | 4617170 | 20240710171541_pz6yR | NZ003F | 2024-07-13T12:06:40.296Z | 2024-07-19T12:13:37.300Z |
4617005 | 4617005 | 20240710170341_hNRJj | NZ003F | 2024-07-13T12:06:35.719Z | 2024-07-19T12:13:37.162Z |
4616916 | 4616916 | 20240710165421_k7S73 | NZ003F | 2024-07-13T12:06:30.718Z | 2024-07-19T12:13:37.135Z |
4616855 | 4616855 | 20240710164945_BjmLR | NZ003F | 2024-07-13T12:06:25.590Z | 2024-07-19T12:13:37.125Z |
4616830 | 4616830 | 20240710164853_jpI2n | NZ003F | 2024-07-13T12:06:22.887Z | 2024-07-19T12:13:37.107Z |
4616777 | 4616777 | 20240710164444_uJAUV | NZ003F | 2024-07-13T12:06:18.818Z | 2024-07-19T12:13:37.087Z |
4616681 | 4616681 | 20240710163226_GWGxJ | NZ003F | 2024-07-13T12:06:13.259Z | 2024-07-19T12:13:36.958Z |
4616563 | 4616563 | 20240710162402_N2L8u | NZ003F | 2024-07-13T12:06:07.363Z | 2024-07-19T12:13:36.911Z |
4616540 | 4616540 | 20240710162208_31ReX | NZ003F | 2024-07-13T12:06:06.746Z | 2024-07-19T12:13:36.890Z |
4616517 | 4616517 | 20240710162019_eQDrP | NZ003F | 2024-07-13T12:06:05.792Z | 2024-07-19T12:13:36.887Z |
4616503 | 4616503 | 20240710161911_2Vwfo | NZ003F | 2024-07-13T12:06:05.495Z | 2024-07-19T12:13:36.877Z |
4616409 | 4616409 | 20240710160820_qi7xd | NZ003F | 2024-07-13T12:06:01.245Z | 2024-07-19T12:13:36.843Z |
4616254 | 4616254 | 20240710155505_PGyns | NZ003F | 2024-07-13T12:05:52.572Z | 2024-07-19T12:13:36.779Z |
4616082 | 4616082 | 20240710154148_o8TJc | NZ003F | 2024-07-13T12:05:44.425Z | 2024-07-19T12:13:36.651Z |
4616043 | 4616043 | 20240710153954_d3EVF | NZ003F | 2024-07-13T12:05:43.060Z | 2024-07-19T12:13:36.631Z |
4615940 | 4615940 | 20240710153113_WAoei | NZ003F | 2024-07-13T12:05:38.039Z | 2024-07-19T12:13:36.546Z |
4615636 | 4615636 | 20240710150750_T3MGK | NZ003F | 2024-07-13T12:05:18.307Z | 2024-07-19T12:13:36.340Z |
4615039 | 4615039 | 20240710141710_MBHr5 | NZ003F | 2024-07-13T12:04:49.185Z | 2024-07-19T12:13:35.885Z |
4614681 | 4614681 | 20240710133936_iQvbT | NZ003F | 2024-07-13T12:04:31.840Z | 2024-07-19T12:13:35.646Z |
4614561 | 4614561 | 20240710132750_Zo9bp | NZ003F | 2024-07-13T12:04:23.403Z | 2024-07-19T12:13:35.601Z |
4614520 | 4614520 | 20240710132504_b4cZm | NZ003F | 2024-07-13T12:04:21.027Z | 2024-07-19T12:13:35.595Z |
4614512 | 4614512 | 20240710132353_sL2O3 | NZ003F | 2024-07-13T12:04:20.496Z | 2024-07-19T12:13:35.593Z |
4614328 | 4614328 | 20240710130012_c6qWe | NZ003F | 2024-07-13T12:04:07.114Z | 2024-07-19T12:13:35.447Z |
4614319 | 4614319 | 20240710130011_Ztp3J | NZ003F | 2024-07-13T12:04:06.923Z | 2024-07-19T12:13:35.447Z |
4612833 | 4612833 | 20240710071538_vERD3 | NZ003F | 2024-07-13T12:02:04.757Z | 2024-07-19T12:13:30.589Z |
4612590 | 4612590 | 20240711081434_zdJEs | NZ003F | 2024-07-13T12:01:11.267Z | 2024-07-20T12:13:06.670Z |
4609441 | 4609441 | 20240709155428_r7raB | NZ003F | 2024-07-12T12:05:55.857Z | 2024-07-18T12:16:48.021Z |
4609281 | 4609281 | 20240709153603_zdIIX | NZ003F | 2024-07-12T12:05:53.237Z | 2024-07-18T12:16:47.911Z |
4609242 | 4609242 | 20240709153405_oLjgv | NZ003F | 2024-07-12T12:05:52.767Z | 2024-07-18T12:16:47.897Z |
4608766 | 4608766 | 20240709143954_qDppO | NZ003F | 2024-07-12T12:05:42.685Z | 2024-07-18T12:16:47.014Z |
4608652 | 4608652 | 20240709142732_UdwSp | NZ003F | 2024-07-12T12:05:40.630Z | 2024-07-18T12:16:46.670Z |
4608606 | 4608606 | 20240709142258_BHVEK | NZ003F | 2024-07-12T12:05:40.045Z | 2024-07-18T12:16:46.654Z |
4608396 | 4608396 | 20240709135631_0HFJ3 | NZ003F | 2024-07-12T12:05:35.441Z | 2024-07-18T12:16:46.091Z |
4608102 | 4608102 | 20240709131621_tT6MA | NZ003F | 2024-07-12T12:05:28.991Z | 2024-07-18T12:16:45.676Z |
4607975 | 4607975 | 20240709130145_ItIZp | NZ003F | 2024-07-12T12:05:23.078Z | 2024-07-18T12:16:45.492Z |
4607132 | 4607132 | 20240709111427_mn552 | NZ003F | 2024-07-12T12:05:00.633Z | 2024-07-18T12:16:42.433Z |
4607020 | 4607020 | 20240709105929_FCTuM | NZ003F | 2024-07-12T12:04:52.484Z | 2024-07-18T12:16:42.036Z |
4606918 | 4606918 | 20240709105153_3WLjg | NZ003F | 2024-07-12T12:04:49.544Z | 2024-07-18T12:16:41.635Z |
4606497 | 4606497 | 20240709100929_JnZBR | NZ003F | 2024-07-12T12:04:34.576Z | 2024-07-18T12:16:40.312Z |
4606241 | 4606241 | 20240709093859_1H335 | NZ003F | 2024-07-12T12:04:22.196Z | 2024-07-18T12:16:39.411Z |
4606210 | 4606210 | 20240709093416_bOzeO | NZ003F | 2024-07-12T12:04:21.002Z | 2024-07-18T12:16:39.364Z |
4605575 | 4605575 | 20240709082451_oz2SD | NZ003F | 2024-07-12T12:03:49.544Z | 2024-07-18T12:16:35.034Z |
4602179 | 4602179 | 20240708184731_2ttZs | NZ003F | 2024-07-11T12:08:46.294Z | 2024-07-16T12:09:22.016Z |
4602130 | 4602130 | 20240708184055_uy1y2 | NZ003F | 2024-07-11T12:08:45.548Z | 2024-07-16T12:09:21.999Z |
4602093 | 4602093 | 20240708183648_z8jUc | NZ003F | 2024-07-11T12:08:44.795Z | 2024-07-16T12:09:21.992Z |
4601987 | 4601987 | 20240708182238_wy6y9 | NZ003F | 2024-07-11T12:08:41.550Z | 2024-07-16T12:09:21.772Z |
4601453 | 4601453 | 20240708173458_sEESP | NZ003F | 2024-07-11T12:08:25.775Z | 2024-07-16T12:09:21.359Z |
4601325 | 4601325 | 20240708172624_2OJii | NZ003F | 2024-07-11T12:08:22.310Z | 2024-07-16T12:09:21.283Z |
4601263 | 4601263 | 20240708171933_ZrfWi | NZ003F | 2024-07-11T12:08:17.427Z | 2024-07-16T12:09:21.246Z |
4601116 | 4601116 | 20240708170424_86zS9 | NZ003F | 2024-07-11T12:08:06.114Z | 2024-07-16T12:09:21.143Z |
4601045 | 4601045 | 20240708165641_Z4pN1 | NZ003F | 2024-07-11T12:08:02.726Z | 2024-07-16T12:09:21.106Z |
4600944 | 4600944 | 20240708164756_IvVMn | NZ003F | 2024-07-11T12:07:55.337Z | 2024-07-16T12:09:21.015Z |
4600782 | 4600782 | 20240708163206_shQu3 | NZ003F | 2024-07-11T12:07:46.143Z | 2024-07-16T12:09:20.892Z |
4600765 | 4600765 | 20240708162926_KxTZ7 | NZ003F | 2024-07-11T12:07:45.197Z | 2024-07-16T12:09:20.885Z |
4600751 | 4600751 | 20240708162628_PYjDO | NZ003F | 2024-07-11T12:07:44.506Z | 2024-07-16T12:09:20.880Z |
4600675 | 4600675 | 20240708161403_eNsZm | NZ003F | 2024-07-11T12:07:37.528Z | 2024-07-16T12:09:20.762Z |
4600522 | 4600522 | 20240708155729_G3VMa | NZ003F | 2024-07-11T12:07:24.120Z | 2024-07-16T12:09:20.599Z |
4600513 | 4600513 | 20240708155713_WRsUF | NZ003F | 2024-07-11T12:07:23.753Z | 2024-07-16T12:09:20.598Z |
4599081 | 4599081 | 20240708104907_SAz3m | NZ003F | 2024-07-11T12:05:38.235Z | 2024-07-16T12:09:19.176Z |
4599036 | 4599036 | 20240708104119_6Qm2S | NZ003F | 2024-07-11T12:05:33.929Z | 2024-07-16T12:09:18.936Z |
4598675 | 4598675 | 20240708093829_Y8Je6 | NZ003F | 2024-07-11T12:05:06.762Z | 2024-07-16T12:09:17.403Z |
4598668 | 4598668 | 20240708093743_2oTsm | NZ003F | 2024-07-11T12:05:06.419Z | 2024-07-16T12:09:17.399Z |
4594387 | 4594387 | 20240707185120_rrmPQ | NZ003F | 2024-07-10T12:09:57.929Z | 2024-07-15T12:12:22.369Z |
4594285 | 4594285 | 20240707183508_pCHDZ | NZ003F | 2024-07-10T12:09:53.766Z | 2024-07-15T12:12:22.287Z |
4594265 | 4594265 | 20240707183326_x3jsL | NZ003F | 2024-07-10T12:09:53.098Z | 2024-07-15T12:12:22.260Z |
4594249 | 4594249 | 20240707183122_o0RMr | NZ003F | 2024-07-10T12:09:52.802Z | 2024-07-15T12:12:22.256Z |
4594154 | 4594154 | 20240707181649_r5hwl | NZ003F | 2024-07-10T12:09:47.840Z | 2024-07-15T12:12:22.021Z |
4594110 | 4594110 | 20240707181220_x6Tcb | NZ003F | 2024-07-10T12:09:46.572Z | 2024-07-15T12:12:21.935Z |
4593836 | 4593836 | 20240707174739_ap9zN | NZ003F | 2024-07-10T12:09:34.712Z | 2024-07-15T12:12:21.671Z |
4593340 | 4593340 | 20240707170449_oRLFD | NZ003F | 2024-07-10T12:09:16.276Z | 2024-07-15T12:12:21.230Z |
4593078 | 4593078 | 20240707164158_41zs2 | NZ003F | 2024-07-10T12:09:09.580Z | 2024-07-15T12:12:21.076Z |
4592995 | 4592995 | 20240707163503_EKwMh | NZ003F | 2024-07-10T12:09:08.036Z | 2024-07-15T12:12:20.898Z |
4592917 | 4592917 | 20240707162706_xD3AO | NZ003F | 2024-07-10T12:09:06.505Z | 2024-07-15T12:12:20.868Z |
4592807 | 4592807 | 20240707161835_zsJGd | NZ003F | 2024-07-10T12:09:04.143Z | 2024-07-15T12:12:20.833Z |
4592800 | 4592800 | 20240707161820_hilmR | NZ003F | 2024-07-10T12:09:04.097Z | 2024-07-15T12:12:20.831Z |
4592789 | 4592789 | 20240707161720_sSUL2 | NZ003F | 2024-07-10T12:09:03.862Z | 2024-07-15T12:12:20.817Z |
4592777 | 4592777 | 20240707161718_7Ko2C | NZ003F | 2024-07-10T12:09:03.707Z | 2024-07-15T12:12:20.815Z |
4592658 | 4592658 | 20240707160539_eaS6I | NZ003F | 2024-07-10T12:08:57.703Z | 2024-07-15T12:12:20.740Z |
4592601 | 4592601 | 20240707155748_EPG9z | NZ003F | 2024-07-10T12:08:54.487Z | 2024-07-15T12:12:20.695Z |
4592550 | 4592550 | 20240707155452_Bgfyv | NZ003F | 2024-07-10T12:08:52.171Z | 2024-07-15T12:12:20.638Z |
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);