participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
205 rows where station_code = "US004A" 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 |
---|---|---|---|---|---|
5560079 | 5560079 | 20241120115558_G2RqL | US004A | 2024-11-21T14:08:00.233Z | 2024-11-21T14:08:00.233Z |
5559886 | 5559886 | 20241120113021_8vmS3 | US004A | 2024-11-21T14:07:28.040Z | 2024-11-21T14:07:28.040Z |
5559610 | 5559610 | 20241120104903_MtBBV | US004A | 2024-11-21T14:06:43.119Z | 2024-11-21T14:06:43.119Z |
5559441 | 5559441 | 20241120102348_nI6tq | US004A | 2024-11-21T14:06:20.499Z | 2024-11-21T14:06:20.499Z |
5559391 | 5559391 | 20241120101653_76rwl | US004A | 2024-11-21T14:06:13.409Z | 2024-11-21T14:06:13.409Z |
5559365 | 5559365 | 20241120101229_iMQM5 | US004A | 2024-11-21T14:06:10.443Z | 2024-11-21T14:06:10.443Z |
5559342 | 5559342 | 20241120100602_7MLJ9 | US004A | 2024-11-21T14:06:01.526Z | 2024-11-21T14:06:01.526Z |
5559087 | 5559087 | 20241120092111_Z7Z1t | US004A | 2024-11-21T14:05:17.525Z | 2024-11-21T14:05:17.525Z |
5558881 | 5558881 | 20241120083909_nSIVr | US004A | 2024-11-21T14:04:43.050Z | 2024-11-21T14:04:43.050Z |
5558823 | 5558823 | 20241120081445_KcRRS | US004A | 2024-11-21T14:04:29.324Z | 2024-11-21T14:04:29.324Z |
5558732 | 5558732 | 20241120074815_H976c | US004A | 2024-11-21T14:04:11.948Z | 2024-11-21T14:04:11.948Z |
5558598 | 5558598 | 20241120064918_rDlMf | US004A | 2024-11-21T14:03:46.491Z | 2024-11-21T14:03:46.491Z |
5557756 | 5557756 | 20241120051026_ergiJ | US004A | 2024-11-21T14:01:40.388Z | 2024-11-21T14:01:40.388Z |
5556870 | 5556870 | 20241119022230_zGc6n | US004A | 2024-11-20T14:11:35.672Z | 2024-11-21T14:20:38.026Z |
5555174 | 5555174 | 20241119120216_TC4QN | US004A | 2024-11-20T14:04:39.296Z | 2024-11-21T14:18:53.218Z |
5554857 | 5554857 | 20241119105035_GpGwA | US004A | 2024-11-20T14:03:35.565Z | 2024-11-21T14:18:53.149Z |
5554803 | 5554803 | 20241119104141_hnzWk | US004A | 2024-11-20T14:03:19.719Z | 2024-11-21T14:18:53.137Z |
5554698 | 5554698 | 20241119101029_zyfrG | US004A | 2024-11-20T14:03:03.135Z | 2024-11-21T14:18:53.113Z |
5554616 | 5554616 | 20241119094844_TXFSi | US004A | 2024-11-20T14:02:42.245Z | 2024-11-21T14:18:53.095Z |
5554452 | 5554452 | 20241119090432_0fyPY | US004A | 2024-11-20T14:02:10.497Z | 2024-11-21T14:18:53.060Z |
5554430 | 5554430 | 20241119085631_BGBhD | US004A | 2024-11-20T14:02:01.203Z | 2024-11-21T14:18:53.055Z |
5554383 | 5554383 | 20241119083817_k6hbJ | US004A | 2024-11-20T14:01:49.989Z | 2024-11-21T14:18:53.042Z |
5554371 | 5554371 | 20241119083511_Oa0i5 | US004A | 2024-11-20T14:01:47.447Z | 2024-11-21T14:18:53.039Z |
5554342 | 5554342 | 20241119082244_Y3oMc | US004A | 2024-11-20T14:01:43.314Z | 2024-11-21T14:18:53.032Z |
5554315 | 5554315 | 20241119081008_ESs9A | US004A | 2024-11-20T14:01:36.433Z | 2024-11-21T14:18:53.025Z |
5554185 | 5554185 | 20241119065406_fuh1V | US004A | 2024-11-20T14:01:02.174Z | 2024-11-21T14:18:52.994Z |
5544492 | 5544492 | 20241116114419_ep6Lf | US004A | 2024-11-17T14:01:17.583Z | 2024-11-21T14:22:34.859Z |
5544028 | 5544028 | 20241115052041_tZk3N | US004A | 2024-11-16T14:07:50.717Z | 2024-11-21T14:24:37.809Z |
5542644 | 5542644 | 20241115112906_brUk9 | US004A | 2024-11-16T14:02:06.136Z | 2024-11-21T14:23:31.674Z |
5542568 | 5542568 | 20241115110041_JMXHV | US004A | 2024-11-16T14:01:48.795Z | 2024-11-21T14:23:29.726Z |
5542482 | 5542482 | 20241115100806_1NR4g | US004A | 2024-11-16T14:01:28.309Z | 2024-11-21T14:23:27.925Z |
5542397 | 5542397 | 20241115091226_a3F2k | US004A | 2024-11-16T14:01:09.240Z | 2024-11-21T14:23:26.498Z |
5542379 | 5542379 | 20241115090123_c3g2g | US004A | 2024-11-16T14:01:06.317Z | 2024-11-21T14:23:26.265Z |
5542311 | 5542311 | 20241115082247_nkAjj | US004A | 2024-11-16T14:00:56.798Z | 2024-11-21T14:23:25.181Z |
5542295 | 5542295 | 20241115080902_Z32Rj | US004A | 2024-11-16T14:00:55.178Z | 2024-11-21T14:23:24.963Z |
5542093 | 5542093 | 20241115053008_vyE0S | US004A | 2024-11-16T14:00:09.027Z | 2024-11-21T14:23:19.552Z |
5541757 | 5541757 | 20241114042103_PhOOv | US004A | 2024-11-15T14:08:21.961Z | 2024-11-21T14:25:18.457Z |
5540624 | 5540624 | 20241114114220_b3hmD | US004A | 2024-11-15T14:04:10.717Z | 2024-11-21T14:24:14.041Z |
5540555 | 5540555 | 20241114113035_aJ1yl | US004A | 2024-11-15T14:04:02.325Z | 2024-11-21T14:24:13.515Z |
5540372 | 5540372 | 20241114104614_Qvtf8 | US004A | 2024-11-15T14:03:31.658Z | 2024-11-21T14:24:10.864Z |
5540088 | 5540088 | 20241114100602_fV6CR | US004A | 2024-11-15T14:02:55.479Z | 2024-11-21T14:24:07.767Z |
5540082 | 5540082 | 20241114100326_a444s | US004A | 2024-11-15T14:02:52.722Z | 2024-11-21T14:24:07.698Z |
5540054 | 5540054 | 20241114095615_ngRh9 | US004A | 2024-11-15T14:02:44.389Z | 2024-11-21T14:24:07.385Z |
5539976 | 5539976 | 20241114094122_Dpx9l | US004A | 2024-11-15T14:02:27.532Z | 2024-11-21T14:24:06.349Z |
5539846 | 5539846 | 20241114091122_mgmbb | US004A | 2024-11-15T14:02:10.853Z | 2024-11-21T14:24:02.761Z |
5539725 | 5539725 | 20241114084545_M9IeP | US004A | 2024-11-15T14:01:45.838Z | 2024-11-21T14:24:00.525Z |
5539681 | 5539681 | 20241114083543_ohA39 | US004A | 2024-11-15T14:01:40.789Z | 2024-11-21T14:23:59.706Z |
5539653 | 5539653 | 20241114082336_ENMDC | US004A | 2024-11-15T14:01:36.794Z | 2024-11-21T14:23:58.781Z |
5539580 | 5539580 | 20241114075821_Ey8HY | US004A | 2024-11-15T14:01:27.764Z | 2024-11-21T14:23:57.821Z |
5539364 | 5539364 | 20241114063512_zic6j | US004A | 2024-11-15T14:00:50.303Z | 2024-11-21T14:23:54.486Z |
5539336 | 5539336 | 20241114061951_22M81 | US004A | 2024-11-15T14:00:44.925Z | 2024-11-21T14:23:54.047Z |
5534984 | 5534984 | 20241112112142_JKbjV | US004A | 2024-11-14T14:07:03.584Z | 2024-11-21T14:25:42.780Z |
5534949 | 5534949 | 20241112111519_x2Y8H | US004A | 2024-11-14T14:07:01.190Z | 2024-11-21T14:25:41.861Z |
5534197 | 5534197 | 20241113111720_zvI2R | US004A | 2024-11-14T14:03:44.578Z | 2024-11-21T14:24:59.748Z |
5533746 | 5533746 | 20241113100019_aGlrw | US004A | 2024-11-14T14:02:44.254Z | 2024-11-21T14:24:54.581Z |
5526803 | 5526803 | 20241112101702_tTCLK | US004A | 2024-11-13T14:04:11.600Z | 2024-11-21T14:25:38.693Z |
5526534 | 5526534 | 20241112094015_a1tzq | US004A | 2024-11-13T14:03:25.176Z | 2024-11-21T14:25:36.151Z |
5526376 | 5526376 | 20241112090833_sScEo | US004A | 2024-11-13T14:02:48.847Z | 2024-11-21T14:25:34.578Z |
5526223 | 5526223 | 20241112083442_DB5SZ | US004A | 2024-11-13T14:02:15.821Z | 2024-11-21T14:25:32.871Z |
5526074 | 5526074 | 20241112080009_bHn82 | US004A | 2024-11-13T14:01:48.958Z | 2024-11-21T14:25:30.360Z |
5519458 | 5519458 | 20241111112810_BXehV | US004A | 2024-11-12T14:04:05.576Z | 2024-11-20T14:24:50.655Z |
5519341 | 5519341 | 20241111110317_7SLI5 | US004A | 2024-11-12T14:03:47.867Z | 2024-11-20T14:24:47.816Z |
5519142 | 5519142 | 20241111102256_VZYOt | US004A | 2024-11-12T14:03:10.688Z | 2024-11-20T14:24:45.715Z |
5519000 | 5519000 | 20241111095212_wH1ZT | US004A | 2024-11-12T14:02:36.075Z | 2024-11-20T14:24:43.857Z |
5518977 | 5518977 | 20241111094613_STFwn | US004A | 2024-11-12T14:02:31.638Z | 2024-11-20T14:24:43.618Z |
5518845 | 5518845 | 20241111092034_8XalC | US004A | 2024-11-12T14:02:12.373Z | 2024-11-20T14:24:41.921Z |
5518317 | 5518317 | 20241111070247_gkzIv | US004A | 2024-11-12T14:00:33.273Z | 2024-11-20T14:24:32.080Z |
5513009 | 5513009 | 20241110102124_LqgaL | US004A | 2024-11-11T14:03:44.386Z | 2024-11-19T14:21:30.271Z |
5512787 | 5512787 | 20241110094755_4irKu | US004A | 2024-11-11T14:03:08.734Z | 2024-11-19T14:21:28.442Z |
5507261 | 5507261 | 20241109110000_dGVTN | US004A | 2024-11-10T14:04:43.615Z | 2024-11-18T14:26:08.976Z |
5491849 | 5491849 | 20241106053307_O5Dbl | US004A | 2024-11-07T14:17:10.306Z | 2024-11-14T14:23:26.987Z |
5491829 | 5491829 | 20241106052357_vAiCQ | US004A | 2024-11-07T14:17:05.864Z | 2024-11-14T14:23:26.936Z |
5491219 | 5491219 | 20241106022535_JakYh | US004A | 2024-11-07T14:15:32.875Z | 2024-11-14T14:23:24.708Z |
5486493 | 5486493 | 20241106115251_AgWhF | US004A | 2024-11-07T14:03:13.151Z | 2024-11-15T14:24:30.664Z |
5486428 | 5486428 | 20241106113528_c3cmM | US004A | 2024-11-07T14:02:56.827Z | 2024-11-15T14:24:30.031Z |
5486359 | 5486359 | 20241106110644_2YmSZ | US004A | 2024-11-07T14:02:42.745Z | 2024-11-15T14:24:29.542Z |
5486333 | 5486333 | 20241106105044_PXAHD | US004A | 2024-11-07T14:02:38.626Z | 2024-11-15T14:24:28.860Z |
5486181 | 5486181 | 20241106095939_IeeZE | US004A | 2024-11-07T14:02:09.458Z | 2024-11-15T14:24:27.143Z |
5486039 | 5486039 | 20241106091657_PE4k0 | US004A | 2024-11-07T14:01:37.317Z | 2024-11-15T14:24:25.454Z |
5486012 | 5486012 | 20241106090954_nmvWM | US004A | 2024-11-07T14:01:29.427Z | 2024-11-15T14:24:24.880Z |
5485879 | 5485879 | 20241106081323_hVfZX | US004A | 2024-11-07T14:00:59.325Z | 2024-11-15T14:24:23.886Z |
5485834 | 5485834 | 20241106074927_APkRc | US004A | 2024-11-07T14:00:46.146Z | 2024-11-15T14:24:23.689Z |
5485769 | 5485769 | 20241106072351_THXq3 | US004A | 2024-11-07T14:00:34.557Z | 2024-11-15T14:24:23.185Z |
5421174 | 5421174 | 20241028045629_C0pPj | US004A | 2024-10-30T12:19:40.012Z | 2024-11-05T14:27:17.639Z |
5412872 | 5412872 | 20241028075608_AcA2W | US004A | 2024-10-30T12:01:01.895Z | 2024-11-06T14:27:03.419Z |
5412675 | 5412675 | 20241028070247_U1PZA | US004A | 2024-10-30T12:00:17.933Z | 2024-11-06T14:27:01.617Z |
5412233 | 5412233 | 20241027101346_UH7X8 | US004A | 2024-10-29T12:19:34.442Z | 2024-11-05T14:26:57.926Z |
5411941 | 5411941 | 20241027094129_hDjbn | US004A | 2024-10-29T12:19:19.756Z | 2024-11-05T14:26:56.918Z |
5411746 | 5411746 | 20241027091938_WKghZ | US004A | 2024-10-29T12:19:10.458Z | 2024-11-05T14:26:55.887Z |
5411629 | 5411629 | 20241027090531_3pGSl | US004A | 2024-10-29T12:19:04.491Z | 2024-11-05T14:26:55.148Z |
5411149 | 5411149 | 20241027063458_LwTj0 | US004A | 2024-10-29T12:18:28.866Z | 2024-11-04T14:29:07.292Z |
5408228 | 5408228 | 20241027031746_eS6LM | US004A | 2024-10-29T12:16:18.024Z | 2024-11-04T14:28:59.012Z |
5401695 | 5401695 | 20241026102245_ZOP7m | US004A | 2024-10-29T12:03:31.298Z | 2024-11-04T14:28:31.182Z |
5401237 | 5401237 | 20241027072844_dqtkS | US004A | 2024-10-29T12:00:55.109Z | 2024-11-05T14:26:50.729Z |
5401139 | 5401139 | 20241027071353_tD1nH | US004A | 2024-10-29T12:00:40.243Z | 2024-11-05T14:26:50.264Z |
5401074 | 5401074 | 20241027070152_mqLqs | US004A | 2024-10-29T12:00:27.146Z | 2024-11-05T14:26:49.989Z |
5391295 | 5391295 | 20241026113531_UK0mh | US004A | 2024-10-28T12:05:10.358Z | 2024-11-04T14:28:34.110Z |
5389525 | 5389525 | 20241026071433_qQHNp | US004A | 2024-10-28T12:00:34.940Z | 2024-11-04T14:28:22.944Z |
5389498 | 5389498 | 20241026071016_sO2iS | US004A | 2024-10-28T12:00:27.341Z | 2024-11-04T14:28:22.817Z |
5388625 | 5388625 | 20241025054117_3SaCo | US004A | 2024-10-27T12:22:23.759Z | 2024-11-02T12:28:34.686Z |
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);