participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,451 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 |
---|---|---|---|---|---|
5573093 | 5573093 | 20241121035039_ki7eb | SK0004 | 2024-11-22T14:19:09.579Z | 2024-11-22T14:19:22.448Z |
5572978 | 5572978 | 20241121033246_E2TKb | SK0004 | 2024-11-22T14:19:02.043Z | 2024-11-22T14:19:22.425Z |
5572950 | 5572950 | 20241121032837_9Lnv2 | SK0004 | 2024-11-22T14:19:00.523Z | 2024-11-22T14:19:22.420Z |
5572936 | 5572936 | 20241121032718_2u53t | SK0004 | 2024-11-22T14:18:59.878Z | 2024-11-22T14:19:22.417Z |
5572897 | 5572897 | 20241121032308_nyDM3 | SK0004 | 2024-11-22T14:18:57.325Z | 2024-11-22T14:19:22.410Z |
5572517 | 5572517 | 20241121023144_gh41o | SK0004 | 2024-11-22T14:18:31.610Z | 2024-11-22T14:19:22.343Z |
5572075 | 5572075 | 20241121012943_9tpl7 | SK0004 | 2024-11-22T14:17:56.391Z | 2024-11-22T14:19:22.254Z |
5572053 | 5572053 | 20241121012609_24wsx | SK0004 | 2024-11-22T14:17:54.803Z | 2024-11-22T14:19:22.250Z |
5571969 | 5571969 | 20241121011407_6VdHY | SK0004 | 2024-11-22T14:17:50.035Z | 2024-11-22T14:19:22.233Z |
5571942 | 5571942 | 20241121010957_9NGvn | SK0004 | 2024-11-22T14:17:48.426Z | 2024-11-22T14:19:22.228Z |
5571884 | 5571884 | 20241121005947_ER0VL | SK0004 | 2024-11-22T14:17:44.639Z | 2024-11-22T14:19:22.214Z |
5571694 | 5571694 | 20241121003254_s1Ply | SK0004 | 2024-11-22T14:17:35.111Z | 2024-11-22T14:19:22.176Z |
5571655 | 5571655 | 20241121002750_xOQpP | SK0004 | 2024-11-22T14:17:32.863Z | 2024-11-22T14:19:22.167Z |
5571633 | 5571633 | 20241121002243_2mWTb | SK0004 | 2024-11-22T14:17:28.388Z | 2024-11-22T14:19:22.163Z |
5571621 | 5571621 | 20241121001944_7SMxU | SK0004 | 2024-11-22T14:17:26.478Z | 2024-11-22T14:19:22.161Z |
5571561 | 5571561 | 20241121000815_zi02e | SK0004 | 2024-11-22T14:17:17.388Z | 2024-11-22T14:19:22.149Z |
5571559 | 5571559 | 20241121000748_NRqrI | SK0004 | 2024-11-22T14:17:17.207Z | 2024-11-22T14:19:22.148Z |
5571320 | 5571320 | 20241120232228_EGw2f | SK0004 | 2024-11-22T14:16:50.729Z | 2024-11-22T14:19:22.100Z |
5571249 | 5571249 | 20241120230749_22sta | SK0004 | 2024-11-22T14:16:43.684Z | 2024-11-22T14:19:22.078Z |
5571203 | 5571203 | 20241120225152_Nn9oG | SK0004 | 2024-11-22T14:16:37.349Z | 2024-11-22T14:19:22.063Z |
5571191 | 5571191 | 20241120224901_zBE1g | SK0004 | 2024-11-22T14:16:36.008Z | 2024-11-22T14:19:22.060Z |
5570581 | 5570581 | 20241120201759_a6tFn | SK0004 | 2024-11-22T14:15:50.347Z | 2024-11-22T14:19:21.943Z |
5569957 | 5569957 | 20241120180817_UzKCY | SK0004 | 2024-11-22T14:14:40.341Z | 2024-11-22T14:19:21.837Z |
5548119 | 5548119 | 20241116195543_LAk6g | SK0004 | 2024-11-18T14:08:16.473Z | 2024-11-22T14:23:10.012Z |
5548114 | 5548114 | 20241116195333_OI0fp | SK0004 | 2024-11-18T14:08:15.627Z | 2024-11-22T14:23:09.939Z |
5548108 | 5548108 | 20241116195136_Xwk1k | SK0004 | 2024-11-18T14:08:12.965Z | 2024-11-22T14:23:09.796Z |
5548057 | 5548057 | 20241116185536_dXAUo | SK0004 | 2024-11-18T14:07:56.352Z | 2024-11-22T14:23:08.844Z |
5548047 | 5548047 | 20241116184743_FJr8n | SK0004 | 2024-11-18T14:07:53.854Z | 2024-11-22T14:23:08.689Z |
5548006 | 5548006 | 20241116171648_gzjnt | SK0004 | 2024-11-18T14:07:45.048Z | 2024-11-22T14:23:07.291Z |
5517720 | 5517720 | 20241110043558_7ylLW | SK0004 | 2024-11-11T14:14:46.595Z | 2024-11-18T14:26:37.964Z |
5517715 | 5517715 | 20241110043526_2Y724 | SK0004 | 2024-11-11T14:14:46.504Z | 2024-11-18T14:26:37.959Z |
5517527 | 5517527 | 20241110035727_v1J1z | SK0004 | 2024-11-11T14:14:32.524Z | 2024-11-18T14:26:36.980Z |
5517308 | 5517308 | 20241110032211_mo7hB | SK0004 | 2024-11-11T14:14:13.323Z | 2024-11-18T14:26:35.825Z |
5517267 | 5517267 | 20241110031602_8TIPT | SK0004 | 2024-11-11T14:14:11.183Z | 2024-11-18T14:26:35.691Z |
5517206 | 5517206 | 20241110030230_3fm3A | SK0004 | 2024-11-11T14:14:04.128Z | 2024-11-18T14:26:35.319Z |
5517114 | 5517114 | 20241110024930_9Alt2 | SK0004 | 2024-11-11T14:13:56.372Z | 2024-11-18T14:26:34.789Z |
5517000 | 5517000 | 20241110023110_EP5lt | SK0004 | 2024-11-11T14:13:41.877Z | 2024-11-18T14:26:34.168Z |
5516989 | 5516989 | 20241110023037_Xeiny | SK0004 | 2024-11-11T14:13:40.692Z | 2024-11-18T14:26:34.127Z |
5516914 | 5516914 | 20241110021923_5Em2b | SK0004 | 2024-11-11T14:13:32.356Z | 2024-11-18T14:26:33.772Z |
5516831 | 5516831 | 20241110020749_e1Vp7 | SK0004 | 2024-11-11T14:13:25.407Z | 2024-11-18T14:26:33.489Z |
5516779 | 5516779 | 20241110015949_VCUBI | SK0004 | 2024-11-11T14:13:20.791Z | 2024-11-18T14:26:33.223Z |
5516762 | 5516762 | 20241110015548_W87Xo | SK0004 | 2024-11-11T14:13:18.601Z | 2024-11-18T14:26:33.158Z |
5516724 | 5516724 | 20241110014940_l56Lo | SK0004 | 2024-11-11T14:13:17.071Z | 2024-11-18T14:26:32.996Z |
5516607 | 5516607 | 20241110012759_5X1pZ | SK0004 | 2024-11-11T14:13:10.695Z | 2024-11-18T14:26:32.311Z |
5516440 | 5516440 | 20241110010016_DRuab | SK0004 | 2024-11-11T14:13:01.340Z | 2024-11-18T14:26:31.230Z |
5516360 | 5516360 | 20241110004557_Kjsd3 | SK0004 | 2024-11-11T14:12:52.584Z | 2024-11-18T14:26:30.835Z |
5515991 | 5515991 | 20241109232629_PgXJR | SK0004 | 2024-11-11T14:11:53.580Z | 2024-11-18T14:26:28.855Z |
5515549 | 5515549 | 20241109215643_EfdyU | SK0004 | 2024-11-11T14:11:12.844Z | 2024-11-18T14:26:26.692Z |
5515508 | 5515508 | 20241109214143_oXx0P | SK0004 | 2024-11-11T14:11:09.456Z | 2024-11-18T14:26:26.414Z |
5515487 | 5515487 | 20241109213743_4DCon | SK0004 | 2024-11-11T14:11:07.744Z | 2024-11-18T14:26:26.269Z |
5515428 | 5515428 | 20241109212141_P2kz2 | SK0004 | 2024-11-11T14:11:03.620Z | 2024-11-18T14:26:25.994Z |
5515372 | 5515372 | 20241109205946_CQk2c | SK0004 | 2024-11-11T14:10:51.603Z | 2024-11-18T14:26:25.741Z |
5511043 | 5511043 | 20241109041232_FeUjq | SK0004 | 2024-11-10T14:16:07.631Z | 2024-11-17T14:24:03.742Z |
5510890 | 5510890 | 20241109034912_2umK7 | SK0004 | 2024-11-10T14:15:51.097Z | 2024-11-17T14:24:02.295Z |
5510780 | 5510780 | 20241109033600_6VXVg | SK0004 | 2024-11-10T14:15:41.753Z | 2024-11-17T14:24:01.272Z |
5510732 | 5510732 | 20241109033047_NTqKc | SK0004 | 2024-11-10T14:15:36.600Z | 2024-11-17T14:24:00.723Z |
5510534 | 5510534 | 20241109025542_VE1HY | SK0004 | 2024-11-10T14:15:25.219Z | 2024-11-17T14:23:58.787Z |
5510443 | 5510443 | 20241109024146_DBNoD | SK0004 | 2024-11-10T14:15:14.691Z | 2024-11-17T14:23:57.549Z |
5510348 | 5510348 | 20241109022350_WBgyg | SK0004 | 2024-11-10T14:15:04.005Z | 2024-11-17T14:23:56.429Z |
5510287 | 5510287 | 20241109021629_U3Krr | SK0004 | 2024-11-10T14:14:57.346Z | 2024-11-17T14:23:55.649Z |
5510258 | 5510258 | 20241109020844_d8Y3l | SK0004 | 2024-11-10T14:14:52.826Z | 2024-11-17T14:23:54.605Z |
5510208 | 5510208 | 20241109015845_ZKYFV | SK0004 | 2024-11-10T14:14:47.513Z | 2024-11-17T14:23:53.988Z |
5510106 | 5510106 | 20241109014336_JEVcd | SK0004 | 2024-11-10T14:14:35.814Z | 2024-11-17T14:23:53.022Z |
5510057 | 5510057 | 20241109013752_bvzNn | SK0004 | 2024-11-10T14:14:31.313Z | 2024-11-17T14:23:52.479Z |
5510010 | 5510010 | 20241109012645_UB9I6 | SK0004 | 2024-11-10T14:14:26.174Z | 2024-11-17T14:23:51.732Z |
5509989 | 5509989 | 20241109012344_1Bq3E | SK0004 | 2024-11-10T14:14:23.797Z | 2024-11-17T14:23:51.567Z |
5509977 | 5509977 | 20241109011953_jEymd | SK0004 | 2024-11-10T14:14:21.329Z | 2024-11-17T14:23:51.486Z |
5509608 | 5509608 | 20241108235434_hHRkW | SK0004 | 2024-11-10T14:13:39.978Z | 2024-11-17T14:23:47.768Z |
5509585 | 5509585 | 20241108235128_YRQsJ | SK0004 | 2024-11-10T14:13:37.357Z | 2024-11-17T14:23:47.334Z |
5505347 | 5505347 | 20241108044409_1WZXN | SK0004 | 2024-11-09T14:16:12.137Z | 2024-11-16T14:28:30.542Z |
5505293 | 5505293 | 20241108042611_SaJNX | SK0004 | 2024-11-09T14:16:05.456Z | 2024-11-16T14:28:29.603Z |
5505257 | 5505257 | 20241108041804_YResH | SK0004 | 2024-11-09T14:16:00.273Z | 2024-11-16T14:28:28.719Z |
5505162 | 5505162 | 20241108040138_63yOg | SK0004 | 2024-11-09T14:15:52.352Z | 2024-11-16T14:28:28.260Z |
5505157 | 5505157 | 20241108040116_qTyVL | SK0004 | 2024-11-09T14:15:51.617Z | 2024-11-16T14:28:28.238Z |
5504921 | 5504921 | 20241108031912_8tIZ7 | SK0004 | 2024-11-09T14:15:23.719Z | 2024-11-16T14:28:24.911Z |
5504867 | 5504867 | 20241108030916_fPjYe | SK0004 | 2024-11-09T14:15:17.832Z | 2024-11-16T14:28:24.272Z |
5504840 | 5504840 | 20241108030509_IVLjr | SK0004 | 2024-11-09T14:15:15.199Z | 2024-11-16T14:28:24.058Z |
5504837 | 5504837 | 20241108030411_01xyg | SK0004 | 2024-11-09T14:15:14.853Z | 2024-11-16T14:28:23.906Z |
5504800 | 5504800 | 20241108025943_n2od3 | SK0004 | 2024-11-09T14:15:12.109Z | 2024-11-16T14:28:23.570Z |
5504740 | 5504740 | 20241108025016_VxlCI | SK0004 | 2024-11-09T14:15:08.334Z | 2024-11-16T14:28:23.107Z |
5504639 | 5504639 | 20241108023126_nnesd | SK0004 | 2024-11-09T14:14:59.736Z | 2024-11-16T14:28:21.894Z |
5504479 | 5504479 | 20241108020416_KXHEM | SK0004 | 2024-11-09T14:14:43.399Z | 2024-11-16T14:28:20.310Z |
5504183 | 5504183 | 20241108010957_asSsM | SK0004 | 2024-11-09T14:14:11.844Z | 2024-11-16T14:28:16.835Z |
5503997 | 5503997 | 20241108003832_nicwl | SK0004 | 2024-11-09T14:13:57.593Z | 2024-11-16T14:28:14.919Z |
5503681 | 5503681 | 20241107232817_bW3h1 | SK0004 | 2024-11-09T14:13:34.225Z | 2024-11-16T14:28:11.121Z |
5503552 | 5503552 | 20241107224847_ahvTm | SK0004 | 2024-11-09T14:13:17.494Z | 2024-11-16T14:28:08.784Z |
5503392 | 5503392 | 20241107220415_cuXDr | SK0004 | 2024-11-09T14:12:58.588Z | 2024-11-16T14:28:06.947Z |
5503167 | 5503167 | 20241107205607_40jx2 | SK0004 | 2024-11-09T14:12:30.583Z | 2024-11-16T14:28:03.910Z |
5503042 | 5503042 | 20241107203131_JDRxm | SK0004 | 2024-11-09T14:12:21.278Z | 2024-11-16T14:28:02.108Z |
5502262 | 5502262 | 20241107175118_KaeY3 | SK0004 | 2024-11-09T14:11:06.518Z | 2024-11-16T14:27:52.555Z |
5497643 | 5497643 | 20241107041652_zMwIi | SK0004 | 2024-11-08T14:14:07.407Z | 2024-11-15T14:25:05.267Z |
5497545 | 5497545 | 20241107035809_SLPd7 | SK0004 | 2024-11-08T14:13:57.481Z | 2024-11-15T14:25:04.618Z |
5497476 | 5497476 | 20241107034752_bprPC | SK0004 | 2024-11-08T14:13:50.991Z | 2024-11-15T14:25:04.245Z |
5497383 | 5497383 | 20241107033121_cPrtY | SK0004 | 2024-11-08T14:13:39.911Z | 2024-11-15T14:25:03.483Z |
5497086 | 5497086 | 20241107023956_Q3436 | SK0004 | 2024-11-08T14:13:09.272Z | 2024-11-15T14:25:01.685Z |
5496987 | 5496987 | 20241107022340_EqZSY | SK0004 | 2024-11-08T14:13:02.179Z | 2024-11-15T14:25:01.112Z |
5496932 | 5496932 | 20241107021151_xjMGv | SK0004 | 2024-11-08T14:12:59.571Z | 2024-11-15T14:25:01.016Z |
5496864 | 5496864 | 20241107020126_Y5xr1 | SK0004 | 2024-11-08T14:12:55.823Z | 2024-11-15T14:25:00.628Z |
5496857 | 5496857 | 20241107015854_Q1yIA | SK0004 | 2024-11-08T14:12:55.347Z | 2024-11-15T14:25:00.605Z |
5496820 | 5496820 | 20241107014801_UtMpL | SK0004 | 2024-11-08T14:12:53.505Z | 2024-11-15T14:25:00.262Z |
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);