participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,382 rows where station_code = "SK0004" 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 |
---|---|---|---|---|---|
5505347 | 5505347 | 20241108044409_1WZXN | SK0004 | 2024-11-09T14:16:12.137Z | 2024-11-09T14:16:28.761Z |
5505293 | 5505293 | 20241108042611_SaJNX | SK0004 | 2024-11-09T14:16:05.456Z | 2024-11-09T14:16:28.746Z |
5505257 | 5505257 | 20241108041804_YResH | SK0004 | 2024-11-09T14:16:00.273Z | 2024-11-09T14:16:28.737Z |
5505162 | 5505162 | 20241108040138_63yOg | SK0004 | 2024-11-09T14:15:52.352Z | 2024-11-09T14:16:28.715Z |
5505157 | 5505157 | 20241108040116_qTyVL | SK0004 | 2024-11-09T14:15:51.617Z | 2024-11-09T14:16:28.714Z |
5504921 | 5504921 | 20241108031912_8tIZ7 | SK0004 | 2024-11-09T14:15:23.719Z | 2024-11-09T14:16:28.658Z |
5504867 | 5504867 | 20241108030916_fPjYe | SK0004 | 2024-11-09T14:15:17.832Z | 2024-11-09T14:16:28.644Z |
5504840 | 5504840 | 20241108030509_IVLjr | SK0004 | 2024-11-09T14:15:15.199Z | 2024-11-09T14:16:28.638Z |
5504837 | 5504837 | 20241108030411_01xyg | SK0004 | 2024-11-09T14:15:14.853Z | 2024-11-09T14:16:28.637Z |
5504800 | 5504800 | 20241108025943_n2od3 | SK0004 | 2024-11-09T14:15:12.109Z | 2024-11-09T14:16:28.628Z |
5504740 | 5504740 | 20241108025016_VxlCI | SK0004 | 2024-11-09T14:15:08.334Z | 2024-11-09T14:16:28.614Z |
5504639 | 5504639 | 20241108023126_nnesd | SK0004 | 2024-11-09T14:14:59.736Z | 2024-11-09T14:16:28.589Z |
5504479 | 5504479 | 20241108020416_KXHEM | SK0004 | 2024-11-09T14:14:43.399Z | 2024-11-09T14:16:28.549Z |
5504183 | 5504183 | 20241108010957_asSsM | SK0004 | 2024-11-09T14:14:11.844Z | 2024-11-09T14:16:28.469Z |
5503997 | 5503997 | 20241108003832_nicwl | SK0004 | 2024-11-09T14:13:57.593Z | 2024-11-09T14:16:28.423Z |
5503681 | 5503681 | 20241107232817_bW3h1 | SK0004 | 2024-11-09T14:13:34.225Z | 2024-11-09T14:16:28.319Z |
5503552 | 5503552 | 20241107224847_ahvTm | SK0004 | 2024-11-09T14:13:17.494Z | 2024-11-09T14:16:28.289Z |
5503392 | 5503392 | 20241107220415_cuXDr | SK0004 | 2024-11-09T14:12:58.588Z | 2024-11-09T14:16:28.240Z |
5503167 | 5503167 | 20241107205607_40jx2 | SK0004 | 2024-11-09T14:12:30.583Z | 2024-11-09T14:16:28.182Z |
5503042 | 5503042 | 20241107203131_JDRxm | SK0004 | 2024-11-09T14:12:21.278Z | 2024-11-09T14:16:28.153Z |
5502262 | 5502262 | 20241107175118_KaeY3 | SK0004 | 2024-11-09T14:11:06.518Z | 2024-11-09T14:16:27.992Z |
5497643 | 5497643 | 20241107041652_zMwIi | SK0004 | 2024-11-08T14:14:07.407Z | 2024-11-09T14:18:49.279Z |
5497545 | 5497545 | 20241107035809_SLPd7 | SK0004 | 2024-11-08T14:13:57.481Z | 2024-11-09T14:18:45.857Z |
5497476 | 5497476 | 20241107034752_bprPC | SK0004 | 2024-11-08T14:13:50.991Z | 2024-11-09T14:18:44.337Z |
5497383 | 5497383 | 20241107033121_cPrtY | SK0004 | 2024-11-08T14:13:39.911Z | 2024-11-09T14:18:41.903Z |
5497086 | 5497086 | 20241107023956_Q3436 | SK0004 | 2024-11-08T14:13:09.272Z | 2024-11-09T14:18:35.387Z |
5496987 | 5496987 | 20241107022340_EqZSY | SK0004 | 2024-11-08T14:13:02.179Z | 2024-11-09T14:18:33.971Z |
5496932 | 5496932 | 20241107021151_xjMGv | SK0004 | 2024-11-08T14:12:59.571Z | 2024-11-09T14:18:33.277Z |
5496864 | 5496864 | 20241107020126_Y5xr1 | SK0004 | 2024-11-08T14:12:55.823Z | 2024-11-09T14:18:31.652Z |
5496857 | 5496857 | 20241107015854_Q1yIA | SK0004 | 2024-11-08T14:12:55.347Z | 2024-11-09T14:18:31.373Z |
5496820 | 5496820 | 20241107014801_UtMpL | SK0004 | 2024-11-08T14:12:53.505Z | 2024-11-09T14:18:30.862Z |
5496741 | 5496741 | 20241107012823_lru59 | SK0004 | 2024-11-08T14:12:48.951Z | 2024-11-09T14:18:29.302Z |
5496704 | 5496704 | 20241107012111_yUKxv | SK0004 | 2024-11-08T14:12:44.222Z | 2024-11-09T14:18:27.800Z |
5496469 | 5496469 | 20241107003051_e7jSh | SK0004 | 2024-11-08T14:12:12.390Z | 2024-11-09T14:18:22.832Z |
5496075 | 5496075 | 20241106225155_SYiJL | SK0004 | 2024-11-08T14:11:30.338Z | 2024-11-09T14:18:15.843Z |
5495917 | 5495917 | 20241106220549_sn9ay | SK0004 | 2024-11-08T14:11:07.589Z | 2024-11-09T14:18:11.502Z |
5495800 | 5495800 | 20241106213632_Dl0wC | SK0004 | 2024-11-08T14:10:54.569Z | 2024-11-09T14:18:09.315Z |
5495482 | 5495482 | 20241106200042_Z9hbd | SK0004 | 2024-11-08T14:10:17.456Z | 2024-11-09T14:17:55.285Z |
5491432 | 5491432 | 20241106031635_X2NP8 | SK0004 | 2024-11-07T14:16:07.221Z | 2024-11-09T14:20:07.640Z |
5491382 | 5491382 | 20241106030937_lIhP3 | SK0004 | 2024-11-07T14:16:01.299Z | 2024-11-09T14:20:07.285Z |
5491282 | 5491282 | 20241106024727_tjlSS | SK0004 | 2024-11-07T14:15:46.494Z | 2024-11-09T14:20:06.305Z |
5491215 | 5491215 | 20241106022417_K2gis | SK0004 | 2024-11-07T14:15:32.301Z | 2024-11-09T14:20:05.619Z |
5491188 | 5491188 | 20241106021832_RsxfM | SK0004 | 2024-11-07T14:15:25.290Z | 2024-11-09T14:20:05.051Z |
5491047 | 5491047 | 20241106014326_cR81T | SK0004 | 2024-11-07T14:15:15.085Z | 2024-11-09T14:20:03.332Z |
5490941 | 5490941 | 20241106012021_LfPNa | SK0004 | 2024-11-07T14:15:06.397Z | 2024-11-09T14:20:02.097Z |
5490913 | 5490913 | 20241106011025_WQe9i | SK0004 | 2024-11-07T14:15:04.858Z | 2024-11-09T14:20:01.527Z |
5490902 | 5490902 | 20241106010840_0SQCh | SK0004 | 2024-11-07T14:15:03.949Z | 2024-11-09T14:20:01.268Z |
5490760 | 5490760 | 20241106003136_gbcnb | SK0004 | 2024-11-07T14:14:50.864Z | 2024-11-09T14:19:59.292Z |
5490752 | 5490752 | 20241106002957_sVNpQ | SK0004 | 2024-11-07T14:14:48.778Z | 2024-11-09T14:19:59.165Z |
5490708 | 5490708 | 20241106001445_rclki | SK0004 | 2024-11-07T14:14:36.065Z | 2024-11-09T14:19:58.770Z |
5490691 | 5490691 | 20241106001034_2vb8f | SK0004 | 2024-11-07T14:14:32.756Z | 2024-11-09T14:19:58.578Z |
5490622 | 5490622 | 20241105234042_D02D6 | SK0004 | 2024-11-07T14:14:19.107Z | 2024-11-09T14:19:57.396Z |
5490402 | 5490402 | 20241105223542_632BI | SK0004 | 2024-11-07T14:13:58.526Z | 2024-11-09T14:19:54.759Z |
5489597 | 5489597 | 20241105192335_gy9Oy | SK0004 | 2024-11-07T14:12:15.862Z | 2024-11-09T14:19:44.821Z |
5489289 | 5489289 | 20241105182859_YgmzH | SK0004 | 2024-11-07T14:11:50.583Z | 2024-11-09T14:19:40.913Z |
5485140 | 5485140 | 20241105040923_DqTTZ | SK0004 | 2024-11-06T14:17:49.350Z | 2024-11-09T14:21:19.640Z |
5485032 | 5485032 | 20241105035528_90Gcx | SK0004 | 2024-11-06T14:17:40.027Z | 2024-11-09T14:21:18.847Z |
5484996 | 5484996 | 20241105035212_oGKXo | SK0004 | 2024-11-06T14:17:37.097Z | 2024-11-09T14:21:18.609Z |
5484949 | 5484949 | 20241105034620_pwPbh | SK0004 | 2024-11-06T14:17:32.905Z | 2024-11-09T14:21:17.686Z |
5484831 | 5484831 | 20241105033221_yEQF6 | SK0004 | 2024-11-06T14:17:21.507Z | 2024-11-09T14:21:16.796Z |
5484698 | 5484698 | 20241105032028_em2GT | SK0004 | 2024-11-06T14:17:10.401Z | 2024-11-09T14:21:15.915Z |
5484586 | 5484586 | 20241105030652_Y3pP4 | SK0004 | 2024-11-06T14:17:02.662Z | 2024-11-09T14:21:15.186Z |
5484579 | 5484579 | 20241105030635_ZRQ8m | SK0004 | 2024-11-06T14:17:02.041Z | 2024-11-09T14:21:15.157Z |
5484340 | 5484340 | 20241105023617_oaBYV | SK0004 | 2024-11-06T14:16:49.477Z | 2024-11-09T14:21:13.372Z |
5484233 | 5484233 | 20241105022217_F4QXT | SK0004 | 2024-11-06T14:16:36.176Z | 2024-11-09T14:21:12.256Z |
5484215 | 5484215 | 20241105022125_PPmCf | SK0004 | 2024-11-06T14:16:32.670Z | 2024-11-09T14:21:11.948Z |
5484158 | 5484158 | 20241105021542_xwWNl | SK0004 | 2024-11-06T14:16:23.327Z | 2024-11-09T14:21:11.474Z |
5484136 | 5484136 | 20241105021340_ZTmxA | SK0004 | 2024-11-06T14:16:21.284Z | 2024-11-09T14:21:11.186Z |
5483829 | 5483829 | 20241105013539_iAv2N | SK0004 | 2024-11-06T14:15:44.826Z | 2024-11-09T14:21:08.596Z |
5483722 | 5483722 | 20241105012409_5ba0n | SK0004 | 2024-11-06T14:15:38.048Z | 2024-11-09T14:21:07.052Z |
5483372 | 5483372 | 20241105003251_PI9hf | SK0004 | 2024-11-06T14:15:04.903Z | 2024-11-09T14:21:05.052Z |
5483178 | 5483178 | 20241105000732_0aBe2 | SK0004 | 2024-11-06T14:14:44.641Z | 2024-11-09T14:21:03.971Z |
5483156 | 5483156 | 20241105000457_ot589 | SK0004 | 2024-11-06T14:14:43.012Z | 2024-11-09T14:21:03.770Z |
5483004 | 5483004 | 20241104234730_H3RK1 | SK0004 | 2024-11-06T14:14:34.398Z | 2024-11-09T14:21:02.889Z |
5482931 | 5482931 | 20241104233447_zNeOU | SK0004 | 2024-11-06T14:14:21.515Z | 2024-11-09T14:21:02.423Z |
5482799 | 5482799 | 20241104231526_mRUyc | SK0004 | 2024-11-06T14:14:01.942Z | 2024-11-09T14:21:01.605Z |
5482597 | 5482597 | 20241104224651_bTI0v | SK0004 | 2024-11-06T14:13:25.548Z | 2024-11-09T14:21:00.464Z |
5482539 | 5482539 | 20241104223740_mDsia | SK0004 | 2024-11-06T14:13:19.443Z | 2024-11-09T14:21:00.058Z |
5482394 | 5482394 | 20241104220605_1upN2 | SK0004 | 2024-11-06T14:13:07.342Z | 2024-11-09T14:20:58.850Z |
5482377 | 5482377 | 20241104220112_Ac6oB | SK0004 | 2024-11-06T14:13:05.968Z | 2024-11-09T14:20:58.773Z |
5481964 | 5481964 | 20241104203031_sG99V | SK0004 | 2024-11-06T14:12:07.440Z | 2024-11-09T14:20:53.338Z |
5481769 | 5481769 | 20241104193819_mnQvH | SK0004 | 2024-11-06T14:11:32.979Z | 2024-11-09T14:20:50.556Z |
5481721 | 5481721 | 20241104192237_QSwBM | SK0004 | 2024-11-06T14:11:27.120Z | 2024-11-09T14:20:50.002Z |
5481675 | 5481675 | 20241104191407_YIxra | SK0004 | 2024-11-06T14:11:17.563Z | 2024-11-09T14:20:49.345Z |
5481589 | 5481589 | 20241104184238_4MiiM | SK0004 | 2024-11-06T14:10:53.553Z | 2024-11-09T14:20:47.697Z |
5481585 | 5481585 | 20241104184155_BVYRW | SK0004 | 2024-11-06T14:10:53.243Z | 2024-11-09T14:20:47.574Z |
5481459 | 5481459 | 20241104174830_A1APp | SK0004 | 2024-11-06T14:10:35.576Z | 2024-11-09T14:20:46.113Z |
5481339 | 5481339 | 20241104170658_S0CQi | SK0004 | 2024-11-06T14:10:06.113Z | 2024-11-09T14:20:44.312Z |
5478593 | 5478593 | 20241104043834_Y8wP2 | SK0004 | 2024-11-05T14:18:32.970Z | 2024-11-09T14:22:30.053Z |
5478461 | 5478461 | 20241104041407_qH7rr | SK0004 | 2024-11-05T14:18:23.993Z | 2024-11-09T14:22:28.296Z |
5478267 | 5478267 | 20241104034427_sir7b | SK0004 | 2024-11-05T14:18:07.702Z | 2024-11-09T14:22:26.375Z |
5478255 | 5478255 | 20241104034224_K1EQB | SK0004 | 2024-11-05T14:18:06.912Z | 2024-11-09T14:22:26.338Z |
5478136 | 5478136 | 20241104032431_rzHDN | SK0004 | 2024-11-05T14:17:58.469Z | 2024-11-09T14:22:25.412Z |
5478064 | 5478064 | 20241104031543_Dzw0R | SK0004 | 2024-11-05T14:17:50.875Z | 2024-11-09T14:22:24.730Z |
5478005 | 5478005 | 20241104030614_52o3y | SK0004 | 2024-11-05T14:17:44.348Z | 2024-11-09T14:22:23.538Z |
5477977 | 5477977 | 20241104030344_smRyX | SK0004 | 2024-11-05T14:17:41.727Z | 2024-11-09T14:22:23.201Z |
5477852 | 5477852 | 20241104024621_OmTRX | SK0004 | 2024-11-05T14:17:31.951Z | 2024-11-09T14:22:22.438Z |
5477836 | 5477836 | 20241104024343_2jEKZ | SK0004 | 2024-11-05T14:17:30.595Z | 2024-11-09T14:22:22.419Z |
5477634 | 5477634 | 20241104021625_adMq5 | SK0004 | 2024-11-05T14:17:10.866Z | 2024-11-09T14:22:20.222Z |
5477574 | 5477574 | 20241104021008_pvAPj | SK0004 | 2024-11-05T14:17:04.537Z | 2024-11-09T14:22:19.634Z |
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);