participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
16 rows where station_code = "DK000A" 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 |
---|---|---|---|---|---|
5113394 | 5113394 | 20240915004524_rfTc9 | DK000A | 2024-09-18T12:04:13.652Z | 2024-09-20T12:15:55.500Z |
5103084 | 5103084 | 20240914020041_o3BAE | DK000A | 2024-09-17T12:07:51.353Z | 2024-09-20T12:18:55.826Z |
5097972 | 5097972 | 20240913011045_NfJ4V | DK000A | 2024-09-16T12:17:17.448Z | 2024-09-20T12:20:28.987Z |
5086760 | 5086760 | 20240912224703_aL5sW | DK000A | 2024-09-16T12:06:01.454Z | 2024-09-20T12:20:12.341Z |
5054160 | 5054160 | 20240908021704_wpyJ1 | DK000A | 2024-09-13T12:16:31.673Z | 2024-09-16T12:21:14.169Z |
5032111 | 5032111 | 20240907001454_8Kzxb | DK000A | 2024-09-12T12:06:33.816Z | 2024-09-15T12:21:25.243Z |
5009661 | 5009661 | 20240904014707_G1UFS | DK000A | 2024-09-09T12:07:54.597Z | 2024-09-12T12:19:23.973Z |
4991346 | 4991346 | 20240901022329_Cr0F5 | DK000A | 2024-09-07T12:11:57.636Z | 2024-09-09T12:27:05.917Z |
4991022 | 4991022 | 20240901014843_EEMVN | DK000A | 2024-09-07T12:11:29.082Z | 2024-09-09T12:26:58.169Z |
4990391 | 4990391 | 20240901001053_aFHL4 | DK000A | 2024-09-07T12:10:29.244Z | 2024-09-09T12:26:18.523Z |
4990379 | 4990379 | 20240901000902_HRU0I | DK000A | 2024-09-07T12:10:28.215Z | 2024-09-09T12:26:18.167Z |
4990377 | 4990377 | 20240901000842_KIz1T | DK000A | 2024-09-07T12:10:28.007Z | 2024-09-09T12:26:18.068Z |
4990313 | 4990313 | 20240901000118_ub19t | DK000A | 2024-09-07T12:10:20.113Z | 2024-09-09T12:26:16.231Z |
4742405 | 4742405 | 20240730005117_gYfrl | DK000A | 2024-08-04T12:03:11.954Z | 2024-08-08T12:17:10.546Z |
4666594 | 4666594 | 20240718235216_5KWOE | DK000A | 2024-07-20T12:02:39.898Z | 2024-07-27T12:17:03.825Z |
4219382 | 4219382 | 20240420015414_CVDqA | DK000A | 2024-04-21T12:01:40.560Z | 2024-04-28T12:21:15.603Z |
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);