participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,323 rows where station_code = "NZ0046" 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 |
---|---|---|---|---|---|
5500508 | 5500508 | 20241108155321_CTD9l | NZ0046 | 2024-11-09T14:06:23.319Z | 2024-11-09T14:06:23.319Z |
5500465 | 5500465 | 20241108154814_o8V5x | NZ0046 | 2024-11-09T14:06:18.986Z | 2024-11-09T14:06:18.986Z |
5500450 | 5500450 | 20241108154511_uh5hv | NZ0046 | 2024-11-09T14:06:17.937Z | 2024-11-09T14:06:17.937Z |
5500432 | 5500432 | 20241108154211_Qsq2K | NZ0046 | 2024-11-09T14:06:16.385Z | 2024-11-09T14:06:16.385Z |
5500366 | 5500366 | 20241108152941_AF3gE | NZ0046 | 2024-11-09T14:06:10.720Z | 2024-11-09T14:06:10.720Z |
5500362 | 5500362 | 20241108152716_Cev36 | NZ0046 | 2024-11-09T14:06:10.294Z | 2024-11-09T14:06:10.294Z |
5500321 | 5500321 | 20241108151843_bycYs | NZ0046 | 2024-11-09T14:06:06.252Z | 2024-11-09T14:06:06.252Z |
5500245 | 5500245 | 20241108150737_2qB0e | NZ0046 | 2024-11-09T14:06:00.789Z | 2024-11-09T14:06:00.789Z |
5500223 | 5500223 | 20241108150557_2ot3C | NZ0046 | 2024-11-09T14:05:59.385Z | 2024-11-09T14:05:59.385Z |
5500217 | 5500217 | 20241108150511_kHM37 | NZ0046 | 2024-11-09T14:05:59.242Z | 2024-11-09T14:05:59.242Z |
5500204 | 5500204 | 20241108150402_TX45H | NZ0046 | 2024-11-09T14:05:58.326Z | 2024-11-09T14:05:58.326Z |
5500044 | 5500044 | 20241108143245_IyHQp | NZ0046 | 2024-11-09T14:05:34.356Z | 2024-11-09T14:05:34.356Z |
5499987 | 5499987 | 20241108141909_VdhTt | NZ0046 | 2024-11-09T14:05:27.351Z | 2024-11-09T14:05:27.351Z |
5498814 | 5498814 | 20241108100828_IjT1L | NZ0046 | 2024-11-09T14:02:28.063Z | 2024-11-09T14:02:28.063Z |
5498791 | 5498791 | 20241108095952_N32bO | NZ0046 | 2024-11-09T14:02:24.987Z | 2024-11-09T14:02:24.987Z |
5498684 | 5498684 | 20241108093624_mWOyR | NZ0046 | 2024-11-09T14:02:11.027Z | 2024-11-09T14:02:11.027Z |
5498579 | 5498579 | 20241108091353_DbS2F | NZ0046 | 2024-11-09T14:01:50.776Z | 2024-11-09T14:01:50.776Z |
5498484 | 5498484 | 20241108083917_G2EIk | NZ0046 | 2024-11-09T14:01:36.473Z | 2024-11-09T14:01:36.473Z |
5494146 | 5494146 | 20241107160222_Gzird | NZ0046 | 2024-11-08T14:05:26.276Z | 2024-11-09T14:16:27.867Z |
5494134 | 5494134 | 20241107154323_Xr8Ur | NZ0046 | 2024-11-08T14:05:25.139Z | 2024-11-09T14:16:27.855Z |
5494129 | 5494129 | 20241107154230_IvlN9 | NZ0046 | 2024-11-08T14:05:24.828Z | 2024-11-09T14:16:27.853Z |
5494069 | 5494069 | 20241107152718_633ZG | NZ0046 | 2024-11-08T14:05:19.809Z | 2024-11-09T14:16:27.832Z |
5494038 | 5494038 | 20241107151729_NxERD | NZ0046 | 2024-11-08T14:05:17.071Z | 2024-11-09T14:16:27.820Z |
5494033 | 5494033 | 20241107151700_V3oqR | NZ0046 | 2024-11-08T14:05:16.767Z | 2024-11-09T14:16:27.819Z |
5494028 | 5494028 | 20241107151435_LoSWl | NZ0046 | 2024-11-08T14:05:16.403Z | 2024-11-09T14:16:27.817Z |
5493994 | 5493994 | 20241107150642_sbLuk | NZ0046 | 2024-11-08T14:05:13.619Z | 2024-11-09T14:16:27.805Z |
5493966 | 5493966 | 20241107145315_lL1MY | NZ0046 | 2024-11-08T14:05:06.338Z | 2024-11-09T14:16:27.793Z |
5493923 | 5493923 | 20241107143719_oc5IP | NZ0046 | 2024-11-08T14:04:55.902Z | 2024-11-09T14:16:27.777Z |
5481258 | 5481258 | 20241104161436_2iybM | NZ0046 | 2024-11-06T14:09:49.754Z | 2024-11-09T14:20:43.259Z |
5481077 | 5481077 | 20241104133520_GY3H2 | NZ0046 | 2024-11-06T14:08:56.445Z | 2024-11-09T14:20:36.443Z |
5481020 | 5481020 | 20241104123735_k9meT | NZ0046 | 2024-11-06T14:08:32.008Z | 2024-11-09T14:20:33.537Z |
5480965 | 5480965 | 20241104114837_3HewB | NZ0046 | 2024-11-06T14:08:10.790Z | 2024-11-09T14:20:31.343Z |
5480760 | 5480760 | 20241105152646_mMefb | NZ0046 | 2024-11-06T14:06:30.316Z | 2024-11-09T14:19:30.134Z |
5480656 | 5480656 | 20241105143057_dSzYQ | NZ0046 | 2024-11-06T14:06:14.502Z | 2024-11-09T14:19:27.671Z |
5480645 | 5480645 | 20241105142756_NIxTw | NZ0046 | 2024-11-06T14:06:09.523Z | 2024-11-09T14:19:27.409Z |
5480626 | 5480626 | 20241105142006_AkwcS | NZ0046 | 2024-11-06T14:06:04.181Z | 2024-11-09T14:19:27.217Z |
5480623 | 5480623 | 20241105141823_w1lh1 | NZ0046 | 2024-11-06T14:06:03.848Z | 2024-11-09T14:19:27.192Z |
5480553 | 5480553 | 20241105134428_ayNxD | NZ0046 | 2024-11-06T14:05:54.441Z | 2024-11-09T14:19:25.460Z |
5480543 | 5480543 | 20241105134020_i1G3X | NZ0046 | 2024-11-06T14:05:53.410Z | 2024-11-09T14:19:25.343Z |
5480515 | 5480515 | 20241105132901_yy0p6 | NZ0046 | 2024-11-06T14:05:50.430Z | 2024-11-09T14:19:24.851Z |
5480429 | 5480429 | 20241105125411_b6g24 | NZ0046 | 2024-11-06T14:05:33.663Z | 2024-11-09T14:19:24.013Z |
5480427 | 5480427 | 20241105125348_c2iAS | NZ0046 | 2024-11-06T14:05:32.697Z | 2024-11-09T14:19:23.997Z |
5480363 | 5480363 | 20241105123529_OctiL | NZ0046 | 2024-11-06T14:05:21.070Z | 2024-11-09T14:19:23.309Z |
5480355 | 5480355 | 20241105123212_uvKFs | NZ0046 | 2024-11-06T14:05:19.678Z | 2024-11-09T14:19:23.066Z |
5480226 | 5480226 | 20241105120401_sSOL3 | NZ0046 | 2024-11-06T14:04:59.851Z | 2024-11-09T14:19:20.578Z |
5480220 | 5480220 | 20241105120335_C8dWY | NZ0046 | 2024-11-06T14:04:59.025Z | 2024-11-09T14:19:20.549Z |
5480179 | 5480179 | 20241105115655_gip3a | NZ0046 | 2024-11-06T14:04:45.331Z | 2024-11-09T14:19:19.814Z |
5479710 | 5479710 | 20241105102408_jaxlg | NZ0046 | 2024-11-06T14:03:08.448Z | 2024-11-09T14:19:10.671Z |
5479609 | 5479609 | 20241105100432_7tkuG | NZ0046 | 2024-11-06T14:02:52.791Z | 2024-11-09T14:19:09.812Z |
5479344 | 5479344 | 20241105090711_rnJlA | NZ0046 | 2024-11-06T14:02:04.193Z | 2024-11-09T14:19:04.613Z |
5479280 | 5479280 | 20241105085642_yi44b | NZ0046 | 2024-11-06T14:01:43.871Z | 2024-11-09T14:19:03.217Z |
5479233 | 5479233 | 20241105083755_DySDl | NZ0046 | 2024-11-06T14:01:34.785Z | 2024-11-09T14:19:02.216Z |
5479090 | 5479090 | 20241105080032_rgzFB | NZ0046 | 2024-11-06T14:00:58.566Z | 2024-11-09T14:18:59.427Z |
5474078 | 5474078 | 20241103154913_EI3o8 | NZ0046 | 2024-11-05T14:10:06.942Z | 2024-11-09T14:21:43.283Z |
5474056 | 5474056 | 20241103154430_7NmyP | NZ0046 | 2024-11-05T14:10:03.470Z | 2024-11-09T14:21:43.097Z |
5473883 | 5473883 | 20241103151518_A6YSv | NZ0046 | 2024-11-05T14:09:50.583Z | 2024-11-09T14:21:41.723Z |
5473732 | 5473732 | 20241103145559_3m0rh | NZ0046 | 2024-11-05T14:09:38.184Z | 2024-11-09T14:21:40.742Z |
5473647 | 5473647 | 20241103144446_Amblc | NZ0046 | 2024-11-05T14:09:18.887Z | 2024-11-09T14:21:40.274Z |
5473632 | 5473632 | 20241103144307_wVxs5 | NZ0046 | 2024-11-05T14:09:14.969Z | 2024-11-09T14:21:40.060Z |
5473559 | 5473559 | 20241103143253_WMbAi | NZ0046 | 2024-11-05T14:09:06.529Z | 2024-11-09T14:21:39.610Z |
5473513 | 5473513 | 20241103142750_srWhU | NZ0046 | 2024-11-05T14:09:03.146Z | 2024-11-09T14:21:39.284Z |
5473506 | 5473506 | 20241103142702_vNpAx | NZ0046 | 2024-11-05T14:09:01.561Z | 2024-11-09T14:21:39.273Z |
5473477 | 5473477 | 20241103142215_MyumS | NZ0046 | 2024-11-05T14:08:58.803Z | 2024-11-09T14:21:39.016Z |
5473474 | 5473474 | 20241103142107_cePXS | NZ0046 | 2024-11-05T14:08:58.395Z | 2024-11-09T14:21:39.013Z |
5473446 | 5473446 | 20241103141903_rJ9jH | NZ0046 | 2024-11-05T14:08:56.442Z | 2024-11-09T14:21:38.858Z |
5473424 | 5473424 | 20241103141417_zPqTg | NZ0046 | 2024-11-05T14:08:55.108Z | 2024-11-09T14:21:38.818Z |
5473323 | 5473323 | 20241103140102_ShFyZ | NZ0046 | 2024-11-05T14:08:47.907Z | 2024-11-09T14:21:37.870Z |
5473266 | 5473266 | 20241103135157_rLDz4 | NZ0046 | 2024-11-05T14:08:43.591Z | 2024-11-09T14:21:37.445Z |
5473141 | 5473141 | 20241103133301_jkxJc | NZ0046 | 2024-11-05T14:08:22.248Z | 2024-11-09T14:21:37.044Z |
5473128 | 5473128 | 20241103133112_D3644 | NZ0046 | 2024-11-05T14:08:20.780Z | 2024-11-09T14:21:37.024Z |
5473004 | 5473004 | 20241103131339_PBjDm | NZ0046 | 2024-11-05T14:08:02.680Z | 2024-11-09T14:21:36.532Z |
5472995 | 5472995 | 20241103131210_uRVMd | NZ0046 | 2024-11-05T14:08:01.149Z | 2024-11-09T14:21:36.494Z |
5472941 | 5472941 | 20241103130228_D1OAq | NZ0046 | 2024-11-05T14:07:53.733Z | 2024-11-09T14:21:35.919Z |
5472910 | 5472910 | 20241103125850_EE8da | NZ0046 | 2024-11-05T14:07:51.138Z | 2024-11-09T14:21:35.682Z |
5472898 | 5472898 | 20241103125740_k7JPS | NZ0046 | 2024-11-05T14:07:50.467Z | 2024-11-09T14:21:35.529Z |
5472846 | 5472846 | 20241103125210_2uB23 | NZ0046 | 2024-11-05T14:07:47.349Z | 2024-11-09T14:21:35.347Z |
5472836 | 5472836 | 20241103125002_PfgGT | NZ0046 | 2024-11-05T14:07:46.564Z | 2024-11-09T14:21:35.331Z |
5472825 | 5472825 | 20241103124914_vhxWY | NZ0046 | 2024-11-05T14:07:45.691Z | 2024-11-09T14:21:35.298Z |
5472747 | 5472747 | 20241103123219_2oAGO | NZ0046 | 2024-11-05T14:07:39.220Z | 2024-11-09T14:21:34.507Z |
5472694 | 5472694 | 20241103122358_ty4Eu | NZ0046 | 2024-11-05T14:07:29.879Z | 2024-11-09T14:21:34.178Z |
5472633 | 5472633 | 20241104161436_8cLBx | NZ0046 | 2024-11-05T14:06:21.372Z | 2024-11-05T14:06:21.372Z |
5472607 | 5472607 | 20241104155529_e2DP8 | NZ0046 | 2024-11-05T14:06:19.727Z | 2024-11-09T14:20:42.632Z |
5472596 | 5472596 | 20241104155228_FBRBr | NZ0046 | 2024-11-05T14:06:18.963Z | 2024-11-09T14:20:42.454Z |
5472557 | 5472557 | 20241104154437_ENPqF | NZ0046 | 2024-11-05T14:06:13.531Z | 2024-11-09T14:20:42.068Z |
5472500 | 5472500 | 20241104152139_zZ7Vx | NZ0046 | 2024-11-05T14:05:59.188Z | 2024-11-09T14:20:40.992Z |
5472458 | 5472458 | 20241104150904_Y5TTw | NZ0046 | 2024-11-05T14:05:51.021Z | 2024-11-09T14:20:40.458Z |
5472446 | 5472446 | 20241104150659_hR3A1 | NZ0046 | 2024-11-05T14:05:50.237Z | 2024-11-09T14:20:40.321Z |
5472305 | 5472305 | 20241104143453_AfCXH | NZ0046 | 2024-11-05T14:05:36.306Z | 2024-11-09T14:20:38.893Z |
5472159 | 5472159 | 20241104135746_G5pqm | NZ0046 | 2024-11-05T14:05:18.304Z | 2024-11-09T14:20:37.006Z |
5472142 | 5472142 | 20241104135205_BfU5N | NZ0046 | 2024-11-05T14:05:14.410Z | 2024-11-09T14:20:36.823Z |
5472113 | 5472113 | 20241104134235_E29Ba | NZ0046 | 2024-11-05T14:05:10.836Z | 2024-11-09T14:20:36.548Z |
5472085 | 5472085 | 20241104133518_YzWdy | NZ0046 | 2024-11-05T14:05:05.036Z | 2024-11-09T14:20:36.442Z |
5472045 | 5472045 | 20241104132917_o81RR | NZ0046 | 2024-11-05T14:05:01.142Z | 2024-11-09T14:20:35.947Z |
5471951 | 5471951 | 20241104130803_ObzJu | NZ0046 | 2024-11-05T14:04:52.141Z | 2024-11-09T14:20:35.242Z |
5471919 | 5471919 | 20241104130100_2vRg3 | NZ0046 | 2024-11-05T14:04:48.464Z | 2024-11-09T14:20:34.972Z |
5471777 | 5471777 | 20241104123530_0tGdk | NZ0046 | 2024-11-05T14:04:34.732Z | 2024-11-09T14:20:33.505Z |
5471673 | 5471673 | 20241104122230_pgbjC | NZ0046 | 2024-11-05T14:04:17.861Z | 2024-11-09T14:20:32.661Z |
5471613 | 5471613 | 20241104120927_lGwlK | NZ0046 | 2024-11-05T14:04:04.524Z | 2024-11-09T14:20:32.204Z |
5471427 | 5471427 | 20241104114353_Loplv | NZ0046 | 2024-11-05T14:03:43.087Z | 2024-11-09T14:20:31.081Z |
5471405 | 5471405 | 20241104113916_xxBCd | NZ0046 | 2024-11-05T14:03:41.242Z | 2024-11-09T14:20:30.876Z |
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);