participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
23 rows where station_code = "NZ004U" 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 |
---|---|---|---|---|---|
5494152 | 5494152 | 20241107160442_dPsDj | NZ004U | 2024-11-08T14:05:26.474Z | 2024-11-08T14:05:26.474Z |
5494135 | 5494135 | 20241107154323_Xr8Ur | NZ004U | 2024-11-08T14:05:25.139Z | 2024-11-08T14:05:25.139Z |
5494098 | 5494098 | 20241107153437_MNWud | NZ004U | 2024-11-08T14:05:22.270Z | 2024-11-08T14:05:22.270Z |
5494070 | 5494070 | 20241107152718_633ZG | NZ004U | 2024-11-08T14:05:19.809Z | 2024-11-08T14:05:19.809Z |
5494034 | 5494034 | 20241107151700_V3oqR | NZ004U | 2024-11-08T14:05:16.767Z | 2024-11-08T14:05:16.767Z |
5493995 | 5493995 | 20241107150642_sbLuk | NZ004U | 2024-11-08T14:05:13.619Z | 2024-11-08T14:05:13.619Z |
5493967 | 5493967 | 20241107145315_lL1MY | NZ004U | 2024-11-08T14:05:06.338Z | 2024-11-08T14:05:06.338Z |
5493953 | 5493953 | 20241107144803_e4lq2 | NZ004U | 2024-11-08T14:05:02.771Z | 2024-11-08T14:05:02.771Z |
5481021 | 5481021 | 20241104123735_k9meT | NZ004U | 2024-11-06T14:08:32.008Z | 2024-11-08T14:17:40.956Z |
5480966 | 5480966 | 20241104114837_3HewB | NZ004U | 2024-11-06T14:08:10.790Z | 2024-11-08T14:17:34.101Z |
5480961 | 5480961 | 20241104111605_IMCAO | NZ004U | 2024-11-06T14:08:03.580Z | 2024-11-08T14:17:31.548Z |
5480662 | 5480662 | 20241105143224_xO2mc | NZ004U | 2024-11-06T14:06:17.093Z | 2024-11-08T14:15:33.953Z |
5480657 | 5480657 | 20241105143057_dSzYQ | NZ004U | 2024-11-06T14:06:14.502Z | 2024-11-08T14:15:33.779Z |
5480624 | 5480624 | 20241105141823_w1lh1 | NZ004U | 2024-11-06T14:06:03.848Z | 2024-11-08T14:15:32.380Z |
5480546 | 5480546 | 20241105134346_oOD3h | NZ004U | 2024-11-06T14:05:53.652Z | 2024-11-08T14:15:29.654Z |
5480523 | 5480523 | 20241105133050_y3z46 | NZ004U | 2024-11-06T14:05:51.301Z | 2024-11-08T14:15:29.034Z |
5480516 | 5480516 | 20241105132901_yy0p6 | NZ004U | 2024-11-06T14:05:50.430Z | 2024-11-08T14:15:28.985Z |
5480463 | 5480463 | 20241105130609_Gp1DK | NZ004U | 2024-11-06T14:05:44.137Z | 2024-11-08T14:15:27.149Z |
5480377 | 5480377 | 20241105123738_EA9vH | NZ004U | 2024-11-06T14:05:22.580Z | 2024-11-08T14:15:23.747Z |
5480227 | 5480227 | 20241105120401_sSOL3 | NZ004U | 2024-11-06T14:04:59.851Z | 2024-11-08T14:15:19.785Z |
5480221 | 5480221 | 20241105120335_C8dWY | NZ004U | 2024-11-06T14:04:59.025Z | 2024-11-08T14:15:19.613Z |
5480180 | 5480180 | 20241105115655_gip3a | NZ004U | 2024-11-06T14:04:45.331Z | 2024-11-08T14:15:18.184Z |
5479091 | 5479091 | 20241105080032_rgzFB | NZ004U | 2024-11-06T14:00:58.578Z | 2024-11-08T14:14:41.872Z |
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);