participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,078 rows where station_code = "NZ002C" 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 |
---|---|---|---|---|---|
5135619 | 5135619 | 20240915163850_b4vOW | NZ002C | 2024-09-19T12:19:34.039Z | 2024-09-19T12:19:34.039Z |
5134632 | 5134632 | 20240916110102_Puj3J | NZ002C | 2024-09-19T12:17:58.888Z | 2024-09-19T12:17:58.888Z |
5130955 | 5130955 | 20240917165955_nOIhQ | NZ002C | 2024-09-19T12:14:01.217Z | 2024-09-19T12:14:01.217Z |
5130090 | 5130090 | 20240917085335_12ZVi | NZ002C | 2024-09-19T12:12:33.666Z | 2024-09-19T12:12:33.666Z |
5130072 | 5130072 | 20240917084404_7p2Vd | NZ002C | 2024-09-19T12:12:32.127Z | 2024-09-19T12:12:32.127Z |
5129987 | 5129987 | 20240917072746_EKtfr | NZ002C | 2024-09-19T12:12:23.096Z | 2024-09-19T12:12:23.096Z |
5126036 | 5126036 | 20240918071424_T9uYi | NZ002C | 2024-09-19T12:04:49.240Z | 2024-09-19T12:06:42.129Z |
5095832 | 5095832 | 20240912091042_E3p45 | NZ002C | 2024-09-16T12:15:59.580Z | 2024-09-19T12:21:20.372Z |
5083920 | 5083920 | 20240912164532_WFLP6 | NZ002C | 2024-09-16T12:00:39.170Z | 2024-09-19T12:20:22.553Z |
5083775 | 5083775 | 20240912152515_99Pcw | NZ002C | 2024-09-16T12:00:19.775Z | 2024-09-19T12:20:21.200Z |
5083106 | 5083106 | 20240911120323_v9qmW | NZ002C | 2024-09-15T12:18:35.758Z | 2024-09-19T12:21:49.346Z |
5082943 | 5082943 | 20240911113104_f4u23 | NZ002C | 2024-09-15T12:18:31.489Z | 2024-09-19T12:21:48.942Z |
5082622 | 5082622 | 20240911103621_o9TVr | NZ002C | 2024-09-15T12:18:21.075Z | 2024-09-19T12:21:48.202Z |
5082184 | 5082184 | 20240911093439_E2uXH | NZ002C | 2024-09-15T12:18:06.119Z | 2024-09-19T12:21:47.427Z |
5082128 | 5082128 | 20240911092600_kV3j2 | NZ002C | 2024-09-15T12:18:04.282Z | 2024-09-19T12:21:47.225Z |
5082039 | 5082039 | 20240911091436_q7Kkp | NZ002C | 2024-09-15T12:18:00.387Z | 2024-09-19T12:21:47.114Z |
5081580 | 5081580 | 20240911080606_anq2l | NZ002C | 2024-09-15T12:17:38.295Z | 2024-09-19T12:21:45.797Z |
5081533 | 5081533 | 20240911075631_a4Mwe | NZ002C | 2024-09-15T12:17:36.985Z | 2024-09-19T12:21:45.649Z |
5081502 | 5081502 | 20240911075157_Z9wlH | NZ002C | 2024-09-15T12:17:36.385Z | 2024-09-19T12:21:45.609Z |
5070468 | 5070468 | 20240909125757_kFY1B | NZ002C | 2024-09-14T12:21:21.982Z | 2024-09-17T12:19:12.504Z |
5070462 | 5070462 | 20240909125714_JaxqC | NZ002C | 2024-09-14T12:21:21.953Z | 2024-09-17T12:19:12.479Z |
5070444 | 5070444 | 20240909125404_IhXi4 | NZ002C | 2024-09-14T12:21:21.918Z | 2024-09-17T12:19:12.469Z |
5066723 | 5066723 | 20240910080917_7t3zh | NZ002C | 2024-09-14T12:18:09.146Z | 2024-09-18T12:15:22.623Z |
5066708 | 5066708 | 20240910080633_wrXaB | NZ002C | 2024-09-14T12:18:08.192Z | 2024-09-18T12:15:22.536Z |
5066454 | 5066454 | 20240910073156_v71GY | NZ002C | 2024-09-14T12:17:57.752Z | 2024-09-18T12:15:21.994Z |
5062621 | 5062621 | 20240909175003_WJQkA | NZ002C | 2024-09-14T12:12:38.122Z | 2024-09-18T12:15:11.657Z |
5062548 | 5062548 | 20240909173952_YodFM | NZ002C | 2024-09-14T12:12:32.615Z | 2024-09-18T12:15:11.444Z |
5062516 | 5062516 | 20240909173501_pj97H | NZ002C | 2024-09-14T12:12:30.543Z | 2024-09-18T12:15:11.419Z |
5062263 | 5062263 | 20240909170439_430TV | NZ002C | 2024-09-14T12:12:02.248Z | 2024-09-18T12:15:10.823Z |
5062122 | 5062122 | 20240909164539_Ua3Dy | NZ002C | 2024-09-14T12:11:50.202Z | 2024-09-18T12:15:10.412Z |
5062085 | 5062085 | 20240909164308_T7XhD | NZ002C | 2024-09-14T12:11:48.226Z | 2024-09-18T12:15:10.363Z |
5062031 | 5062031 | 20240909163440_fZ1K2 | NZ002C | 2024-09-14T12:11:45.726Z | 2024-09-18T12:15:10.328Z |
5061897 | 5061897 | 20240909162034_tTcnB | NZ002C | 2024-09-14T12:11:36.514Z | 2024-09-18T12:15:10.125Z |
5061771 | 5061771 | 20240909155754_T1xcy | NZ002C | 2024-09-14T12:11:23.692Z | 2024-09-18T12:15:09.960Z |
5061739 | 5061739 | 20240909154935_j8TLz | NZ002C | 2024-09-14T12:11:17.908Z | 2024-09-18T12:15:09.938Z |
5061668 | 5061668 | 20240909153915_unJiz | NZ002C | 2024-09-14T12:11:08.584Z | 2024-09-18T12:15:09.843Z |
5061636 | 5061636 | 20240909153157_LYELj | NZ002C | 2024-09-14T12:11:04.387Z | 2024-09-18T12:15:09.790Z |
5061615 | 5061615 | 20240909152950_p9VbB | NZ002C | 2024-09-14T12:11:01.069Z | 2024-09-18T12:15:09.736Z |
5061579 | 5061579 | 20240909152456_jmdzr | NZ002C | 2024-09-14T12:10:58.860Z | 2024-09-18T12:15:09.685Z |
5061457 | 5061457 | 20240909150823_2h08k | NZ002C | 2024-09-14T12:10:51.033Z | 2024-09-18T12:15:09.251Z |
5061441 | 5061441 | 20240909150620_owkwO | NZ002C | 2024-09-14T12:10:50.084Z | 2024-09-18T12:15:09.229Z |
5061417 | 5061417 | 20240909150433_SXMGP | NZ002C | 2024-09-14T12:10:48.653Z | 2024-09-18T12:15:09.112Z |
5061413 | 5061413 | 20240909150412_NPuys | NZ002C | 2024-09-14T12:10:48.215Z | 2024-09-18T12:15:09.095Z |
5061356 | 5061356 | 20240909145327_L6vLf | NZ002C | 2024-09-14T12:10:44.017Z | 2024-09-18T12:15:08.975Z |
5061343 | 5061343 | 20240909145031_qLKaJ | NZ002C | 2024-09-14T12:10:43.349Z | 2024-09-18T12:15:08.948Z |
5061271 | 5061271 | 20240909143830_IRfGY | NZ002C | 2024-09-14T12:10:39.363Z | 2024-09-18T12:15:08.818Z |
5061256 | 5061256 | 20240909143810_pVSh1 | NZ002C | 2024-09-14T12:10:38.694Z | 2024-09-18T12:15:08.810Z |
5061220 | 5061220 | 20240909143353_F013J | NZ002C | 2024-09-14T12:10:35.435Z | 2024-09-18T12:15:08.623Z |
5061154 | 5061154 | 20240909142333_RJuKS | NZ002C | 2024-09-14T12:10:23.056Z | 2024-09-18T12:15:08.399Z |
5061144 | 5061144 | 20240909142227_mJwrI | NZ002C | 2024-09-14T12:10:22.356Z | 2024-09-18T12:15:08.307Z |
5061097 | 5061097 | 20240909141645_n0lfS | NZ002C | 2024-09-14T12:10:15.661Z | 2024-09-18T12:15:08.175Z |
5061078 | 5061078 | 20240909140638_HzhSx | NZ002C | 2024-09-14T12:10:14.117Z | 2024-09-18T12:15:08.020Z |
5060970 | 5060970 | 20240909133831_UmKuL | NZ002C | 2024-09-14T12:10:00.415Z | 2024-09-18T12:15:07.568Z |
5060942 | 5060942 | 20240909133116_0ENDq | NZ002C | 2024-09-14T12:09:57.918Z | 2024-09-18T12:15:07.475Z |
5060915 | 5060915 | 20240909132101_PUYRG | NZ002C | 2024-09-14T12:09:55.325Z | 2024-09-18T12:15:07.285Z |
5060894 | 5060894 | 20240909131652_HLfXL | NZ002C | 2024-09-14T12:09:53.990Z | 2024-09-18T12:15:07.211Z |
5060878 | 5060878 | 20240909130958_ABKrH | NZ002C | 2024-09-14T12:09:51.498Z | 2024-09-18T12:15:07.171Z |
5059461 | 5059461 | 20240910174624_YxFHk | NZ002C | 2024-09-14T12:06:09.282Z | 2024-09-19T12:21:30.792Z |
5059268 | 5059268 | 20240910172715_YABlp | NZ002C | 2024-09-14T12:05:34.970Z | 2024-09-19T12:21:30.482Z |
5059201 | 5059201 | 20240910172228_6i0EP | NZ002C | 2024-09-14T12:05:25.857Z | 2024-09-19T12:21:30.422Z |
5059145 | 5059145 | 20240910171637_IwYEV | NZ002C | 2024-09-14T12:05:19.024Z | 2024-09-19T12:21:30.402Z |
5059122 | 5059122 | 20240910171409_pFMsR | NZ002C | 2024-09-14T12:05:16.288Z | 2024-09-19T12:21:30.373Z |
5059099 | 5059099 | 20240910171247_F8EaD | NZ002C | 2024-09-14T12:05:14.439Z | 2024-09-19T12:21:30.366Z |
5059069 | 5059069 | 20240910171017_YutMv | NZ002C | 2024-09-14T12:05:11.012Z | 2024-09-19T12:21:30.331Z |
5059024 | 5059024 | 20240910170810_6x9Sx | NZ002C | 2024-09-14T12:05:06.687Z | 2024-09-19T12:21:30.306Z |
5058990 | 5058990 | 20240910170716_nIW05 | NZ002C | 2024-09-14T12:05:04.917Z | 2024-09-19T12:21:30.299Z |
5058904 | 5058904 | 20240910165813_2VH32 | NZ002C | 2024-09-14T12:04:47.833Z | 2024-09-19T12:21:30.224Z |
5058808 | 5058808 | 20240910164855_ki7rd | NZ002C | 2024-09-14T12:04:34.234Z | 2024-09-19T12:21:30.136Z |
5058796 | 5058796 | 20240910164829_MvN23 | NZ002C | 2024-09-14T12:04:33.468Z | 2024-09-19T12:21:30.104Z |
5058702 | 5058702 | 20240910163818_32Qxv | NZ002C | 2024-09-14T12:04:21.938Z | 2024-09-19T12:21:29.908Z |
5058682 | 5058682 | 20240910163546_6ax34 | NZ002C | 2024-09-14T12:04:18.728Z | 2024-09-19T12:21:29.827Z |
5058621 | 5058621 | 20240910163153_AZVaE | NZ002C | 2024-09-14T12:04:09.831Z | 2024-09-19T12:21:29.794Z |
5058231 | 5058231 | 20240910155614_XZBCb | NZ002C | 2024-09-14T12:03:12.308Z | 2024-09-19T12:21:29.383Z |
5058206 | 5058206 | 20240910155310_c37mk | NZ002C | 2024-09-14T12:03:08.926Z | 2024-09-19T12:21:29.355Z |
5055522 | 5055522 | 20240908081752_aco19 | NZ002C | 2024-09-13T12:17:16.257Z | 2024-09-16T12:21:20.236Z |
5055291 | 5055291 | 20240908074342_R9ALA | NZ002C | 2024-09-13T12:17:09.110Z | 2024-09-16T12:21:18.593Z |
5055222 | 5055222 | 20240908072629_XdoS3 | NZ002C | 2024-09-13T12:17:07.934Z | 2024-09-16T12:21:18.472Z |
5051474 | 5051474 | 20240907173220_3IKJw | NZ002C | 2024-09-13T12:14:17.966Z | 2024-09-16T12:21:00.547Z |
5051466 | 5051466 | 20240907173058_2AUAe | NZ002C | 2024-09-13T12:14:17.431Z | 2024-09-16T12:21:00.535Z |
5051337 | 5051337 | 20240907171743_GeRQu | NZ002C | 2024-09-13T12:14:11.399Z | 2024-09-16T12:21:00.142Z |
5051297 | 5051297 | 20240907171304_qO2ti | NZ002C | 2024-09-13T12:14:09.369Z | 2024-09-16T12:21:00.051Z |
5051271 | 5051271 | 20240907171041_QRCiK | NZ002C | 2024-09-13T12:14:08.286Z | 2024-09-16T12:21:00.000Z |
5051266 | 5051266 | 20240907171032_Kui0q | NZ002C | 2024-09-13T12:14:08.250Z | 2024-09-16T12:20:59.947Z |
5051206 | 5051206 | 20240907165928_u8vFz | NZ002C | 2024-09-13T12:14:06.313Z | 2024-09-16T12:20:59.812Z |
5051166 | 5051166 | 20240907165648_D8zvQ | NZ002C | 2024-09-13T12:14:04.832Z | 2024-09-16T12:20:59.760Z |
5051077 | 5051077 | 20240907164517_b9d7X | NZ002C | 2024-09-13T12:14:01.120Z | 2024-09-16T12:20:59.565Z |
5051015 | 5051015 | 20240907163640_SA9rR | NZ002C | 2024-09-13T12:13:57.264Z | 2024-09-16T12:20:59.460Z |
5050983 | 5050983 | 20240907163012_dZ5tG | NZ002C | 2024-09-13T12:13:55.544Z | 2024-09-16T12:20:59.421Z |
5050949 | 5050949 | 20240907162754_SR1th | NZ002C | 2024-09-13T12:13:54.610Z | 2024-09-16T12:20:59.367Z |
5050768 | 5050768 | 20240907160514_BrToL | NZ002C | 2024-09-13T12:13:46.453Z | 2024-09-16T12:20:58.498Z |
5050707 | 5050707 | 20240907160101_2dghc | NZ002C | 2024-09-13T12:13:44.493Z | 2024-09-16T12:20:58.371Z |
5050618 | 5050618 | 20240907154819_MeWYT | NZ002C | 2024-09-13T12:13:40.416Z | 2024-09-16T12:20:58.102Z |
5050590 | 5050590 | 20240907154608_YOC2U | NZ002C | 2024-09-13T12:13:38.233Z | 2024-09-16T12:20:58.064Z |
5050548 | 5050548 | 20240907153829_fiGBU | NZ002C | 2024-09-13T12:13:36.449Z | 2024-09-16T12:20:57.988Z |
5050509 | 5050509 | 20240907152831_G9Ajt | NZ002C | 2024-09-13T12:13:34.756Z | 2024-09-16T12:20:57.891Z |
5050492 | 5050492 | 20240907152540_UGc6u | NZ002C | 2024-09-13T12:13:33.661Z | 2024-09-16T12:20:57.830Z |
5050486 | 5050486 | 20240907152538_BGqmf | NZ002C | 2024-09-13T12:13:33.559Z | 2024-09-16T12:20:57.817Z |
5050443 | 5050443 | 20240907152115_y0Tg2 | NZ002C | 2024-09-13T12:13:32.173Z | 2024-09-16T12:20:57.698Z |
5050425 | 5050425 | 20240907152050_yQUYV | NZ002C | 2024-09-13T12:13:31.283Z | 2024-09-16T12:20:57.673Z |
5050154 | 5050154 | 20240907144051_MXA31 | NZ002C | 2024-09-13T12:13:13.023Z | 2024-09-16T12:20:56.549Z |
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);