participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,876 rows where station_code = "BG000C" 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 |
---|---|---|---|---|---|
5505036 | 5505036 | 20241108034112_bE22L | BG000C | 2024-11-09T14:15:37.575Z | 2024-11-09T14:16:28.685Z |
5505028 | 5505028 | 20241108033629_3tyDQ | BG000C | 2024-11-09T14:15:36.961Z | 2024-11-09T14:16:28.683Z |
5504830 | 5504830 | 20241108030343_yn1l3 | BG000C | 2024-11-09T14:15:14.442Z | 2024-11-09T14:16:28.636Z |
5504805 | 5504805 | 20241108030007_DNfNA | BG000C | 2024-11-09T14:15:12.385Z | 2024-11-09T14:16:28.630Z |
5504695 | 5504695 | 20241108024151_1P1EE | BG000C | 2024-11-09T14:15:04.401Z | 2024-11-09T14:16:28.603Z |
5504685 | 5504685 | 20241108024049_HtGDR | BG000C | 2024-11-09T14:15:04.138Z | 2024-11-09T14:16:28.601Z |
5504598 | 5504598 | 20241108022112_4uObt | BG000C | 2024-11-09T14:14:55.612Z | 2024-11-09T14:16:28.578Z |
5504595 | 5504595 | 20241108022107_KL720 | BG000C | 2024-11-09T14:14:55.552Z | 2024-11-09T14:16:28.578Z |
5504586 | 5504586 | 20241108021931_FGBZu | BG000C | 2024-11-09T14:14:54.118Z | 2024-11-09T14:16:28.576Z |
5504567 | 5504567 | 20241108021558_rEqMH | BG000C | 2024-11-09T14:14:51.716Z | 2024-11-09T14:16:28.571Z |
5504538 | 5504538 | 20241108021343_8GPTp | BG000C | 2024-11-09T14:14:49.494Z | 2024-11-09T14:16:28.564Z |
5504514 | 5504514 | 20241108020857_fNyRq | BG000C | 2024-11-09T14:14:46.901Z | 2024-11-09T14:16:28.558Z |
5504503 | 5504503 | 20241108020822_tAOft | BG000C | 2024-11-09T14:14:45.812Z | 2024-11-09T14:16:28.556Z |
5504427 | 5504427 | 20241108015641_rxv2M | BG000C | 2024-11-09T14:14:37.333Z | 2024-11-09T14:16:28.535Z |
5504335 | 5504335 | 20241108013909_jYxmo | BG000C | 2024-11-09T14:14:27.102Z | 2024-11-09T14:16:28.510Z |
5504316 | 5504316 | 20241108013432_t3dYi | BG000C | 2024-11-09T14:14:24.787Z | 2024-11-09T14:16:28.504Z |
5504283 | 5504283 | 20241108012644_Twi5Y | BG000C | 2024-11-09T14:14:20.596Z | 2024-11-09T14:16:28.495Z |
5504225 | 5504225 | 20241108011741_JywLt | BG000C | 2024-11-09T14:14:15.249Z | 2024-11-09T14:16:28.480Z |
5504222 | 5504222 | 20241108011733_OLyhf | BG000C | 2024-11-09T14:14:14.982Z | 2024-11-09T14:16:28.480Z |
5504207 | 5504207 | 20241108011437_C3VR2 | BG000C | 2024-11-09T14:14:13.480Z | 2024-11-09T14:16:28.476Z |
5504033 | 5504033 | 20241108004203_KjUjO | BG000C | 2024-11-09T14:13:59.356Z | 2024-11-09T14:16:28.430Z |
5504026 | 5504026 | 20241108004137_cfXKh | BG000C | 2024-11-09T14:13:59.091Z | 2024-11-09T14:16:28.429Z |
5503917 | 5503917 | 20241108001418_dfjYF | BG000C | 2024-11-09T14:13:51.319Z | 2024-11-09T14:16:28.394Z |
5503839 | 5503839 | 20241107235633_l0CY2 | BG000C | 2024-11-09T14:13:47.318Z | 2024-11-09T14:16:28.363Z |
5503780 | 5503780 | 20241107234752_AGVqi | BG000C | 2024-11-09T14:13:43.983Z | 2024-11-09T14:16:28.345Z |
5503768 | 5503768 | 20241107234650_5Oebe | BG000C | 2024-11-09T14:13:43.515Z | 2024-11-09T14:16:28.343Z |
5503683 | 5503683 | 20241107232910_dkfxI | BG000C | 2024-11-09T14:13:34.477Z | 2024-11-09T14:16:28.320Z |
5503587 | 5503587 | 20241107225754_jaFU0 | BG000C | 2024-11-09T14:13:21.872Z | 2024-11-09T14:16:28.296Z |
5503568 | 5503568 | 20241107225317_L3ddX | BG000C | 2024-11-09T14:13:18.741Z | 2024-11-09T14:16:28.292Z |
5503546 | 5503546 | 20241107224609_qNnwr | BG000C | 2024-11-09T14:13:16.982Z | 2024-11-09T14:16:28.288Z |
5503544 | 5503544 | 20241107224558_RvrPP | BG000C | 2024-11-09T14:13:16.881Z | 2024-11-09T14:16:28.287Z |
5503525 | 5503525 | 20241107224102_PMgbZ | BG000C | 2024-11-09T14:13:15.216Z | 2024-11-09T14:16:28.283Z |
5503501 | 5503501 | 20241107223547_G4eot | BG000C | 2024-11-09T14:13:12.970Z | 2024-11-09T14:16:28.278Z |
5503468 | 5503468 | 20241107222717_UsPZN | BG000C | 2024-11-09T14:13:08.588Z | 2024-11-09T14:16:28.267Z |
5503454 | 5503454 | 20241107222427_EAKjD | BG000C | 2024-11-09T14:13:06.812Z | 2024-11-09T14:16:28.263Z |
5503425 | 5503425 | 20241107221810_of0Ep | BG000C | 2024-11-09T14:13:02.763Z | 2024-11-09T14:16:28.253Z |
5503381 | 5503381 | 20241107220159_iRyDE | BG000C | 2024-11-09T14:12:57.350Z | 2024-11-09T14:16:28.236Z |
5503346 | 5503346 | 20241107214935_gKIPy | BG000C | 2024-11-09T14:12:51.780Z | 2024-11-09T14:16:28.223Z |
5503336 | 5503336 | 20241107214506_2vUmp | BG000C | 2024-11-09T14:12:50.538Z | 2024-11-09T14:16:28.220Z |
5503218 | 5503218 | 20241107210215_APs2z | BG000C | 2024-11-09T14:12:35.302Z | 2024-11-09T14:16:28.192Z |
5503045 | 5503045 | 20241107203240_BTCbN | BG000C | 2024-11-09T14:12:21.571Z | 2024-11-09T14:16:28.154Z |
5503035 | 5503035 | 20241107203054_oYC28 | BG000C | 2024-11-09T14:12:20.782Z | 2024-11-09T14:16:28.152Z |
5503023 | 5503023 | 20241107202952_UaIWz | BG000C | 2024-11-09T14:12:20.188Z | 2024-11-09T14:16:28.150Z |
5502831 | 5502831 | 20241107195131_vzEHW | BG000C | 2024-11-09T14:12:05.591Z | 2024-11-09T14:16:28.106Z |
5502706 | 5502706 | 20241107193424_shR8z | BG000C | 2024-11-09T14:11:59.123Z | 2024-11-09T14:16:28.081Z |
5502680 | 5502680 | 20241107193136_o6esl | BG000C | 2024-11-09T14:11:57.770Z | 2024-11-09T14:16:28.076Z |
5502565 | 5502565 | 20241107190806_GcA81 | BG000C | 2024-11-09T14:11:44.935Z | 2024-11-09T14:16:28.056Z |
5502527 | 5502527 | 20241107185552_a7BUZ | BG000C | 2024-11-09T14:11:39.307Z | 2024-11-09T14:16:28.048Z |
5502401 | 5502401 | 20241107182349_OFOzX | BG000C | 2024-11-09T14:11:15.913Z | 2024-11-09T14:16:28.021Z |
5502340 | 5502340 | 20241107180920_VhmQ9 | BG000C | 2024-11-09T14:11:12.143Z | 2024-11-09T14:16:28.008Z |
5502289 | 5502289 | 20241107175748_oaOfy | BG000C | 2024-11-09T14:11:08.342Z | 2024-11-09T14:16:27.997Z |
5502165 | 5502165 | 20241107173355_Bp3if | BG000C | 2024-11-09T14:11:00.467Z | 2024-11-09T14:16:27.969Z |
5497593 | 5497593 | 20241107040723_aDL8Z | BG000C | 2024-11-08T14:14:01.293Z | 2024-11-09T14:18:46.908Z |
5497517 | 5497517 | 20241107035254_l6zrZ | BG000C | 2024-11-08T14:13:55.366Z | 2024-11-09T14:18:45.090Z |
5497486 | 5497486 | 20241107034943_fwIMD | BG000C | 2024-11-08T14:13:52.116Z | 2024-11-09T14:18:44.465Z |
5497460 | 5497460 | 20241107034352_9FA02 | BG000C | 2024-11-08T14:13:48.431Z | 2024-11-09T14:18:43.572Z |
5497288 | 5497288 | 20241107031415_95eWB | BG000C | 2024-11-08T14:13:29.996Z | 2024-11-09T14:18:40.085Z |
5497226 | 5497226 | 20241107030020_NnJSN | BG000C | 2024-11-08T14:13:24.420Z | 2024-11-09T14:18:37.679Z |
5497188 | 5497188 | 20241107025402_kGdPO | BG000C | 2024-11-08T14:13:19.462Z | 2024-11-09T14:18:36.692Z |
5497144 | 5497144 | 20241107024920_pYeV4 | BG000C | 2024-11-08T14:13:15.634Z | 2024-11-09T14:18:35.990Z |
5497008 | 5497008 | 20241107022639_7OzdF | BG000C | 2024-11-08T14:13:03.999Z | 2024-11-09T14:18:34.245Z |
5496950 | 5496950 | 20241107021622_VyD3q | BG000C | 2024-11-08T14:13:00.645Z | 2024-11-09T14:18:33.544Z |
5496941 | 5496941 | 20241107021221_nshtZ | BG000C | 2024-11-08T14:13:00.008Z | 2024-11-09T14:18:33.356Z |
5496816 | 5496816 | 20241107014454_3gaPm | BG000C | 2024-11-08T14:12:53.387Z | 2024-11-09T14:18:30.852Z |
5496798 | 5496798 | 20241107014126_S24gi | BG000C | 2024-11-08T14:12:52.142Z | 2024-11-09T14:18:30.427Z |
5496729 | 5496729 | 20241107012616_apOhg | BG000C | 2024-11-08T14:12:48.463Z | 2024-11-09T14:18:29.153Z |
5496687 | 5496687 | 20241107011611_DpW5g | BG000C | 2024-11-08T14:12:41.393Z | 2024-11-09T14:18:27.569Z |
5496643 | 5496643 | 20241107010836_kQxF5 | BG000C | 2024-11-08T14:12:35.964Z | 2024-11-09T14:18:26.880Z |
5496614 | 5496614 | 20241107010313_5naFB | BG000C | 2024-11-08T14:12:31.807Z | 2024-11-09T14:18:26.586Z |
5496585 | 5496585 | 20241107005723_KFl3N | BG000C | 2024-11-08T14:12:28.784Z | 2024-11-09T14:18:26.127Z |
5496546 | 5496546 | 20241107005107_UVHPT | BG000C | 2024-11-08T14:12:22.846Z | 2024-11-09T14:18:24.630Z |
5496497 | 5496497 | 20241107003654_ujoz6 | BG000C | 2024-11-08T14:12:16.320Z | 2024-11-09T14:18:23.331Z |
5496485 | 5496485 | 20241107003455_f5bA2 | BG000C | 2024-11-08T14:12:14.850Z | 2024-11-09T14:18:23.147Z |
5496481 | 5496481 | 20241107003445_Q2kyq | BG000C | 2024-11-08T14:12:14.612Z | 2024-11-09T14:18:23.129Z |
5496452 | 5496452 | 20241107002914_85kZt | BG000C | 2024-11-08T14:12:10.960Z | 2024-11-09T14:18:22.489Z |
5496421 | 5496421 | 20241107002101_gEeJK | BG000C | 2024-11-08T14:12:08.477Z | 2024-11-09T14:18:21.984Z |
5496340 | 5496340 | 20241106235910_Q2IIU | BG000C | 2024-11-08T14:11:59.702Z | 2024-11-09T14:18:20.396Z |
5496336 | 5496336 | 20241106235852_nFAHb | BG000C | 2024-11-08T14:11:59.490Z | 2024-11-09T14:18:20.336Z |
5496213 | 5496213 | 20241106232842_JDobP | BG000C | 2024-11-08T14:11:46.563Z | 2024-11-09T14:18:18.345Z |
5496200 | 5496200 | 20241106232256_1CG3f | BG000C | 2024-11-08T14:11:45.504Z | 2024-11-09T14:18:18.179Z |
5496150 | 5496150 | 20241106230733_O26QC | BG000C | 2024-11-08T14:11:39.300Z | 2024-11-09T14:18:17.070Z |
5496142 | 5496142 | 20241106230642_4ySFE | BG000C | 2024-11-08T14:11:38.574Z | 2024-11-09T14:18:16.961Z |
5496020 | 5496020 | 20241106223858_jZg5l | BG000C | 2024-11-08T14:11:23.943Z | 2024-11-09T14:18:14.470Z |
5495998 | 5495998 | 20241106223352_3wujj | BG000C | 2024-11-08T14:11:20.060Z | 2024-11-09T14:18:14.175Z |
5495986 | 5495986 | 20241106223039_ZD5rY | BG000C | 2024-11-08T14:11:18.564Z | 2024-11-09T14:18:13.980Z |
5495947 | 5495947 | 20241106221902_bGvML | BG000C | 2024-11-08T14:11:12.257Z | 2024-11-09T14:18:12.588Z |
5495883 | 5495883 | 20241106215604_D2PBz | BG000C | 2024-11-08T14:11:03.959Z | 2024-11-09T14:18:10.716Z |
5495877 | 5495877 | 20241106215513_cWEQq | BG000C | 2024-11-08T14:11:03.507Z | 2024-11-09T14:18:10.693Z |
5495860 | 5495860 | 20241106215218_5CaoT | BG000C | 2024-11-08T14:11:01.925Z | 2024-11-09T14:18:10.388Z |
5495820 | 5495820 | 20241106214040_dP3cX | BG000C | 2024-11-08T14:10:56.110Z | 2024-11-09T14:18:09.735Z |
5495564 | 5495564 | 20241106201916_ST2X3 | BG000C | 2024-11-08T14:10:24.085Z | 2024-11-09T14:17:57.864Z |
5495554 | 5495554 | 20241106201754_N1rtn | BG000C | 2024-11-08T14:10:23.556Z | 2024-11-09T14:17:57.645Z |
5495306 | 5495306 | 20241106192109_GQVdJ | BG000C | 2024-11-08T14:09:55.134Z | 2024-11-09T14:17:49.786Z |
5495293 | 5495293 | 20241106191742_CF0hj | BG000C | 2024-11-08T14:09:53.299Z | 2024-11-09T14:17:49.497Z |
5495278 | 5495278 | 20241106191355_01Jr7 | BG000C | 2024-11-08T14:09:50.132Z | 2024-11-09T14:17:48.979Z |
5495165 | 5495165 | 20241106185152_MNI8s | BG000C | 2024-11-08T14:09:30.250Z | 2024-11-09T14:17:44.069Z |
5495012 | 5495012 | 20241106181609_quCLq | BG000C | 2024-11-08T14:09:02.012Z | 2024-11-09T14:17:38.753Z |
5495008 | 5495008 | 20241106181449_wvBBZ | BG000C | 2024-11-08T14:09:01.742Z | 2024-11-09T14:17:38.056Z |
5494972 | 5494972 | 20241106180300_pbE0Z | BG000C | 2024-11-08T14:08:54.475Z | 2024-11-09T14:17:36.592Z |
5494888 | 5494888 | 20241106174656_OTacN | BG000C | 2024-11-08T14:08:45.846Z | 2024-11-09T14:17:33.983Z |
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);