participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "BG0003" 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 |
---|---|---|---|---|---|
5524427 | 5524427 | 20241111041110_DKff3 | BG0003 | 2024-11-12T14:17:20.708Z | 2024-11-12T14:18:08.617Z |
5524410 | 5524410 | 20241111040934_Uc8Yu | BG0003 | 2024-11-12T14:17:16.416Z | 2024-11-12T14:18:08.609Z |
5524300 | 5524300 | 20241111035028_MUnrP | BG0003 | 2024-11-12T14:16:58.170Z | 2024-11-12T14:18:08.550Z |
5524136 | 5524136 | 20241111031821_s5Yjj | BG0003 | 2024-11-12T14:16:35.106Z | 2024-11-12T14:18:08.483Z |
5524092 | 5524092 | 20241111031344_w7ovz | BG0003 | 2024-11-12T14:16:32.128Z | 2024-11-12T14:18:08.466Z |
5524086 | 5524086 | 20241111031243_Pxmc7 | BG0003 | 2024-11-12T14:16:31.612Z | 2024-11-12T14:18:08.463Z |
5524013 | 5524013 | 20241111030158_OLKzd | BG0003 | 2024-11-12T14:16:26.566Z | 2024-11-12T14:18:08.433Z |
5524011 | 5524011 | 20241111030127_0YLCn | BG0003 | 2024-11-12T14:16:26.194Z | 2024-11-12T14:18:08.432Z |
5523906 | 5523906 | 20241111024533_49ig3 | BG0003 | 2024-11-12T14:16:19.805Z | 2024-11-12T14:18:08.392Z |
5523871 | 5523871 | 20241111024240_avTl0 | BG0003 | 2024-11-12T14:16:18.364Z | 2024-11-12T14:18:08.381Z |
5523852 | 5523852 | 20241111023847_wf4km | BG0003 | 2024-11-12T14:16:17.375Z | 2024-11-12T14:18:08.373Z |
5523840 | 5523840 | 20241111023400_vyZT0 | BG0003 | 2024-11-12T14:16:16.517Z | 2024-11-12T14:18:08.366Z |
5523795 | 5523795 | 20241111022425_WbJT1 | BG0003 | 2024-11-12T14:16:13.520Z | 2024-11-12T14:18:08.347Z |
5523772 | 5523772 | 20241111022145_g3omX | BG0003 | 2024-11-12T14:16:12.388Z | 2024-11-12T14:18:08.338Z |
5523620 | 5523620 | 20241111015746_bikYR | BG0003 | 2024-11-12T14:16:04.098Z | 2024-11-12T14:18:08.276Z |
5523562 | 5523562 | 20241111014609_fNI2r | BG0003 | 2024-11-12T14:16:00.375Z | 2024-11-12T14:18:08.250Z |
5523421 | 5523421 | 20241111012134_A2WJZ | BG0003 | 2024-11-12T14:15:35.293Z | 2024-11-12T14:18:08.188Z |
5523256 | 5523256 | 20241111004657_mVkzK | BG0003 | 2024-11-12T14:15:10.227Z | 2024-11-12T14:18:08.109Z |
5521977 | 5521977 | 20241110184242_Nq3AM | BG0003 | 2024-11-12T14:12:21.128Z | 2024-11-12T14:18:07.545Z |
5518164 | 5518164 | 20241108161032_JttXH | BG0003 | 2024-11-11T14:16:26.255Z | 2024-11-12T14:22:51.117Z |
5517312 | 5517312 | 20241110032226_bDKpW | BG0003 | 2024-11-11T14:14:13.671Z | 2024-11-12T14:21:37.423Z |
5517309 | 5517309 | 20241110032226_5gIDp | BG0003 | 2024-11-11T14:14:13.507Z | 2024-11-12T14:21:37.350Z |
5517087 | 5517087 | 20241110024606_jPO0d | BG0003 | 2024-11-11T14:13:52.600Z | 2024-11-12T14:21:31.341Z |
5517052 | 5517052 | 20241110023943_h7c8q | BG0003 | 2024-11-11T14:13:48.555Z | 2024-11-12T14:21:29.900Z |
5516765 | 5516765 | 20241110015839_H8Ny9 | BG0003 | 2024-11-11T14:13:18.905Z | 2024-11-12T14:21:18.353Z |
5516730 | 5516730 | 20241110015120_5V8dm | BG0003 | 2024-11-11T14:13:17.338Z | 2024-11-12T14:21:17.569Z |
5516569 | 5516569 | 20241110012318_x5obS | BG0003 | 2024-11-11T14:13:09.277Z | 2024-11-12T14:21:12.134Z |
5516236 | 5516236 | 20241110001905_M3O2z | BG0003 | 2024-11-11T14:12:31.853Z | 2024-11-12T14:20:55.548Z |
5516188 | 5516188 | 20241110001045_SOG12 | BG0003 | 2024-11-11T14:12:25.237Z | 2024-11-12T14:20:53.267Z |
5516152 | 5516152 | 20241110000043_SSxVb | BG0003 | 2024-11-11T14:12:20.713Z | 2024-11-12T14:20:51.835Z |
5515893 | 5515893 | 20241109230751_smu7y | BG0003 | 2024-11-11T14:11:43.802Z | 2024-11-12T14:20:43.030Z |
5515825 | 5515825 | 20241109225250_Q4R7f | BG0003 | 2024-11-11T14:11:33.727Z | 2024-11-12T14:20:40.223Z |
5515270 | 5515270 | 20241109201031_G2g79 | BG0003 | 2024-11-11T14:10:31.497Z | 2024-11-12T14:20:15.703Z |
5515238 | 5515238 | 20241109200039_7fYv4 | BG0003 | 2024-11-11T14:10:25.440Z | 2024-11-12T14:20:14.197Z |
5515195 | 5515195 | 20241109195041_98UHv | BG0003 | 2024-11-11T14:10:19.097Z | 2024-11-12T14:20:12.930Z |
5514877 | 5514877 | 20241109181410_QOAgp | BG0003 | 2024-11-11T14:09:39.737Z | 2024-11-12T14:19:54.504Z |
5514759 | 5514759 | 20241109172243_lKpPZ | BG0003 | 2024-11-11T14:09:08.960Z | 2024-11-12T14:19:46.214Z |
5514690 | 5514690 | 20241109164732_tQZqH | BG0003 | 2024-11-11T14:08:58.009Z | 2024-11-12T14:19:41.385Z |
5510962 | 5510962 | 20241109040043_bnE5V | BG0003 | 2024-11-10T14:15:59.615Z | 2024-11-12T14:23:42.886Z |
5510917 | 5510917 | 20241109035436_au4IG | BG0003 | 2024-11-10T14:15:54.641Z | 2024-11-12T14:23:42.317Z |
5510913 | 5510913 | 20241109035436_tfUEe | BG0003 | 2024-11-10T14:15:54.512Z | 2024-11-12T14:23:42.301Z |
5510892 | 5510892 | 20241109035005_6trs4 | BG0003 | 2024-11-10T14:15:51.690Z | 2024-11-12T14:23:42.117Z |
5510751 | 5510751 | 20241109033233_Br0Eo | BG0003 | 2024-11-10T14:15:38.008Z | 2024-11-12T14:23:40.325Z |
5510701 | 5510701 | 20241109032749_UBCYA | BG0003 | 2024-11-10T14:15:34.959Z | 2024-11-12T14:23:39.698Z |
5510692 | 5510692 | 20241109032709_HMPps | BG0003 | 2024-11-10T14:15:34.583Z | 2024-11-12T14:23:39.592Z |
5510596 | 5510596 | 20241109030806_uH6kG | BG0003 | 2024-11-10T14:15:28.763Z | 2024-11-12T14:23:38.227Z |
5510466 | 5510466 | 20241109024435_DHujq | BG0003 | 2024-11-10T14:15:18.898Z | 2024-11-12T14:23:36.627Z |
5510423 | 5510423 | 20241109023905_2DLyh | BG0003 | 2024-11-10T14:15:12.720Z | 2024-11-12T14:23:35.988Z |
5510415 | 5510415 | 20241109023747_WEr3K | BG0003 | 2024-11-10T14:15:11.332Z | 2024-11-12T14:23:35.803Z |
5510301 | 5510301 | 20241109021846_c1RlL | BG0003 | 2024-11-10T14:14:58.787Z | 2024-11-12T14:23:33.824Z |
5510292 | 5510292 | 20241109021723_FvwZH | BG0003 | 2024-11-10T14:14:57.661Z | 2024-11-12T14:23:33.774Z |
5510276 | 5510276 | 20241109021543_iT9b1 | BG0003 | 2024-11-10T14:14:56.393Z | 2024-11-12T14:23:33.565Z |
5510160 | 5510160 | 20241109015221_bdRnf | BG0003 | 2024-11-10T14:14:41.343Z | 2024-11-12T14:23:31.331Z |
5510120 | 5510120 | 20241109014530_Ciw6J | BG0003 | 2024-11-10T14:14:37.745Z | 2024-11-12T14:23:30.575Z |
5510119 | 5510119 | 20241109014525_aUTZJ | BG0003 | 2024-11-10T14:14:37.348Z | 2024-11-12T14:23:30.572Z |
5510066 | 5510066 | 20241109013846_XjC6W | BG0003 | 2024-11-10T14:14:32.380Z | 2024-11-12T14:23:29.847Z |
5510042 | 5510042 | 20241109013324_c09wN | BG0003 | 2024-11-10T14:14:30.057Z | 2024-11-12T14:23:29.633Z |
5509998 | 5509998 | 20241109012543_DZuQc | BG0003 | 2024-11-10T14:14:25.733Z | 2024-11-12T14:23:28.747Z |
5509968 | 5509968 | 20241109011829_RVeVn | BG0003 | 2024-11-10T14:14:20.338Z | 2024-11-12T14:23:28.170Z |
5509833 | 5509833 | 20241109004814_e3dji | BG0003 | 2024-11-10T14:14:05.151Z | 2024-11-12T14:23:25.844Z |
5509831 | 5509831 | 20241109004800_fHFvt | BG0003 | 2024-11-10T14:14:04.942Z | 2024-11-12T14:23:25.819Z |
5509773 | 5509773 | 20241109003239_XRJph | BG0003 | 2024-11-10T14:13:59.788Z | 2024-11-12T14:23:24.965Z |
5509666 | 5509666 | 20241109000800_FDKbZ | BG0003 | 2024-11-10T14:13:49.514Z | 2024-11-12T14:23:23.506Z |
5509662 | 5509662 | 20241109000641_hKstj | BG0003 | 2024-11-10T14:13:48.866Z | 2024-11-12T14:23:23.496Z |
5509653 | 5509653 | 20241109000423_XiI9n | BG0003 | 2024-11-10T14:13:47.561Z | 2024-11-12T14:23:23.436Z |
5509651 | 5509651 | 20241109000415_ezRyy | BG0003 | 2024-11-10T14:13:47.323Z | 2024-11-12T14:23:23.293Z |
5509636 | 5509636 | 20241109000141_7CsNT | BG0003 | 2024-11-10T14:13:45.608Z | 2024-11-12T14:23:23.197Z |
5509629 | 5509629 | 20241109000112_msufe | BG0003 | 2024-11-10T14:13:44.660Z | 2024-11-12T14:23:23.038Z |
5509617 | 5509617 | 20241108235731_406s6 | BG0003 | 2024-11-10T14:13:41.394Z | 2024-11-12T14:23:22.942Z |
5509600 | 5509600 | 20241108235311_6vcDR | BG0003 | 2024-11-10T14:13:38.957Z | 2024-11-12T14:23:22.277Z |
5509579 | 5509579 | 20241108235011_MpFg4 | BG0003 | 2024-11-10T14:13:36.872Z | 2024-11-12T14:23:22.047Z |
5509570 | 5509570 | 20241108234742_DthEW | BG0003 | 2024-11-10T14:13:36.070Z | 2024-11-12T14:23:22.003Z |
5509532 | 5509532 | 20241108234140_A2WEG | BG0003 | 2024-11-10T14:13:32.822Z | 2024-11-12T14:23:21.497Z |
5509524 | 5509524 | 20241108233949_EfQ1Y | BG0003 | 2024-11-10T14:13:31.549Z | 2024-11-12T14:23:21.436Z |
5509418 | 5509418 | 20241108231523_V2723 | BG0003 | 2024-11-10T14:13:21.047Z | 2024-11-12T14:23:18.543Z |
5509395 | 5509395 | 20241108230653_DbJSZ | BG0003 | 2024-11-10T14:13:18.796Z | 2024-11-12T14:23:18.205Z |
5509277 | 5509277 | 20241108224104_tTO3b | BG0003 | 2024-11-10T14:13:07.646Z | 2024-11-12T14:23:16.209Z |
5509272 | 5509272 | 20241108224007_3lAwy | BG0003 | 2024-11-10T14:13:06.776Z | 2024-11-12T14:23:16.187Z |
5509256 | 5509256 | 20241108223719_oCrxs | BG0003 | 2024-11-10T14:13:02.886Z | 2024-11-12T14:23:16.105Z |
5509250 | 5509250 | 20241108223515_Vc0Rq | BG0003 | 2024-11-10T14:13:02.141Z | 2024-11-12T14:23:16.047Z |
5509174 | 5509174 | 20241108221502_RZ9uY | BG0003 | 2024-11-10T14:12:48.363Z | 2024-11-12T14:23:14.312Z |
5509164 | 5509164 | 20241108221144_zG9sq | BG0003 | 2024-11-10T14:12:46.991Z | 2024-11-12T14:23:14.260Z |
5509150 | 5509150 | 20241108220658_eKzNk | BG0003 | 2024-11-10T14:12:45.236Z | 2024-11-12T14:23:14.165Z |
5509088 | 5509088 | 20241108214646_aOmbl | BG0003 | 2024-11-10T14:12:32.329Z | 2024-11-12T14:23:13.360Z |
5509057 | 5509057 | 20241108213705_54gAo | BG0003 | 2024-11-10T14:12:26.316Z | 2024-11-12T14:23:12.783Z |
5509047 | 5509047 | 20241108213518_eQ0cz | BG0003 | 2024-11-10T14:12:24.602Z | 2024-11-12T14:23:12.403Z |
5509020 | 5509020 | 20241108211424_SURXv | BG0003 | 2024-11-10T14:12:19.617Z | 2024-11-12T14:23:11.485Z |
5509015 | 5509015 | 20241108211301_jc1oa | BG0003 | 2024-11-10T14:12:19.137Z | 2024-11-12T14:23:11.465Z |
5509000 | 5509000 | 20241108211103_6NI6A | BG0003 | 2024-11-10T14:12:16.670Z | 2024-11-12T14:23:11.333Z |
5508912 | 5508912 | 20241108203948_N6Pu5 | BG0003 | 2024-11-10T14:12:02.567Z | 2024-11-12T14:23:08.175Z |
5508908 | 5508908 | 20241108203757_inLJq | BG0003 | 2024-11-10T14:12:02.254Z | 2024-11-12T14:23:07.944Z |
5508871 | 5508871 | 20241108201453_vQcSM | BG0003 | 2024-11-10T14:11:58.880Z | 2024-11-12T14:23:06.383Z |
5508807 | 5508807 | 20241108193602_udY6e | BG0003 | 2024-11-10T14:11:50.666Z | 2024-11-12T14:23:04.124Z |
5508796 | 5508796 | 20241108193028_WFd3Z | BG0003 | 2024-11-10T14:11:49.752Z | 2024-11-12T14:23:03.869Z |
5508787 | 5508787 | 20241108192532_apCYE | BG0003 | 2024-11-10T14:11:49.074Z | 2024-11-12T14:23:03.619Z |
5508785 | 5508785 | 20241108192259_IuuDy | BG0003 | 2024-11-10T14:11:48.862Z | 2024-11-12T14:23:03.479Z |
5508774 | 5508774 | 20241108191921_svxvI | BG0003 | 2024-11-10T14:11:47.997Z | 2024-11-12T14:23:03.358Z |
5508747 | 5508747 | 20241108184821_kTWWs | BG0003 | 2024-11-10T14:11:42.659Z | 2024-11-12T14:23:02.053Z |
5508738 | 5508738 | 20241108183410_WKkCZ | BG0003 | 2024-11-10T14:11:32.534Z | 2024-11-12T14:23:00.730Z |
5508732 | 5508732 | 20241108182821_HK82h | BG0003 | 2024-11-10T14:11:29.392Z | 2024-11-12T14:23:00.642Z |
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);