participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,990 rows where station_code = "NZ0039" 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 |
---|---|---|---|---|---|
5135562 | 5135562 | 20240915160214_BIOtR | NZ0039 | 2024-09-19T12:19:33.237Z | 2024-09-19T12:19:33.237Z |
5135551 | 5135551 | 20240915155247_yzLk2 | NZ0039 | 2024-09-19T12:19:33.089Z | 2024-09-19T12:19:33.089Z |
5134665 | 5134665 | 20240916111055_LO3wV | NZ0039 | 2024-09-19T12:18:03.033Z | 2024-09-19T12:18:03.033Z |
5134337 | 5134337 | 20240916082021_WopTp | NZ0039 | 2024-09-19T12:17:37.588Z | 2024-09-19T12:17:37.588Z |
5130981 | 5130981 | 20240917171213_6bLpv | NZ0039 | 2024-09-19T12:14:02.557Z | 2024-09-19T12:14:02.557Z |
5130967 | 5130967 | 20240917170859_LsgE3 | NZ0039 | 2024-09-19T12:14:01.812Z | 2024-09-19T12:14:01.812Z |
5130734 | 5130734 | 20240917145742_xWSoI | NZ0039 | 2024-09-19T12:13:46.966Z | 2024-09-19T12:13:46.966Z |
5130702 | 5130702 | 20240917144601_zvnBU | NZ0039 | 2024-09-19T12:13:45.813Z | 2024-09-19T12:13:45.813Z |
5130520 | 5130520 | 20240917124802_6VMT6 | NZ0039 | 2024-09-19T12:13:31.311Z | 2024-09-19T12:13:31.311Z |
5071431 | 5071431 | 20240911165024_dRddc | NZ0039 | 2024-09-15T12:02:31.463Z | 2024-09-19T12:21:01.886Z |
5069081 | 5069081 | 20240910134024_Obrzb | NZ0039 | 2024-09-14T12:19:25.411Z | 2024-09-18T12:15:27.107Z |
5069067 | 5069067 | 20240910133700_AENBE | NZ0039 | 2024-09-14T12:19:25.105Z | 2024-09-18T12:15:27.093Z |
5069012 | 5069012 | 20240910132325_vVYvo | NZ0039 | 2024-09-14T12:19:23.958Z | 2024-09-18T12:15:26.993Z |
5062459 | 5062459 | 20240909172807_mewMJ | NZ0039 | 2024-09-14T12:12:23.924Z | 2024-09-18T12:15:11.356Z |
5062443 | 5062443 | 20240909172559_CWjeF | NZ0039 | 2024-09-14T12:12:22.158Z | 2024-09-18T12:15:11.347Z |
5062430 | 5062430 | 20240909172413_mFrxd | NZ0039 | 2024-09-14T12:12:19.967Z | 2024-09-18T12:15:11.325Z |
5062189 | 5062189 | 20240909165544_iosR4 | NZ0039 | 2024-09-14T12:11:54.653Z | 2024-09-18T12:15:10.523Z |
5061725 | 5061725 | 20240909154736_ZUuga | NZ0039 | 2024-09-14T12:11:15.854Z | 2024-09-18T12:15:09.924Z |
5061700 | 5061700 | 20240909154354_kCdkq | NZ0039 | 2024-09-14T12:11:12.772Z | 2024-09-18T12:15:09.891Z |
5061543 | 5061543 | 20240909152153_8E2Q1 | NZ0039 | 2024-09-14T12:10:56.906Z | 2024-09-18T12:15:09.548Z |
5061366 | 5061366 | 20240909145712_HLP2q | NZ0039 | 2024-09-14T12:10:44.520Z | 2024-09-18T12:15:08.996Z |
5061306 | 5061306 | 20240909144353_XXKt4 | NZ0039 | 2024-09-14T12:10:41.028Z | 2024-09-18T12:15:08.867Z |
5061033 | 5061033 | 20240909135534_UNjFp | NZ0039 | 2024-09-14T12:10:07.157Z | 2024-09-18T12:15:07.861Z |
5060958 | 5060958 | 20240909133731_qIYHa | NZ0039 | 2024-09-14T12:09:59.417Z | 2024-09-18T12:15:07.524Z |
5060906 | 5060906 | 20240909131848_PTXjD | NZ0039 | 2024-09-14T12:09:54.946Z | 2024-09-18T12:15:07.254Z |
5060885 | 5060885 | 20240909131148_s1Kmm | NZ0039 | 2024-09-14T12:09:51.835Z | 2024-09-18T12:15:07.182Z |
5060851 | 5060851 | 20240909130622_su5RV | NZ0039 | 2024-09-14T12:09:49.409Z | 2024-09-18T12:15:06.978Z |
5060844 | 5060844 | 20240909130234_X6KcN | NZ0039 | 2024-09-14T12:09:48.242Z | 2024-09-18T12:15:06.882Z |
5059210 | 5059210 | 20240910172308_atVLC | NZ0039 | 2024-09-14T12:05:26.548Z | 2024-09-19T12:21:30.454Z |
5059137 | 5059137 | 20240910171617_g53Nv | NZ0039 | 2024-09-14T12:05:18.116Z | 2024-09-19T12:21:30.399Z |
5059015 | 5059015 | 20240910170805_l0EBq | NZ0039 | 2024-09-14T12:05:06.370Z | 2024-09-19T12:21:30.304Z |
5058998 | 5058998 | 20240910170729_F18PJ | NZ0039 | 2024-09-14T12:05:05.292Z | 2024-09-19T12:21:30.300Z |
5058802 | 5058802 | 20240910164838_iR3D3 | NZ0039 | 2024-09-14T12:04:33.838Z | 2024-09-19T12:21:30.133Z |
5058671 | 5058671 | 20240910163510_bjFr3 | NZ0039 | 2024-09-14T12:04:17.671Z | 2024-09-19T12:21:29.811Z |
5058578 | 5058578 | 20240910162821_9CYHq | NZ0039 | 2024-09-14T12:04:02.641Z | 2024-09-19T12:21:29.751Z |
5058518 | 5058518 | 20240910161915_wJEC8 | NZ0039 | 2024-09-14T12:03:50.282Z | 2024-09-19T12:21:29.670Z |
5058387 | 5058387 | 20240910160844_hxF9n | NZ0039 | 2024-09-14T12:03:38.668Z | 2024-09-19T12:21:29.572Z |
5058267 | 5058267 | 20240910155948_XPHWK | NZ0039 | 2024-09-14T12:03:17.929Z | 2024-09-19T12:21:29.396Z |
5058140 | 5058140 | 20240910154728_mDMxx | NZ0039 | 2024-09-14T12:03:01.320Z | 2024-09-19T12:21:29.179Z |
5058034 | 5058034 | 20240910153822_wwV2x | NZ0039 | 2024-09-14T12:02:39.501Z | 2024-09-19T12:21:29.023Z |
5058025 | 5058025 | 20240910153714_6y76X | NZ0039 | 2024-09-14T12:02:38.289Z | 2024-09-19T12:21:29.019Z |
5057705 | 5057705 | 20240910150610_22wzz | NZ0039 | 2024-09-14T12:01:46.656Z | 2024-09-19T12:21:28.613Z |
5057562 | 5057562 | 20240910144920_qEWu2 | NZ0039 | 2024-09-14T12:01:26.736Z | 2024-09-19T12:21:28.367Z |
5057425 | 5057425 | 20240910142843_u0D4J | NZ0039 | 2024-09-14T12:01:02.894Z | 2024-09-19T12:21:27.842Z |
5057232 | 5057232 | 20240910140230_50JAG | NZ0039 | 2024-09-14T12:00:36.022Z | 2024-09-19T12:21:27.382Z |
5055589 | 5055589 | 20240908082632_GX6nr | NZ0039 | 2024-09-13T12:17:18.018Z | 2024-09-16T12:21:20.423Z |
5055419 | 5055419 | 20240908080053_hRb3v | NZ0039 | 2024-09-13T12:17:12.146Z | 2024-09-16T12:21:19.585Z |
5051360 | 5051360 | 20240907172024_26k0v | NZ0039 | 2024-09-13T12:14:12.075Z | 2024-09-16T12:21:00.202Z |
5051333 | 5051333 | 20240907171638_ACVzV | NZ0039 | 2024-09-13T12:14:11.327Z | 2024-09-16T12:21:00.115Z |
5051329 | 5051329 | 20240907171636_uH8fT | NZ0039 | 2024-09-13T12:14:11.218Z | 2024-09-16T12:21:00.113Z |
5051181 | 5051181 | 20240907165724_SW4o4 | NZ0039 | 2024-09-13T12:14:05.075Z | 2024-09-16T12:20:59.776Z |
5051021 | 5051021 | 20240907163734_aPJFT | NZ0039 | 2024-09-13T12:13:57.495Z | 2024-09-16T12:20:59.475Z |
5050797 | 5050797 | 20240907160757_6qF3n | NZ0039 | 2024-09-13T12:13:46.851Z | 2024-09-16T12:20:58.524Z |
5050779 | 5050779 | 20240907160648_mXOdz | NZ0039 | 2024-09-13T12:13:46.603Z | 2024-09-16T12:20:58.505Z |
5050722 | 5050722 | 20240907160221_N3JkL | NZ0039 | 2024-09-13T12:13:44.819Z | 2024-09-16T12:20:58.380Z |
5050674 | 5050674 | 20240907155752_Dj8IJ | NZ0039 | 2024-09-13T12:13:43.336Z | 2024-09-16T12:20:58.339Z |
5050540 | 5050540 | 20240907153744_bDwBP | NZ0039 | 2024-09-13T12:13:36.317Z | 2024-09-16T12:20:57.983Z |
5050433 | 5050433 | 20240907152102_3Q2os | NZ0039 | 2024-09-13T12:13:31.651Z | 2024-09-16T12:20:57.680Z |
5050231 | 5050231 | 20240907145445_lsoZi | NZ0039 | 2024-09-13T12:13:19.350Z | 2024-09-16T12:20:56.790Z |
5050194 | 5050194 | 20240907144619_aHHNl | NZ0039 | 2024-09-13T12:13:16.177Z | 2024-09-16T12:20:56.678Z |
5050119 | 5050119 | 20240909124936_4zTrM | NZ0039 | 2024-09-13T12:12:41.113Z | 2024-09-17T12:19:12.403Z |
5050109 | 5050109 | 20240909124722_ozaY8 | NZ0039 | 2024-09-13T12:12:40.760Z | 2024-09-17T12:19:12.340Z |
5050077 | 5050077 | 20240909123912_nWSlT | NZ0039 | 2024-09-13T12:12:38.933Z | 2024-09-17T12:19:12.264Z |
5050043 | 5050043 | 20240909123157_8r582 | NZ0039 | 2024-09-13T12:12:37.732Z | 2024-09-17T12:19:12.153Z |
5050033 | 5050033 | 20240909123133_IJ367 | NZ0039 | 2024-09-13T12:12:37.359Z | 2024-09-17T12:19:12.128Z |
5049869 | 5049869 | 20240909115154_mYfed | NZ0039 | 2024-09-13T12:12:29.365Z | 2024-09-17T12:19:11.694Z |
5049781 | 5049781 | 20240909113849_740vY | NZ0039 | 2024-09-13T12:12:26.070Z | 2024-09-17T12:19:11.453Z |
5049505 | 5049505 | 20240909110544_5Z36C | NZ0039 | 2024-09-13T12:12:15.997Z | 2024-09-17T12:19:10.760Z |
5049427 | 5049427 | 20240909105428_qKeoy | NZ0039 | 2024-09-13T12:12:10.780Z | 2024-09-17T12:19:10.379Z |
5049255 | 5049255 | 20240909102803_6T2QE | NZ0039 | 2024-09-13T12:11:50.809Z | 2024-09-17T12:19:09.636Z |
5049032 | 5049032 | 20240909094928_342mN | NZ0039 | 2024-09-13T12:11:28.429Z | 2024-09-17T12:19:08.988Z |
5048450 | 5048450 | 20240909080526_7d0EN | NZ0039 | 2024-09-13T12:10:36.762Z | 2024-09-17T12:19:06.896Z |
5045539 | 5045539 | 20240908171833_r64my | NZ0039 | 2024-09-13T12:04:17.573Z | 2024-09-17T12:18:56.747Z |
5044928 | 5044928 | 20240908155637_1VIbD | NZ0039 | 2024-09-13T12:03:13.399Z | 2024-09-17T12:18:55.438Z |
5044874 | 5044874 | 20240908155208_uuBcy | NZ0039 | 2024-09-13T12:03:05.159Z | 2024-09-17T12:18:55.306Z |
5044669 | 5044669 | 20240908152727_c9pAm | NZ0039 | 2024-09-13T12:02:45.177Z | 2024-09-17T12:18:54.815Z |
5044621 | 5044621 | 20240908152416_CSRCg | NZ0039 | 2024-09-13T12:02:35.413Z | 2024-09-17T12:18:54.762Z |
5043306 | 5043306 | 20240907142659_rkVl9 | NZ0039 | 2024-09-12T12:17:26.138Z | 2024-09-16T12:20:56.312Z |
5043278 | 5043278 | 20240907142108_34VGQ | NZ0039 | 2024-09-12T12:17:26.008Z | 2024-09-16T12:20:56.193Z |
5043092 | 5043092 | 20240907134819_grb4j | NZ0039 | 2024-09-12T12:17:23.304Z | 2024-09-16T12:20:55.357Z |
5043064 | 5043064 | 20240907134354_rG5WM | NZ0039 | 2024-09-12T12:17:22.395Z | 2024-09-16T12:20:55.270Z |
5043017 | 5043017 | 20240907133353_xZuNO | NZ0039 | 2024-09-12T12:17:21.853Z | 2024-09-16T12:20:55.183Z |
5042944 | 5042944 | 20240907131933_wn6SX | NZ0039 | 2024-09-12T12:17:20.997Z | 2024-09-16T12:20:54.947Z |
5042923 | 5042923 | 20240907131219_G3kfS | NZ0039 | 2024-09-12T12:17:20.818Z | 2024-09-16T12:20:54.907Z |
5042880 | 5042880 | 20240907130222_3MhMJ | NZ0039 | 2024-09-12T12:17:19.453Z | 2024-09-16T12:20:54.793Z |
5042873 | 5042873 | 20240907130218_dNNPO | NZ0039 | 2024-09-12T12:17:19.448Z | 2024-09-16T12:20:54.742Z |
5042846 | 5042846 | 20240907125841_YDXLg | NZ0039 | 2024-09-12T12:17:18.834Z | 2024-09-16T12:20:54.645Z |
5042773 | 5042773 | 20240907124406_qYxua | NZ0039 | 2024-09-12T12:17:18.217Z | 2024-09-16T12:20:54.185Z |
5042751 | 5042751 | 20240907123720_Y0po2 | NZ0039 | 2024-09-12T12:17:17.842Z | 2024-09-16T12:20:54.087Z |
5041972 | 5041972 | 20240906093351_DgboE | NZ0039 | 2024-09-12T12:16:53.431Z | 2024-09-14T12:23:15.643Z |
5041764 | 5041764 | 20240906090202_h9dFA | NZ0039 | 2024-09-12T12:16:48.129Z | 2024-09-14T12:23:14.484Z |
5041750 | 5041750 | 20240906085752_75Z6t | NZ0039 | 2024-09-12T12:16:47.916Z | 2024-09-14T12:23:14.453Z |
5041359 | 5041359 | 20240906080351_hBOOg | NZ0039 | 2024-09-12T12:16:39.338Z | 2024-09-14T12:23:13.373Z |
5041111 | 5041111 | 20240906072241_gl2fT | NZ0039 | 2024-09-12T12:16:34.203Z | 2024-09-14T12:23:11.807Z |
5037387 | 5037387 | 20240905155104_bGqin | NZ0039 | 2024-09-12T12:14:06.103Z | 2024-09-14T12:22:54.175Z |
5037286 | 5037286 | 20240905153158_ft4xl | NZ0039 | 2024-09-12T12:14:04.214Z | 2024-09-14T12:22:54.073Z |
5037225 | 5037225 | 20240905152611_cADWV | NZ0039 | 2024-09-12T12:14:03.084Z | 2024-09-14T12:22:53.965Z |
5037187 | 5037187 | 20240905151937_McB3J | NZ0039 | 2024-09-12T12:14:02.737Z | 2024-09-14T12:22:53.946Z |
5036889 | 5036889 | 20240905143954_dBKkn | NZ0039 | 2024-09-12T12:13:56.933Z | 2024-09-14T12:22:53.530Z |
5036783 | 5036783 | 20240905142635_UMkJv | NZ0039 | 2024-09-12T12:13:54.575Z | 2024-09-14T12:22:53.251Z |
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);