participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
19,289 rows where station_code = "USL007" 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 |
---|---|---|---|---|---|
5135674 | 5135674 | 20240914104828_UGApK | USL007 | 2024-09-19T12:20:13.342Z | 2024-09-19T12:20:13.342Z |
5134829 | 5134829 | 20240916121805_Ue72q | USL007 | 2024-09-19T12:18:07.489Z | 2024-09-19T12:18:07.489Z |
5134790 | 5134790 | 20240916115248_rFYSl | USL007 | 2024-09-19T12:18:06.657Z | 2024-09-19T12:18:06.657Z |
5134720 | 5134720 | 20240916112712_DnbWI | USL007 | 2024-09-19T12:18:04.784Z | 2024-09-19T12:18:04.784Z |
5134673 | 5134673 | 20240916111431_blK2O | USL007 | 2024-09-19T12:18:03.246Z | 2024-09-19T12:18:03.246Z |
5134656 | 5134656 | 20240916110646_1xmNB | USL007 | 2024-09-19T12:18:01.583Z | 2024-09-19T12:18:01.583Z |
5134622 | 5134622 | 20240916105403_Z4tNp | USL007 | 2024-09-19T12:17:57.938Z | 2024-09-19T12:17:57.938Z |
5134618 | 5134618 | 20240916105212_iuA3S | USL007 | 2024-09-19T12:17:57.407Z | 2024-09-19T12:17:57.407Z |
5134607 | 5134607 | 20240916104929_W3BeR | USL007 | 2024-09-19T12:17:55.545Z | 2024-09-19T12:17:55.545Z |
5134570 | 5134570 | 20240916103527_n2XmN | USL007 | 2024-09-19T12:17:51.643Z | 2024-09-19T12:17:51.643Z |
5134519 | 5134519 | 20240916100438_DLD9S | USL007 | 2024-09-19T12:17:48.172Z | 2024-09-19T12:17:48.172Z |
5134451 | 5134451 | 20240916092442_Ajx6Q | USL007 | 2024-09-19T12:17:44.697Z | 2024-09-19T12:17:44.697Z |
5134439 | 5134439 | 20240916091834_HsAa7 | USL007 | 2024-09-19T12:17:44.113Z | 2024-09-19T12:17:44.113Z |
5134214 | 5134214 | 20240916064819_qEwFJ | USL007 | 2024-09-19T12:17:31.715Z | 2024-09-19T12:17:31.715Z |
5134090 | 5134090 | 20240916044940_4LEYw | USL007 | 2024-09-19T12:17:19.095Z | 2024-09-19T12:17:19.095Z |
5134034 | 5134034 | 20240916043422_xNc3y | USL007 | 2024-09-19T12:17:16.785Z | 2024-09-19T12:17:16.785Z |
5133957 | 5133957 | 20240916042012_HpmgL | USL007 | 2024-09-19T12:17:14.134Z | 2024-09-19T12:17:14.134Z |
5132931 | 5132931 | 20240916023025_MhTXm | USL007 | 2024-09-19T12:16:37.813Z | 2024-09-19T12:16:37.813Z |
5130404 | 5130404 | 20240917115104_OW7mp | USL007 | 2024-09-19T12:13:10.694Z | 2024-09-19T12:13:10.694Z |
5130340 | 5130340 | 20240917112943_YUfVy | USL007 | 2024-09-19T12:13:02.554Z | 2024-09-19T12:13:02.554Z |
5130314 | 5130314 | 20240917111301_EF3dh | USL007 | 2024-09-19T12:12:58.979Z | 2024-09-19T12:12:58.979Z |
5130302 | 5130302 | 20240917110740_C92lT | USL007 | 2024-09-19T12:12:57.936Z | 2024-09-19T12:12:57.936Z |
5130288 | 5130288 | 20240917110453_IBt25 | USL007 | 2024-09-19T12:12:56.246Z | 2024-09-19T12:12:56.246Z |
5130250 | 5130250 | 20240917104642_wjYtg | USL007 | 2024-09-19T12:12:51.254Z | 2024-09-19T12:12:51.254Z |
5130199 | 5130199 | 20240917101520_CR7AM | USL007 | 2024-09-19T12:12:45.722Z | 2024-09-19T12:12:45.722Z |
5130126 | 5130126 | 20240917091749_pmK6x | USL007 | 2024-09-19T12:12:37.954Z | 2024-09-19T12:12:37.954Z |
5130100 | 5130100 | 20240917090429_nRr0L | USL007 | 2024-09-19T12:12:34.775Z | 2024-09-19T12:12:34.775Z |
5129916 | 5129916 | 20240917061408_00PGr | USL007 | 2024-09-19T12:12:16.613Z | 2024-09-19T12:12:16.613Z |
5129648 | 5129648 | 20240917041732_r6v1s | USL007 | 2024-09-19T12:11:58.817Z | 2024-09-19T12:11:58.817Z |
5126420 | 5126420 | 20240918114006_HxRoG | USL007 | 2024-09-19T12:05:56.264Z | 2024-09-19T12:06:42.198Z |
5126358 | 5126358 | 20240918111255_HogMK | USL007 | 2024-09-19T12:05:49.751Z | 2024-09-19T12:06:42.188Z |
5126224 | 5126224 | 20240918095242_cHUex | USL007 | 2024-09-19T12:05:23.642Z | 2024-09-19T12:06:42.164Z |
5126091 | 5126091 | 20240918081548_cRG3o | USL007 | 2024-09-19T12:05:02.536Z | 2024-09-19T12:06:42.139Z |
5126089 | 5126089 | 20240918081538_9bVlT | USL007 | 2024-09-19T12:05:01.682Z | 2024-09-19T12:06:42.138Z |
5126067 | 5126067 | 20240918074945_jIbzQ | USL007 | 2024-09-19T12:04:53.537Z | 2024-09-19T12:06:42.134Z |
5125894 | 5125894 | 20240918042802_dNqD9 | USL007 | 2024-09-19T12:04:30.315Z | 2024-09-19T12:06:42.103Z |
5125564 | 5125564 | 20240918030201_Fg6tL | USL007 | 2024-09-19T12:03:32.851Z | 2024-09-19T12:06:42.052Z |
5123634 | 5123634 | 20240914105308_FkB3c | USL007 | 2024-09-18T12:11:52.867Z | 2024-09-19T12:20:13.405Z |
5123612 | 5123612 | 20240914104634_kl3va | USL007 | 2024-09-18T12:11:52.269Z | 2024-09-19T12:20:13.267Z |
5123560 | 5123560 | 20240914103412_eBeM6 | USL007 | 2024-09-18T12:11:51.380Z | 2024-09-19T12:20:12.636Z |
5123483 | 5123483 | 20240914101737_SL5kU | USL007 | 2024-09-18T12:11:50.144Z | 2024-09-19T12:20:11.311Z |
5123469 | 5123469 | 20240914101419_VUk3s | USL007 | 2024-09-18T12:11:49.857Z | 2024-09-19T12:20:11.178Z |
5123429 | 5123429 | 20240914100522_0Xe5U | USL007 | 2024-09-18T12:11:48.663Z | 2024-09-19T12:20:11.014Z |
5123396 | 5123396 | 20240914095739_jCDMK | USL007 | 2024-09-18T12:11:47.862Z | 2024-09-19T12:20:10.744Z |
5123389 | 5123389 | 20240914095639_IBu5L | USL007 | 2024-09-18T12:11:47.733Z | 2024-09-19T12:20:10.703Z |
5123362 | 5123362 | 20240914095230_j3hoY | USL007 | 2024-09-18T12:11:46.889Z | 2024-09-19T12:20:10.575Z |
5123360 | 5123360 | 20240914095152_D3WwZ | USL007 | 2024-09-18T12:11:46.757Z | 2024-09-19T12:20:10.568Z |
5123312 | 5123312 | 20240914094344_FaWhm | USL007 | 2024-09-18T12:11:45.214Z | 2024-09-19T12:20:10.351Z |
5123220 | 5123220 | 20240914091851_2pNlI | USL007 | 2024-09-18T12:11:42.738Z | 2024-09-19T12:20:09.044Z |
5123103 | 5123103 | 20240914085339_CusZS | USL007 | 2024-09-18T12:11:39.966Z | 2024-09-19T12:20:07.707Z |
5122897 | 5122897 | 20240914081820_ZcoJ9 | USL007 | 2024-09-18T12:11:33.744Z | 2024-09-19T12:20:06.662Z |
5122887 | 5122887 | 20240914081636_wkLpF | USL007 | 2024-09-18T12:11:33.532Z | 2024-09-19T12:20:06.644Z |
5122837 | 5122837 | 20240914080717_Gddlv | USL007 | 2024-09-18T12:11:32.296Z | 2024-09-19T12:20:06.423Z |
5122831 | 5122831 | 20240914080526_t3LFm | USL007 | 2024-09-18T12:11:32.209Z | 2024-09-19T12:20:06.387Z |
5122788 | 5122788 | 20240914075801_V0o7g | USL007 | 2024-09-18T12:11:31.257Z | 2024-09-19T12:20:06.188Z |
5122669 | 5122669 | 20240914073011_tRkYt | USL007 | 2024-09-18T12:11:27.698Z | 2024-09-19T12:20:05.626Z |
5122618 | 5122618 | 20240914072426_yNyoL | USL007 | 2024-09-18T12:11:25.499Z | 2024-09-19T12:20:05.427Z |
5122412 | 5122412 | 20240914061511_axhsA | USL007 | 2024-09-18T12:11:17.794Z | 2024-09-19T12:20:04.251Z |
5122236 | 5122236 | 20240914050653_fSw3Y | USL007 | 2024-09-18T12:11:11.242Z | 2024-09-19T12:20:03.392Z |
5122000 | 5122000 | 20240914042551_35Qzf | USL007 | 2024-09-18T12:11:04.494Z | 2024-09-19T12:20:02.656Z |
5121224 | 5121224 | 20240914035608_82nzd | USL007 | 2024-09-18T12:10:52.577Z | 2024-09-19T12:20:01.516Z |
5120096 | 5120096 | 20240914025954_RZnci | USL007 | 2024-09-18T12:10:32.158Z | 2024-09-19T12:19:59.421Z |
5118948 | 5118948 | 20240915114837_NrR4U | USL007 | 2024-09-18T12:09:14.391Z | 2024-09-19T12:19:27.745Z |
5118919 | 5118919 | 20240915113638_bABPF | USL007 | 2024-09-18T12:09:12.947Z | 2024-09-19T12:19:27.607Z |
5118900 | 5118900 | 20240915113214_kIq0s | USL007 | 2024-09-18T12:09:12.244Z | 2024-09-19T12:19:27.323Z |
5118897 | 5118897 | 20240915112903_SrUwc | USL007 | 2024-09-18T12:09:12.020Z | 2024-09-19T12:19:27.080Z |
5118886 | 5118886 | 20240915112738_ufMos | USL007 | 2024-09-18T12:09:11.541Z | 2024-09-19T12:19:27.027Z |
5118754 | 5118754 | 20240915110155_Gb24R | USL007 | 2024-09-18T12:09:01.584Z | 2024-09-19T12:19:25.329Z |
5118717 | 5118717 | 20240915105448_Po8pt | USL007 | 2024-09-18T12:09:00.039Z | 2024-09-19T12:19:25.132Z |
5118620 | 5118620 | 20240915103140_vgKeX | USL007 | 2024-09-18T12:08:53.884Z | 2024-09-19T12:19:24.499Z |
5118495 | 5118495 | 20240915100038_CCjb2 | USL007 | 2024-09-18T12:08:48.699Z | 2024-09-19T12:19:23.427Z |
5118476 | 5118476 | 20240915095544_lyK6D | USL007 | 2024-09-18T12:08:47.043Z | 2024-09-19T12:19:23.241Z |
5118446 | 5118446 | 20240915094752_e074g | USL007 | 2024-09-18T12:08:44.694Z | 2024-09-19T12:19:23.006Z |
5118441 | 5118441 | 20240915094740_3l1eI | USL007 | 2024-09-18T12:08:44.381Z | 2024-09-19T12:19:22.953Z |
5118381 | 5118381 | 20240915093148_q3Ebk | USL007 | 2024-09-18T12:08:41.458Z | 2024-09-19T12:19:22.426Z |
5118330 | 5118330 | 20240915092207_BvQog | USL007 | 2024-09-18T12:08:38.019Z | 2024-09-19T12:19:22.151Z |
5118147 | 5118147 | 20240915084242_VQuo3 | USL007 | 2024-09-18T12:08:27.014Z | 2024-09-19T12:19:20.807Z |
5118069 | 5118069 | 20240915082339_23cx7 | USL007 | 2024-09-18T12:08:21.913Z | 2024-09-19T12:19:20.101Z |
5117940 | 5117940 | 20240915075322_Ki2DS | USL007 | 2024-09-18T12:08:08.975Z | 2024-09-19T12:19:19.173Z |
5117712 | 5117712 | 20240915063427_ee81T | USL007 | 2024-09-18T12:07:53.329Z | 2024-09-19T12:19:17.157Z |
5117575 | 5117575 | 20240915053633_QWOeY | USL007 | 2024-09-18T12:07:47.805Z | 2024-09-19T12:19:16.131Z |
5117556 | 5117556 | 20240915052313_59orJ | USL007 | 2024-09-18T12:07:46.636Z | 2024-09-19T12:19:15.953Z |
5117524 | 5117524 | 20240915045732_9jsHy | USL007 | 2024-09-18T12:07:45.050Z | 2024-09-19T12:19:15.664Z |
5117350 | 5117350 | 20240915041930_wc5FN | USL007 | 2024-09-18T12:07:38.210Z | 2024-09-19T12:19:14.412Z |
5117017 | 5117017 | 20240915035634_MlZqZ | USL007 | 2024-09-18T12:07:29.473Z | 2024-09-19T12:19:13.062Z |
5115607 | 5115607 | 20240915024613_gleAw | USL007 | 2024-09-18T12:06:19.070Z | 2024-09-19T12:19:05.798Z |
5110163 | 5110163 | 20240913121859_0d08S | USL007 | 2024-09-17T12:14:58.149Z | 2024-09-19T12:20:55.884Z |
5109935 | 5109935 | 20240913113913_MLUXU | USL007 | 2024-09-17T12:14:50.320Z | 2024-09-19T12:20:55.386Z |
5109894 | 5109894 | 20240913113344_6oBfq | USL007 | 2024-09-17T12:14:48.822Z | 2024-09-19T12:20:55.324Z |
5109886 | 5109886 | 20240913113253_lO6N9 | USL007 | 2024-09-17T12:14:48.485Z | 2024-09-19T12:20:55.242Z |
5109785 | 5109785 | 20240913110525_fBvQ3 | USL007 | 2024-09-17T12:14:46.080Z | 2024-09-19T12:20:54.748Z |
5109670 | 5109670 | 20240913104503_VVH4v | USL007 | 2024-09-17T12:14:43.458Z | 2024-09-19T12:20:54.425Z |
5109542 | 5109542 | 20240913102022_zTZkT | USL007 | 2024-09-17T12:14:40.780Z | 2024-09-19T12:20:53.708Z |
5109407 | 5109407 | 20240913095127_UBFOl | USL007 | 2024-09-17T12:14:37.531Z | 2024-09-19T12:20:53.251Z |
5109361 | 5109361 | 20240913093947_uzlS5 | USL007 | 2024-09-17T12:14:36.541Z | 2024-09-19T12:20:53.133Z |
5109346 | 5109346 | 20240913093637_jIkQs | USL007 | 2024-09-17T12:14:36.195Z | 2024-09-19T12:20:53.052Z |
5109226 | 5109226 | 20240913091731_FbDcI | USL007 | 2024-09-17T12:14:33.680Z | 2024-09-19T12:20:52.605Z |
5109175 | 5109175 | 20240913090637_3sEiL | USL007 | 2024-09-17T12:14:32.411Z | 2024-09-19T12:20:52.388Z |
5109047 | 5109047 | 20240913083544_IpS6U | USL007 | 2024-09-17T12:14:28.048Z | 2024-09-19T12:20:51.556Z |
5108922 | 5108922 | 20240913080543_DgSqW | USL007 | 2024-09-17T12:14:18.246Z | 2024-09-19T12:20:51.139Z |
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);