participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,177 rows where station_code = "USL00Z" 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 |
---|---|---|---|---|---|
5083041 | 5083041 | 20240911115058_VR66c | USL00Z | 2024-09-15T12:18:34.298Z | 2024-09-19T12:21:49.162Z |
5082701 | 5082701 | 20240911104610_GOBnm | USL00Z | 2024-09-15T12:18:22.825Z | 2024-09-19T12:21:48.346Z |
5082666 | 5082666 | 20240911104258_vMOh1 | USL00Z | 2024-09-15T12:18:22.008Z | 2024-09-19T12:21:48.329Z |
5082409 | 5082409 | 20240911100524_XQZkS | USL00Z | 2024-09-15T12:18:14.310Z | 2024-09-19T12:21:47.950Z |
5082096 | 5082096 | 20240911092117_47cSy | USL00Z | 2024-09-15T12:18:02.972Z | 2024-09-19T12:21:47.179Z |
5081665 | 5081665 | 20240911081919_PfcwQ | USL00Z | 2024-09-15T12:17:40.357Z | 2024-09-19T12:21:45.988Z |
5081002 | 5081002 | 20240911055828_0VEqV | USL00Z | 2024-09-15T12:17:20.260Z | 2024-09-19T12:21:44.349Z |
5068713 | 5068713 | 20240910120814_T6Gv2 | USL00Z | 2024-09-14T12:19:20.626Z | 2024-09-18T12:15:26.531Z |
5068492 | 5068492 | 20240910114200_htKo0 | USL00Z | 2024-09-14T12:19:16.620Z | 2024-09-18T12:15:26.222Z |
5067853 | 5067853 | 20240910102029_MyQjK | USL00Z | 2024-09-14T12:19:00.657Z | 2024-09-18T12:15:24.976Z |
5066312 | 5066312 | 20240910071052_RL2qV | USL00Z | 2024-09-14T12:17:49.723Z | 2024-09-18T12:15:21.588Z |
5056963 | 5056963 | 20240908114637_JvNYM | USL00Z | 2024-09-13T12:17:41.939Z | 2024-09-16T12:21:27.999Z |
5056671 | 5056671 | 20240908110441_aIeDx | USL00Z | 2024-09-13T12:17:36.986Z | 2024-09-16T12:21:26.504Z |
5056155 | 5056155 | 20240908094748_zMwOM | USL00Z | 2024-09-13T12:17:28.014Z | 2024-09-16T12:21:23.598Z |
5055428 | 5055428 | 20240908080212_3huN3 | USL00Z | 2024-09-13T12:17:12.615Z | 2024-09-16T12:21:19.635Z |
5049830 | 5049830 | 20240909114753_kO1ib | USL00Z | 2024-09-13T12:12:28.165Z | 2024-09-17T12:19:11.596Z |
5049726 | 5049726 | 20240909113143_KmWuX | USL00Z | 2024-09-13T12:12:24.212Z | 2024-09-17T12:19:11.315Z |
5048950 | 5048950 | 20240909093833_ZjIh3 | USL00Z | 2024-09-13T12:11:24.384Z | 2024-09-17T12:19:08.714Z |
5048153 | 5048153 | 20240909071232_n1SlQ | USL00Z | 2024-09-13T12:10:18.136Z | 2024-09-17T12:19:05.958Z |
5047931 | 5047931 | 20240909063225_hE5zo | USL00Z | 2024-09-13T12:10:01.024Z | 2024-09-17T12:19:05.013Z |
5047885 | 5047885 | 20240909061827_rgYIb | USL00Z | 2024-09-13T12:09:54.635Z | 2024-09-17T12:19:04.851Z |
5047845 | 5047845 | 20240909060902_DUJTw | USL00Z | 2024-09-13T12:09:47.891Z | 2024-09-17T12:19:04.651Z |
5047744 | 5047744 | 20240909054413_l333G | USL00Z | 2024-09-13T12:09:37.766Z | 2024-09-17T12:19:04.149Z |
5042514 | 5042514 | 20240907115229_uY6iA | USL00Z | 2024-09-12T12:17:13.861Z | 2024-09-16T12:20:53.429Z |
5042429 | 5042429 | 20240907113716_IU1E0 | USL00Z | 2024-09-12T12:17:10.998Z | 2024-09-16T12:20:52.764Z |
5042146 | 5042146 | 20240906100256_dh37y | USL00Z | 2024-09-12T12:16:56.169Z | 2024-09-14T12:23:16.167Z |
5041673 | 5041673 | 20240906084958_1lbCz | USL00Z | 2024-09-12T12:16:46.772Z | 2024-09-14T12:23:14.328Z |
5041101 | 5041101 | 20240906072055_9GZ01 | USL00Z | 2024-09-12T12:16:33.894Z | 2024-09-14T12:23:11.780Z |
5040925 | 5040925 | 20240906062843_8cdqP | USL00Z | 2024-09-12T12:16:28.426Z | 2024-09-14T12:23:11.014Z |
5035624 | 5035624 | 20240907095555_LM5Y3 | USL00Z | 2024-09-12T12:12:16.777Z | 2024-09-15T12:21:40.337Z |
5035337 | 5035337 | 20240907092006_39lWi | USL00Z | 2024-09-12T12:12:00.895Z | 2024-09-15T12:21:39.362Z |
5035172 | 5035172 | 20240907085422_VJjWT | USL00Z | 2024-09-12T12:11:55.544Z | 2024-09-15T12:21:38.702Z |
5034716 | 5034716 | 20240907074842_CoGz7 | USL00Z | 2024-09-12T12:11:15.463Z | 2024-09-15T12:21:35.786Z |
5029805 | 5029805 | 20240906113006_T9fHl | USL00Z | 2024-09-12T12:00:33.276Z | 2024-09-15T12:21:17.288Z |
5013157 | 5013157 | 20240903082753_1Gk1p | USL00Z | 2024-09-09T12:18:28.873Z | 2024-09-11T12:21:20.077Z |
5012670 | 5012670 | 20240903071704_0miyb | USL00Z | 2024-09-09T12:18:01.621Z | 2024-09-11T12:21:18.504Z |
5012039 | 5012039 | 20240904083157_LQBO8 | USL00Z | 2024-09-09T12:10:18.965Z | 2024-09-12T12:19:34.574Z |
5004661 | 5004661 | 20240903120352_8SHdR | USL00Z | 2024-09-09T12:02:53.510Z | 2024-09-12T12:19:03.442Z |
5004647 | 5004647 | 20240903115940_RIskz | USL00Z | 2024-09-09T12:02:52.631Z | 2024-09-12T12:19:03.376Z |
5003917 | 5003917 | 20240903101344_ckwBf | USL00Z | 2024-09-09T12:02:12.389Z | 2024-09-12T12:19:00.168Z |
5003905 | 5003905 | 20240903101219_Gs564 | USL00Z | 2024-09-09T12:02:11.767Z | 2024-09-12T12:19:00.116Z |
5002350 | 5002350 | 20240904093712_03A2d | USL00Z | 2024-09-09T12:00:29.508Z | 2024-09-13T12:19:40.567Z |
4993345 | 4993345 | 20240902102047_IQHI7 | USL00Z | 2024-09-08T12:01:28.140Z | 2024-09-11T12:20:22.040Z |
4993151 | 4993151 | 20240902095729_8qIRb | USL00Z | 2024-09-08T12:01:14.274Z | 2024-09-11T12:20:20.618Z |
4992151 | 4992151 | 20240901055913_npq33 | USL00Z | 2024-09-07T12:12:57.289Z | 2024-09-09T12:27:50.226Z |
4991999 | 4991999 | 20240901044909_ApZsF | USL00Z | 2024-09-07T12:12:46.746Z | 2024-09-09T12:27:38.951Z |
4985197 | 4985197 | 20240901114233_042Vf | USL00Z | 2024-09-07T12:02:58.942Z | 2024-09-10T12:19:07.264Z |
4913798 | 4913798 | 20240809103245_x2XoT | USL00Z | 2024-08-29T12:17:07.296Z | 2024-08-30T12:23:07.959Z |
4905653 | 4905653 | 20240809111128_1WmWg | USL00Z | 2024-08-29T12:00:45.211Z | 2024-09-02T12:16:56.015Z |
4905602 | 4905602 | 20240809110601_gYoIf | USL00Z | 2024-08-29T12:00:40.221Z | 2024-09-02T12:16:52.760Z |
4893458 | 4893458 | 20240809093825_KCnUb | USL00Z | 2024-08-28T12:11:28.530Z | 2024-08-30T12:22:58.233Z |
4868780 | 4868780 | 20240806071126_3MAls | USL00Z | 2024-08-18T12:24:29.885Z | 2024-08-19T12:29:00.803Z |
4868757 | 4868757 | 20240806070913_25eIM | USL00Z | 2024-08-18T12:24:28.547Z | 2024-08-19T12:28:59.841Z |
4861065 | 4861065 | 20240806111738_ghrfv | USL00Z | 2024-08-18T12:03:20.345Z | 2024-08-27T12:03:18.378Z |
4860179 | 4860179 | 20240806102228_k4XYz | USL00Z | 2024-08-18T12:02:33.350Z | 2024-08-27T12:02:33.558Z |
4859842 | 4859842 | 20240806100441_2PDDN | USL00Z | 2024-08-18T12:02:16.229Z | 2024-08-27T12:02:18.569Z |
4859206 | 4859206 | 20240806092108_Or9xU | USL00Z | 2024-08-18T12:01:37.366Z | 2024-08-27T12:01:44.455Z |
4858958 | 4858958 | 20240806090558_skc9e | USL00Z | 2024-08-18T12:01:23.377Z | 2024-08-27T12:01:31.728Z |
4858478 | 4858478 | 20240806083053_92O2U | USL00Z | 2024-08-18T12:00:55.209Z | 2024-08-27T12:01:03.145Z |
4840199 | 4840199 | 20240805111411_BvQZx | USL00Z | 2024-08-16T12:04:17.338Z | 2024-08-19T12:17:00.670Z |
4839826 | 4839826 | 20240805104721_Z38IU | USL00Z | 2024-08-16T12:03:54.268Z | 2024-08-19T12:16:52.495Z |
4839754 | 4839754 | 20240805104203_yIwus | USL00Z | 2024-08-16T12:03:49.125Z | 2024-08-19T12:16:50.801Z |
4839498 | 4839498 | 20240805102722_YOVs9 | USL00Z | 2024-08-16T12:03:32.435Z | 2024-08-19T12:16:44.966Z |
4839189 | 4839189 | 20240805095912_SkAGk | USL00Z | 2024-08-16T12:03:11.587Z | 2024-08-19T12:16:27.550Z |
4839029 | 4839029 | 20240805094554_pqUHg | USL00Z | 2024-08-16T12:03:01.793Z | 2024-08-19T12:16:18.453Z |
4818023 | 4818023 | 20240804081946_szMix | USL00Z | 2024-08-14T12:01:48.590Z | 2024-08-17T12:24:09.243Z |
4809046 | 4809046 | 20240803113659_9vd7Q | USL00Z | 2024-08-13T12:06:33.038Z | 2024-08-15T12:19:29.173Z |
4808142 | 4808142 | 20240803104614_l1hX1 | USL00Z | 2024-08-13T12:04:55.272Z | 2024-08-15T12:18:55.744Z |
4787425 | 4787425 | 20240802064038_ovm8C | USL00Z | 2024-08-11T12:02:01.688Z | 2024-08-13T12:15:31.051Z |
4773942 | 4773942 | 20240801104933_6zVyB | USL00Z | 2024-08-07T12:06:43.971Z | 2024-08-11T12:12:10.904Z |
4773563 | 4773563 | 20240801100600_wrX6n | USL00Z | 2024-08-07T12:06:05.632Z | 2024-08-11T12:12:00.862Z |
4773219 | 4773219 | 20240801092835_kNX3e | USL00Z | 2024-08-07T12:05:28.822Z | 2024-08-11T12:11:53.428Z |
4772848 | 4772848 | 20240801083717_zbSzV | USL00Z | 2024-08-07T12:04:44.430Z | 2024-08-11T12:11:40.949Z |
4581184 | 4581184 | 20240706102917_JutYK | USL00Z | 2024-07-09T12:05:02.117Z | 2024-07-14T12:14:04.745Z |
4485208 | 4485208 | 20240620072024_qmIV2 | USL00Z | 2024-06-21T12:00:22.307Z | 2024-06-29T12:13:18.909Z |
4485162 | 4485162 | 20240620064229_T87o4 | USL00Z | 2024-06-21T12:00:17.111Z | 2024-06-29T12:13:18.435Z |
4485160 | 4485160 | 20240620063733_LlQ7x | USL00Z | 2024-06-21T12:00:16.775Z | 2024-06-29T12:13:18.419Z |
4481569 | 4481569 | 20240618091352_pedtf | USL00Z | 2024-06-20T12:01:03.288Z | 2024-06-27T12:11:09.034Z |
4481309 | 4481309 | 20240618074835_3WwBM | USL00Z | 2024-06-20T12:00:43.934Z | 2024-06-27T12:11:05.398Z |
4481268 | 4481268 | 20240618071947_rRzGL | USL00Z | 2024-06-20T12:00:38.203Z | 2024-06-27T12:11:04.558Z |
4473077 | 4473077 | 20240616102948_uTKCj | USL00Z | 2024-06-18T12:03:20.706Z | 2024-06-24T12:11:18.909Z |
4472903 | 4472903 | 20240616094635_bmAmM | USL00Z | 2024-06-18T12:03:06.608Z | 2024-06-24T12:11:14.926Z |
4472514 | 4472514 | 20240616074934_AXm65 | USL00Z | 2024-06-18T12:02:22.122Z | 2024-06-24T12:11:09.220Z |
4465628 | 4465628 | 20240615105110_YJY23 | USL00Z | 2024-06-16T12:04:44.186Z | 2024-06-23T12:12:12.154Z |
4465469 | 4465469 | 20240615100829_urkIk | USL00Z | 2024-06-16T12:04:32.790Z | 2024-06-23T12:12:09.978Z |
4465463 | 4465463 | 20240615100605_f4au0 | USL00Z | 2024-06-16T12:04:32.167Z | 2024-06-23T12:12:09.860Z |
4465064 | 4465064 | 20240615081842_Gorja | USL00Z | 2024-06-16T12:03:45.512Z | 2024-06-23T12:12:01.068Z |
4457696 | 4457696 | 20240613092525_8fAB9 | USL00Z | 2024-06-14T12:03:20.548Z | 2024-06-21T12:11:41.820Z |
4450678 | 4450678 | 20240612100410_sJ2Bz | USL00Z | 2024-06-13T12:03:00.501Z | 2024-06-20T12:12:01.146Z |
4450435 | 4450435 | 20240612084822_Ff2Hv | USL00Z | 2024-06-13T12:02:43.831Z | 2024-06-20T12:11:59.031Z |
4443336 | 4443336 | 20240610110008_YiAdN | USL00Z | 2024-06-11T12:03:27.720Z | 2024-06-18T12:11:12.174Z |
4430103 | 4430103 | 20240606093318_ifBhB | USL00Z | 2024-06-08T12:09:56.696Z | 2024-06-14T12:08:29.451Z |
4429932 | 4429932 | 20240606085253_d7VJ2 | USL00Z | 2024-06-08T12:09:48.807Z | 2024-06-14T12:08:28.860Z |
4429674 | 4429674 | 20240606071720_2MS30 | USL00Z | 2024-06-08T12:09:31.960Z | 2024-06-14T12:08:27.545Z |
4423747 | 4423747 | 20240605092522_PjPNM | USL00Z | 2024-06-07T12:11:41.536Z | 2024-06-13T12:08:36.952Z |
4423256 | 4423256 | 20240605074252_219a1 | USL00Z | 2024-06-07T12:11:09.994Z | 2024-06-13T12:08:36.128Z |
4422880 | 4422880 | 20240605054924_mtC7l | USL00Z | 2024-06-07T12:10:34.874Z | 2024-06-13T12:08:35.196Z |
4411830 | 4411830 | 20240603075418_y4VMM | USL00Z | 2024-06-05T12:09:50.683Z | 2024-06-11T12:13:44.439Z |
4411502 | 4411502 | 20240603054753_AMPJX | USL00Z | 2024-06-05T12:09:15.709Z | 2024-06-11T12:13:41.765Z |
4407997 | 4407997 | 20240603104040_4R8gI | USL00Z | 2024-06-05T12:00:27.513Z | 2024-06-12T12:10:30.387Z |
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);