participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000U" 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 |
---|---|---|---|---|---|
5565224 | 5565224 | 20241120040538_WIYzn | US000U | 2024-11-21T14:18:42.789Z | 2024-11-21T14:18:54.177Z |
5563846 | 5563846 | 20241120021019_KcLV2 | US000U | 2024-11-21T14:16:49.771Z | 2024-11-21T14:18:53.929Z |
5563795 | 5563795 | 20241120020437_yUFAA | US000U | 2024-11-21T14:16:44.188Z | 2024-11-21T14:18:53.919Z |
5560529 | 5560529 | 20241120130751_1OH2R | US000U | 2024-11-21T14:09:02.599Z | 2024-11-21T14:09:02.599Z |
5560445 | 5560445 | 20241120125257_fzNn2 | US000U | 2024-11-21T14:08:52.973Z | 2024-11-21T14:08:52.973Z |
5560441 | 5560441 | 20241120125210_q223g | US000U | 2024-11-21T14:08:52.193Z | 2024-11-21T14:08:52.193Z |
5560267 | 5560267 | 20241120122904_GPk3l | US000U | 2024-11-21T14:08:27.120Z | 2024-11-21T14:08:27.120Z |
5560257 | 5560257 | 20241120122645_boJ5b | US000U | 2024-11-21T14:08:25.657Z | 2024-11-21T14:08:25.657Z |
5560223 | 5560223 | 20241120122019_c2ndL | US000U | 2024-11-21T14:08:19.265Z | 2024-11-21T14:08:19.265Z |
5560173 | 5560173 | 20241120121338_selLI | US000U | 2024-11-21T14:08:11.538Z | 2024-11-21T14:08:11.538Z |
5560158 | 5560158 | 20241120120910_GkZZu | US000U | 2024-11-21T14:08:09.232Z | 2024-11-21T14:08:09.232Z |
5560153 | 5560153 | 20241120120808_VM8WJ | US000U | 2024-11-21T14:08:08.248Z | 2024-11-21T14:08:08.248Z |
5560061 | 5560061 | 20241120115308_Wod0O | US000U | 2024-11-21T14:07:57.747Z | 2024-11-21T14:07:57.747Z |
5560027 | 5560027 | 20241120114806_I5IQh | US000U | 2024-11-21T14:07:53.766Z | 2024-11-21T14:07:53.766Z |
5559532 | 5559532 | 20241120103912_WMdPD | US000U | 2024-11-21T14:06:32.656Z | 2024-11-21T14:06:32.656Z |
5559473 | 5559473 | 20241120102826_4rhwu | US000U | 2024-11-21T14:06:24.624Z | 2024-11-21T14:06:24.624Z |
5559295 | 5559295 | 20241120095736_0NUSb | US000U | 2024-11-21T14:05:52.941Z | 2024-11-21T14:05:52.941Z |
5559287 | 5559287 | 20241120095601_ji3YY | US000U | 2024-11-21T14:05:51.494Z | 2024-11-21T14:05:51.494Z |
5559094 | 5559094 | 20241120092303_FneN9 | US000U | 2024-11-21T14:05:20.729Z | 2024-11-21T14:05:20.729Z |
5559015 | 5559015 | 20241120090527_BNupF | US000U | 2024-11-21T14:05:03.196Z | 2024-11-21T14:05:03.196Z |
5559009 | 5559009 | 20241120090453_ZcLk9 | US000U | 2024-11-21T14:05:02.393Z | 2024-11-21T14:05:02.393Z |
5558934 | 5558934 | 20241120085237_5ZH0N | US000U | 2024-11-21T14:04:50.750Z | 2024-11-21T14:04:50.750Z |
5558910 | 5558910 | 20241120084728_CtR7W | US000U | 2024-11-21T14:04:47.428Z | 2024-11-21T14:04:47.428Z |
5558703 | 5558703 | 20241120074123_kpYdz | US000U | 2024-11-21T14:04:06.901Z | 2024-11-21T14:04:06.901Z |
5558652 | 5558652 | 20241120071724_y7lq9 | US000U | 2024-11-21T14:03:56.994Z | 2024-11-21T14:03:56.994Z |
5558629 | 5558629 | 20241120071137_FYU8C | US000U | 2024-11-21T14:03:53.263Z | 2024-11-21T14:03:53.263Z |
5558587 | 5558587 | 20241120064653_utnB7 | US000U | 2024-11-21T14:03:45.723Z | 2024-11-21T14:03:45.723Z |
5558531 | 5558531 | 20241120062527_dnbO4 | US000U | 2024-11-21T14:03:32.473Z | 2024-11-21T14:03:32.473Z |
5558353 | 5558353 | 20241120055843_0QCLY | US000U | 2024-11-21T14:03:05.975Z | 2024-11-21T14:03:05.975Z |
5557977 | 5557977 | 20241120052800_hEtOa | US000U | 2024-11-21T14:02:11.799Z | 2024-11-21T14:02:11.799Z |
5557049 | 5557049 | 20241119033224_Jk06m | US000U | 2024-11-20T14:12:04.717Z | 2024-11-21T14:20:44.709Z |
5556852 | 5556852 | 20241119021836_aWYcQ | US000U | 2024-11-20T14:11:34.293Z | 2024-11-21T14:20:37.242Z |
5556754 | 5556754 | 20241119014354_XQAKj | US000U | 2024-11-20T14:11:25.612Z | 2024-11-21T14:20:34.251Z |
5555335 | 5555335 | 20241119124834_3uP8n | US000U | 2024-11-20T14:05:13.430Z | 2024-11-21T14:18:53.255Z |
5555266 | 5555266 | 20241119122646_bXKnF | US000U | 2024-11-20T14:05:03.221Z | 2024-11-21T14:18:53.239Z |
5555259 | 5555259 | 20241119122523_vzPM3 | US000U | 2024-11-20T14:05:01.957Z | 2024-11-21T14:18:53.237Z |
5555241 | 5555241 | 20241119122203_Rx0eN | US000U | 2024-11-20T14:05:00.315Z | 2024-11-21T14:18:53.234Z |
5555230 | 5555230 | 20241119122030_dTTp2 | US000U | 2024-11-20T14:04:54.760Z | 2024-11-21T14:18:53.232Z |
5555210 | 5555210 | 20241119121620_RVhSx | US000U | 2024-11-20T14:04:48.228Z | 2024-11-21T14:18:53.228Z |
5555153 | 5555153 | 20241119115645_wvupJ | US000U | 2024-11-20T14:04:34.450Z | 2024-11-21T14:18:53.213Z |
5555059 | 5555059 | 20241119112836_M3hv0 | US000U | 2024-11-20T14:04:21.251Z | 2024-11-21T14:18:53.193Z |
5554960 | 5554960 | 20241119111154_w5ak2 | US000U | 2024-11-20T14:03:56.722Z | 2024-11-21T14:18:53.173Z |
5554888 | 5554888 | 20241119105554_tIkBJ | US000U | 2024-11-20T14:03:44.205Z | 2024-11-21T14:18:53.157Z |
5554860 | 5554860 | 20241119105046_TJX2R | US000U | 2024-11-20T14:03:39.142Z | 2024-11-21T14:18:53.150Z |
5554763 | 5554763 | 20241119103014_27sI3 | US000U | 2024-11-20T14:03:13.014Z | 2024-11-21T14:18:53.127Z |
5554735 | 5554735 | 20241119102007_vChC7 | US000U | 2024-11-20T14:03:09.827Z | 2024-11-21T14:18:53.122Z |
5554730 | 5554730 | 20241119101956_FBiaI | US000U | 2024-11-20T14:03:08.866Z | 2024-11-21T14:18:53.121Z |
5554719 | 5554719 | 20241119101643_bLj4n | US000U | 2024-11-20T14:03:07.157Z | 2024-11-21T14:18:53.118Z |
5554683 | 5554683 | 20241119100414_9YZoq | US000U | 2024-11-20T14:03:00.240Z | 2024-11-21T14:18:53.109Z |
5554662 | 5554662 | 20241119100207_2HqqY | US000U | 2024-11-20T14:02:58.284Z | 2024-11-21T14:18:53.106Z |
5554617 | 5554617 | 20241119094922_fQz7N | US000U | 2024-11-20T14:02:43.566Z | 2024-11-21T14:18:53.096Z |
5554587 | 5554587 | 20241119094243_HySlS | US000U | 2024-11-20T14:02:33.267Z | 2024-11-21T14:18:53.088Z |
5554546 | 5554546 | 20241119093218_wH9Kw | US000U | 2024-11-20T14:02:25.247Z | 2024-11-21T14:18:53.078Z |
5554392 | 5554392 | 20241119084230_S2RdH | US000U | 2024-11-20T14:01:52.477Z | 2024-11-21T14:18:53.046Z |
5554379 | 5554379 | 20241119083756_KU49f | US000U | 2024-11-20T14:01:49.295Z | 2024-11-21T14:18:53.042Z |
5554335 | 5554335 | 20241119081948_LzLq7 | US000U | 2024-11-20T14:01:42.233Z | 2024-11-21T14:18:53.031Z |
5554329 | 5554329 | 20241119081714_klnuP | US000U | 2024-11-20T14:01:40.681Z | 2024-11-21T14:18:53.029Z |
5554310 | 5554310 | 20241119080131_ddiNW | US000U | 2024-11-20T14:01:33.491Z | 2024-11-21T14:18:53.025Z |
5551347 | 5551347 | 20241118131026_IqOJc | US000U | 2024-11-19T14:04:32.543Z | 2024-11-21T14:19:49.343Z |
5551257 | 5551257 | 20241118125039_sMdgQ | US000U | 2024-11-19T14:04:11.136Z | 2024-11-21T14:19:46.856Z |
5551211 | 5551211 | 20241118124530_a3k3H | US000U | 2024-11-19T14:04:07.119Z | 2024-11-21T14:19:45.874Z |
5551122 | 5551122 | 20241118122947_uejMd | US000U | 2024-11-19T14:03:56.847Z | 2024-11-21T14:19:44.038Z |
5551119 | 5551119 | 20241118122856_4gcyI | US000U | 2024-11-19T14:03:56.638Z | 2024-11-21T14:19:43.903Z |
5551015 | 5551015 | 20241118120914_i2H4u | US000U | 2024-11-19T14:03:46.779Z | 2024-11-21T14:19:41.270Z |
5550749 | 5550749 | 20241118112053_xsKYq | US000U | 2024-11-19T14:03:01.621Z | 2024-11-21T14:19:29.566Z |
5550612 | 5550612 | 20241118105710_wW22D | US000U | 2024-11-19T14:02:49.019Z | 2024-11-21T14:19:25.878Z |
5550529 | 5550529 | 20241118104240_Cf0Y4 | US000U | 2024-11-19T14:02:31.238Z | 2024-11-21T14:19:23.381Z |
5548914 | 5548914 | 20241117021433_16Frn | US000U | 2024-11-18T14:10:26.093Z | 2024-11-21T14:23:06.113Z |
5546760 | 5546760 | 20241117123807_0M4iR | US000U | 2024-11-18T14:04:11.542Z | 2024-11-21T14:21:26.714Z |
5546751 | 5546751 | 20241117123547_A9g7r | US000U | 2024-11-18T14:04:09.910Z | 2024-11-21T14:21:26.381Z |
5546688 | 5546688 | 20241117121433_QSByv | US000U | 2024-11-18T14:03:51.205Z | 2024-11-21T14:21:24.235Z |
5546623 | 5546623 | 20241117115901_2WSdS | US000U | 2024-11-18T14:03:40.786Z | 2024-11-21T14:21:21.591Z |
5546618 | 5546618 | 20241117115819_XKBJ8 | US000U | 2024-11-18T14:03:40.000Z | 2024-11-21T14:21:21.436Z |
5546579 | 5546579 | 20241117114642_sm3Do | US000U | 2024-11-18T14:03:33.664Z | 2024-11-21T14:21:20.610Z |
5546557 | 5546557 | 20241117113553_ge0dJ | US000U | 2024-11-18T14:03:29.793Z | 2024-11-21T14:21:19.996Z |
5546536 | 5546536 | 20241117112827_qH0PP | US000U | 2024-11-18T14:03:23.050Z | 2024-11-21T14:21:19.685Z |
5546523 | 5546523 | 20241117112525_zgZDG | US000U | 2024-11-18T14:03:19.468Z | 2024-11-21T14:21:19.526Z |
5546439 | 5546439 | 20241117105747_28rOF | US000U | 2024-11-18T14:03:06.957Z | 2024-11-21T14:21:18.511Z |
5546430 | 5546430 | 20241117105534_nCLlV | US000U | 2024-11-18T14:03:06.171Z | 2024-11-21T14:21:18.409Z |
5546374 | 5546374 | 20241117103724_W50yL | US000U | 2024-11-18T14:02:57.519Z | 2024-11-21T14:21:17.428Z |
5546208 | 5546208 | 20241117094749_F8JiE | US000U | 2024-11-18T14:02:27.585Z | 2024-11-21T14:21:13.724Z |
5546176 | 5546176 | 20241117093624_JjR3I | US000U | 2024-11-18T14:02:23.467Z | 2024-11-21T14:21:13.124Z |
5546163 | 5546163 | 20241117093454_LexmD | US000U | 2024-11-18T14:02:21.226Z | 2024-11-21T14:21:12.776Z |
5546135 | 5546135 | 20241117092409_6y3XR | US000U | 2024-11-18T14:02:15.658Z | 2024-11-21T14:21:11.205Z |
5546088 | 5546088 | 20241117090725_0ds8j | US000U | 2024-11-18T14:01:59.392Z | 2024-11-21T14:21:10.183Z |
5546059 | 5546059 | 20241117090147_pPMWs | US000U | 2024-11-18T14:01:52.543Z | 2024-11-21T14:21:09.604Z |
5545906 | 5545906 | 20241117074535_PI1sT | US000U | 2024-11-18T14:01:22.999Z | 2024-11-21T14:21:04.770Z |
5545527 | 5545527 | 20241117051010_eoxrd | US000U | 2024-11-18T14:00:11.424Z | 2024-11-21T14:20:53.159Z |
5542830 | 5542830 | 20241115130737_ArjL6 | US000U | 2024-11-16T14:02:42.478Z | 2024-11-21T14:23:35.433Z |
5542811 | 5542811 | 20241115124432_xHieW | US000U | 2024-11-16T14:02:40.076Z | 2024-11-21T14:23:35.222Z |
5542773 | 5542773 | 20241115122536_3XADw | US000U | 2024-11-16T14:02:31.624Z | 2024-11-21T14:23:34.798Z |
5542760 | 5542760 | 20241115122054_aqzpR | US000U | 2024-11-16T14:02:28.040Z | 2024-11-21T14:23:34.650Z |
5542754 | 5542754 | 20241115122013_F8zys | US000U | 2024-11-16T14:02:26.007Z | 2024-11-21T14:23:34.562Z |
5542725 | 5542725 | 20241115121136_F3psj | US000U | 2024-11-16T14:02:17.902Z | 2024-11-21T14:23:34.003Z |
5542703 | 5542703 | 20241115115742_5NejS | US000U | 2024-11-16T14:02:13.908Z | 2024-11-21T14:23:33.394Z |
5542686 | 5542686 | 20241115114924_A7IOH | US000U | 2024-11-16T14:02:11.645Z | 2024-11-21T14:23:33.270Z |
5542671 | 5542671 | 20241115114432_K2I7j | US000U | 2024-11-16T14:02:10.026Z | 2024-11-21T14:23:33.092Z |
5542658 | 5542658 | 20241115113805_yYzS8 | US000U | 2024-11-16T14:02:08.374Z | 2024-11-21T14:23:32.878Z |
5542636 | 5542636 | 20241115112535_ao2FI | US000U | 2024-11-16T14:02:05.145Z | 2024-11-21T14:23:31.543Z |
5542607 | 5542607 | 20241115111107_AAo5J | US000U | 2024-11-16T14:01:55.313Z | 2024-11-21T14:23:30.766Z |
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);