participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
558 rows where station_code = "US001U" 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 |
---|---|---|---|---|---|
5137439 | 5137439 | 20240919102243_suLnO | US001U | 2024-09-20T12:04:42.075Z | 2024-09-20T12:06:55.169Z |
5137417 | 5137417 | 20240919101627_te1vO | US001U | 2024-09-20T12:04:39.755Z | 2024-09-20T12:06:55.162Z |
5137234 | 5137234 | 20240919090525_2adpu | US001U | 2024-09-20T12:04:15.284Z | 2024-09-20T12:06:55.106Z |
5136858 | 5136858 | 20240919050815_TaOr8 | US001U | 2024-09-20T12:03:20.400Z | 2024-09-20T12:06:54.994Z |
5134653 | 5134653 | 20240916110637_Ns7Du | US001U | 2024-09-19T12:18:01.153Z | 2024-09-20T12:14:28.905Z |
5130321 | 5130321 | 20240917111835_Tx43J | US001U | 2024-09-19T12:12:59.853Z | 2024-09-20T12:11:57.526Z |
5130319 | 5130319 | 20240917111519_ImW62 | US001U | 2024-09-19T12:12:59.417Z | 2024-09-20T12:11:57.443Z |
5130283 | 5130283 | 20240917110331_oQF0K | US001U | 2024-09-19T12:12:55.893Z | 2024-09-20T12:11:56.567Z |
5130267 | 5130267 | 20240917105349_ggY3x | US001U | 2024-09-19T12:12:53.966Z | 2024-09-20T12:11:56.007Z |
5130233 | 5130233 | 20240917103443_EnaZb | US001U | 2024-09-19T12:12:48.686Z | 2024-09-20T12:11:53.764Z |
5130153 | 5130153 | 20240917094444_q4FqJ | US001U | 2024-09-19T12:12:41.060Z | 2024-09-20T12:11:50.540Z |
5130143 | 5130143 | 20240917093322_ixPC8 | US001U | 2024-09-19T12:12:39.836Z | 2024-09-20T12:11:49.921Z |
5123760 | 5123760 | 20240914112405_vo2lX | US001U | 2024-09-18T12:11:56.616Z | 2024-09-20T12:19:34.174Z |
5123706 | 5123706 | 20240914111224_TAfVs | US001U | 2024-09-18T12:11:54.628Z | 2024-09-20T12:19:33.382Z |
5123626 | 5123626 | 20240914105044_iydSa | US001U | 2024-09-18T12:11:52.700Z | 2024-09-20T12:19:31.536Z |
5123565 | 5123565 | 20240914103530_dKr4a | US001U | 2024-09-18T12:11:51.414Z | 2024-09-20T12:19:30.178Z |
5123409 | 5123409 | 20240914100016_NL7x1 | US001U | 2024-09-18T12:11:48.100Z | 2024-09-20T12:19:26.171Z |
5122825 | 5122825 | 20240914080506_L4lUE | US001U | 2024-09-18T12:11:31.976Z | 2024-09-20T12:19:16.419Z |
5122754 | 5122754 | 20240914075207_d5OVz | US001U | 2024-09-18T12:11:30.363Z | 2024-09-20T12:19:15.092Z |
5122673 | 5122673 | 20240914073036_qvAjM | US001U | 2024-09-18T12:11:28.001Z | 2024-09-20T12:19:13.563Z |
5122580 | 5122580 | 20240914071527_QcA5Z | US001U | 2024-09-18T12:11:24.174Z | 2024-09-20T12:19:13.000Z |
5122504 | 5122504 | 20240914065407_Rax8d | US001U | 2024-09-18T12:11:21.075Z | 2024-09-20T12:19:12.446Z |
5122162 | 5122162 | 20240914044252_YnexH | US001U | 2024-09-18T12:11:07.909Z | 2024-09-20T12:19:09.968Z |
5118606 | 5118606 | 20240915102725_PSE23 | US001U | 2024-09-18T12:08:52.921Z | 2024-09-20T12:17:34.998Z |
5118491 | 5118491 | 20240915100015_cZgxA | US001U | 2024-09-18T12:08:47.970Z | 2024-09-20T12:17:32.243Z |
5118448 | 5118448 | 20240915094859_eIDiE | US001U | 2024-09-18T12:08:44.793Z | 2024-09-20T12:17:30.999Z |
5118348 | 5118348 | 20240915092652_zubsK | US001U | 2024-09-18T12:08:38.844Z | 2024-09-20T12:17:28.475Z |
5118339 | 5118339 | 20240915092532_ElD3o | US001U | 2024-09-18T12:08:38.099Z | 2024-09-20T12:17:28.241Z |
5118319 | 5118319 | 20240915091927_qRlAw | US001U | 2024-09-18T12:08:37.484Z | 2024-09-20T12:17:27.931Z |
5118270 | 5118270 | 20240915090313_DsGFj | US001U | 2024-09-18T12:08:34.730Z | 2024-09-20T12:17:25.905Z |
5118190 | 5118190 | 20240915084841_JW4ai | US001U | 2024-09-18T12:08:29.283Z | 2024-09-20T12:17:24.304Z |
5118126 | 5118126 | 20240915083747_jjoPK | US001U | 2024-09-18T12:08:25.902Z | 2024-09-20T12:17:22.514Z |
5117634 | 5117634 | 20240915055620_2QMfD | US001U | 2024-09-18T12:07:50.243Z | 2024-09-20T12:17:10.257Z |
5079624 | 5079624 | 20240911030636_VUCFm | US001U | 2024-09-15T12:16:31.653Z | 2024-09-19T12:21:42.520Z |
5068041 | 5068041 | 20240910104614_1NKgM | US001U | 2024-09-14T12:19:07.579Z | 2024-09-18T12:15:25.429Z |
5067845 | 5067845 | 20240910101915_hCXLH | US001U | 2024-09-14T12:19:00.172Z | 2024-09-18T12:15:24.960Z |
5067692 | 5067692 | 20240910100134_3oMzM | US001U | 2024-09-14T12:18:54.269Z | 2024-09-18T12:15:24.698Z |
5067539 | 5067539 | 20240910094303_zBtql | US001U | 2024-09-14T12:18:47.898Z | 2024-09-18T12:15:24.332Z |
5066611 | 5066611 | 20240910075515_8CDeG | US001U | 2024-09-14T12:18:04.573Z | 2024-09-18T12:15:22.302Z |
5056833 | 5056833 | 20240908112949_8AZGK | US001U | 2024-09-13T12:17:39.890Z | 2024-09-16T12:21:27.469Z |
5056758 | 5056758 | 20240908112026_1lma3 | US001U | 2024-09-13T12:17:39.089Z | 2024-09-16T12:21:27.157Z |
5056578 | 5056578 | 20240908104551_5NeFf | US001U | 2024-09-13T12:17:35.557Z | 2024-09-16T12:21:25.960Z |
5056461 | 5056461 | 20240908103256_Wsnuk | US001U | 2024-09-13T12:17:32.581Z | 2024-09-16T12:21:25.487Z |
5056442 | 5056442 | 20240908103054_gyzgE | US001U | 2024-09-13T12:17:32.241Z | 2024-09-16T12:21:25.424Z |
5056216 | 5056216 | 20240908095610_n7O27 | US001U | 2024-09-13T12:17:28.523Z | 2024-09-16T12:21:23.870Z |
5056102 | 5056102 | 20240908094157_V4236 | US001U | 2024-09-13T12:17:27.490Z | 2024-09-16T12:21:23.300Z |
5055932 | 5055932 | 20240908092100_t8woq | US001U | 2024-09-13T12:17:25.752Z | 2024-09-16T12:21:22.617Z |
5055725 | 5055725 | 20240908084953_nIwh9 | US001U | 2024-09-13T12:17:20.994Z | 2024-09-16T12:21:21.716Z |
5055488 | 5055488 | 20240908081120_muK20 | US001U | 2024-09-13T12:17:15.255Z | 2024-09-16T12:21:19.996Z |
5055406 | 5055406 | 20240908080022_0omMk | US001U | 2024-09-13T12:17:11.767Z | 2024-09-16T12:21:19.314Z |
5055308 | 5055308 | 20240908074529_weBjQ | US001U | 2024-09-13T12:17:09.398Z | 2024-09-16T12:21:18.678Z |
5055250 | 5055250 | 20240908073416_OH21k | US001U | 2024-09-13T12:17:08.418Z | 2024-09-16T12:21:18.546Z |
5054942 | 5054942 | 20240908053241_9Rh2T | US001U | 2024-09-13T12:16:59.980Z | 2024-09-16T12:21:17.359Z |
5054861 | 5054861 | 20240908043242_kr4n4 | US001U | 2024-09-13T12:16:57.254Z | 2024-09-16T12:21:17.026Z |
5049695 | 5049695 | 20240909112917_qddD2 | US001U | 2024-09-13T12:12:23.033Z | 2024-09-17T12:19:11.231Z |
5049159 | 5049159 | 20240909101825_UwhZE | US001U | 2024-09-13T12:11:40.680Z | 2024-09-17T12:19:09.399Z |
5047793 | 5047793 | 20240909055730_KB72L | US001U | 2024-09-13T12:09:42.634Z | 2024-09-17T12:19:04.324Z |
5047782 | 5047782 | 20240909055509_HkPUE | US001U | 2024-09-13T12:09:41.529Z | 2024-09-17T12:19:04.278Z |
5047767 | 5047767 | 20240909055032_84vC4 | US001U | 2024-09-13T12:09:39.731Z | 2024-09-17T12:19:04.251Z |
5042122 | 5042122 | 20240906095926_I3kjW | US001U | 2024-09-12T12:16:55.966Z | 2024-09-14T12:23:16.131Z |
5041494 | 5041494 | 20240906082443_XfMe3 | US001U | 2024-09-12T12:16:43.066Z | 2024-09-14T12:23:13.753Z |
5040761 | 5040761 | 20240906054118_ebKpx | US001U | 2024-09-12T12:16:23.677Z | 2024-09-14T12:23:10.555Z |
5040508 | 5040508 | 20240906043216_2C862 | US001U | 2024-09-12T12:16:13.881Z | 2024-09-14T12:23:09.569Z |
5040421 | 5040421 | 20240906040737_BzVU1 | US001U | 2024-09-12T12:16:10.824Z | 2024-09-14T12:23:09.125Z |
5039917 | 5039917 | 20240906022635_VvWCv | US001U | 2024-09-12T12:15:50.907Z | 2024-09-14T12:23:05.831Z |
5035072 | 5035072 | 20240907084109_m99Bk | US001U | 2024-09-12T12:11:51.511Z | 2024-09-15T12:21:38.131Z |
5034388 | 5034388 | 20240907064438_6L02M | US001U | 2024-09-12T12:10:54.005Z | 2024-09-15T12:21:34.206Z |
5033948 | 5033948 | 20240907043520_lIYGx | US001U | 2024-09-12T12:10:14.448Z | 2024-09-15T12:21:32.331Z |
5033554 | 5033554 | 20240907030947_VhtWA | US001U | 2024-09-12T12:09:39.967Z | 2024-09-15T12:21:30.482Z |
5028871 | 5028871 | 20240905110447_7sKcr | US001U | 2024-09-11T12:15:57.116Z | 2024-09-14T12:22:49.858Z |
5028811 | 5028811 | 20240905105317_wmD0K | US001U | 2024-09-11T12:15:54.274Z | 2024-09-14T12:22:49.642Z |
5028669 | 5028669 | 20240905103619_3kURJ | US001U | 2024-09-11T12:15:41.321Z | 2024-09-14T12:22:48.757Z |
5028375 | 5028375 | 20240905093233_9VFx9 | US001U | 2024-09-11T12:15:13.079Z | 2024-09-13T12:20:06.072Z |
5025598 | 5025598 | 20240906022635_LLZdx | US001U | 2024-09-11T12:06:55.564Z | 2024-09-11T12:16:32.711Z |
5022810 | 5022810 | 20240905093233_ayR3q | US001U | 2024-09-10T12:16:30.262Z | 2024-09-10T12:16:55.618Z |
5013684 | 5013684 | 20240905110447_VrnXS | US001U | 2024-09-10T12:01:16.779Z | 2024-09-11T12:00:30.693Z |
5013622 | 5013622 | 20240905105317_EQHiY | US001U | 2024-09-10T12:01:05.789Z | 2024-09-11T12:00:28.006Z |
5013481 | 5013481 | 20240905103619_cjoBp | US001U | 2024-09-10T12:00:47.793Z | 2024-09-11T12:00:22.000Z |
5013028 | 5013028 | 20240903081413_dN82j | US001U | 2024-09-09T12:18:24.700Z | 2024-09-11T12:21:19.659Z |
5012842 | 5012842 | 20240903074340_OqsEh | US001U | 2024-09-09T12:18:18.521Z | 2024-09-11T12:21:19.054Z |
5004248 | 5004248 | 20240903110703_CA7gU | US001U | 2024-09-09T12:02:31.510Z | 2024-09-12T12:19:01.334Z |
5003731 | 5003731 | 20240903094357_Gbssl | US001U | 2024-09-09T12:02:00.418Z | 2024-09-12T12:18:58.876Z |
5003430 | 5003430 | 20240903084811_S3KTv | US001U | 2024-09-09T12:01:43.410Z | 2024-09-12T12:18:56.619Z |
5001966 | 5001966 | 20240902072234_9kQkk | US001U | 2024-09-08T12:17:05.037Z | 2024-09-10T12:19:35.768Z |
5001919 | 5001919 | 20240902070944_EMgsJ | US001U | 2024-09-08T12:17:02.771Z | 2024-09-10T12:19:35.356Z |
5001557 | 5001557 | 20240902053205_ykuDW | US001U | 2024-09-08T12:16:34.666Z | 2024-09-10T12:19:33.422Z |
5001310 | 5001310 | 20240902042237_vMePP | US001U | 2024-09-08T12:16:19.057Z | 2024-09-10T12:19:32.814Z |
5001151 | 5001151 | 20240902033957_qWeKT | US001U | 2024-09-08T12:16:12.291Z | 2024-09-10T12:19:32.136Z |
5001045 | 5001045 | 20240902032309_gOaS2 | US001U | 2024-09-08T12:16:07.261Z | 2024-09-10T12:19:31.321Z |
5000686 | 5000686 | 20240902023838_KIbJC | US001U | 2024-09-08T12:15:36.639Z | 2024-09-10T12:19:29.255Z |
4999346 | 4999346 | 20240903062050_4crc9 | US001U | 2024-09-08T12:08:41.459Z | 2024-09-11T12:21:17.340Z |
4999262 | 4999262 | 20240903060656_dFyax | US001U | 2024-09-08T12:08:37.197Z | 2024-09-11T12:21:17.009Z |
4998520 | 4998520 | 20240903031457_Xczvg | US001U | 2024-09-08T12:07:45.169Z | 2024-09-11T12:21:13.338Z |
4998310 | 4998310 | 20240903024256_89MOd | US001U | 2024-09-08T12:07:28.906Z | 2024-09-11T12:21:11.985Z |
4993744 | 4993744 | 20240902111813_pObYQ | US001U | 2024-09-08T12:01:51.333Z | 2024-09-11T12:20:26.454Z |
4993640 | 4993640 | 20240902110519_0hOTT | US001U | 2024-09-08T12:01:45.566Z | 2024-09-11T12:20:25.551Z |
4993386 | 4993386 | 20240902102543_7RWfn | US001U | 2024-09-08T12:01:30.110Z | 2024-09-11T12:20:22.235Z |
4993269 | 4993269 | 20240902100929_wbaes | US001U | 2024-09-08T12:01:22.030Z | 2024-09-11T12:20:21.622Z |
4992839 | 4992839 | 20240902090350_Ql2sI | US001U | 2024-09-08T12:00:54.655Z | 2024-09-11T12:20:17.818Z |
4992714 | 4992714 | 20240902084445_DlmEd | US001U | 2024-09-08T12:00:46.544Z | 2024-09-11T12:20:16.680Z |
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);