participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,764 rows where station_code = "BE000Q" 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 |
---|---|---|---|---|---|
5482959 | 5482959 | 20241104234149_0wZu2 | BE000Q | 2024-11-06T14:14:31.476Z | 2024-11-08T14:18:31.385Z |
5482917 | 5482917 | 20241104233337_Z26T4 | BE000Q | 2024-11-06T14:14:19.405Z | 2024-11-08T14:18:30.513Z |
5482887 | 5482887 | 20241104233000_a6xC3 | BE000Q | 2024-11-06T14:14:15.471Z | 2024-11-08T14:18:30.182Z |
5481340 | 5481340 | 20241104170741_l1kLs | BE000Q | 2024-11-06T14:10:06.896Z | 2024-11-08T14:17:59.564Z |
5475878 | 5475878 | 20241103214439_qS2ZE | BE000Q | 2024-11-05T14:14:29.058Z | 2024-11-08T14:19:46.046Z |
5475722 | 5475722 | 20241103210924_LYnOS | BE000Q | 2024-11-05T14:14:03.441Z | 2024-11-08T14:19:43.115Z |
5475692 | 5475692 | 20241103210236_qE3m0 | BE000Q | 2024-11-05T14:14:01.404Z | 2024-11-08T14:19:42.873Z |
5475666 | 5475666 | 20241103205652_BmwIp | BE000Q | 2024-11-05T14:13:58.164Z | 2024-11-08T14:19:42.582Z |
5475576 | 5475576 | 20241103203959_8e8r3 | BE000Q | 2024-11-05T14:13:50.593Z | 2024-11-08T14:19:41.701Z |
5475567 | 5475567 | 20241103203632_jgTPl | BE000Q | 2024-11-05T14:13:49.702Z | 2024-11-08T14:19:41.459Z |
5475545 | 5475545 | 20241103203211_8o3qy | BE000Q | 2024-11-05T14:13:47.611Z | 2024-11-08T14:19:41.344Z |
5475491 | 5475491 | 20241103201616_UICkm | BE000Q | 2024-11-05T14:13:43.798Z | 2024-11-08T14:19:40.851Z |
5475487 | 5475487 | 20241103201507_GIY02 | BE000Q | 2024-11-05T14:13:43.579Z | 2024-11-08T14:19:40.796Z |
5475475 | 5475475 | 20241103201220_VpA6V | BE000Q | 2024-11-05T14:13:42.786Z | 2024-11-08T14:19:40.723Z |
5475452 | 5475452 | 20241103200827_41dOs | BE000Q | 2024-11-05T14:13:40.457Z | 2024-11-08T14:19:40.058Z |
5475249 | 5475249 | 20241103193445_4skHv | BE000Q | 2024-11-05T14:12:53.487Z | 2024-11-08T14:19:37.943Z |
5475234 | 5475234 | 20241103193348_RZPf8 | BE000Q | 2024-11-05T14:12:49.870Z | 2024-11-08T14:19:37.731Z |
5475224 | 5475224 | 20241103193308_6WJ3d | BE000Q | 2024-11-05T14:12:47.912Z | 2024-11-08T14:19:37.668Z |
5475147 | 5475147 | 20241103191707_4JsxP | BE000Q | 2024-11-05T14:12:36.579Z | 2024-11-08T14:19:36.654Z |
5475134 | 5475134 | 20241103191314_3ei4D | BE000Q | 2024-11-05T14:12:35.669Z | 2024-11-08T14:19:36.454Z |
5475032 | 5475032 | 20241103185240_qkV4O | BE000Q | 2024-11-05T14:12:25.997Z | 2024-11-08T14:19:34.867Z |
5474931 | 5474931 | 20241103183826_BFQH3 | BE000Q | 2024-11-05T14:12:17.723Z | 2024-11-08T14:19:33.122Z |
5474852 | 5474852 | 20241103182544_7Ozgy | BE000Q | 2024-11-05T14:12:10.523Z | 2024-11-08T14:19:32.018Z |
5474741 | 5474741 | 20241103180853_JAfZ3 | BE000Q | 2024-11-05T14:11:49.676Z | 2024-11-08T14:19:29.872Z |
5474680 | 5474680 | 20241103175843_t4zPC | BE000Q | 2024-11-05T14:11:33.951Z | 2024-11-08T14:19:29.078Z |
5474623 | 5474623 | 20241103174946_qbPtg | BE000Q | 2024-11-05T14:11:24.019Z | 2024-11-08T14:19:28.341Z |
5474569 | 5474569 | 20241103173939_vGUGZ | BE000Q | 2024-11-05T14:11:17.428Z | 2024-11-08T14:19:27.713Z |
5454777 | 5454777 | 20241031051341_2Pdb2 | BE000Q | 2024-11-02T12:23:22.520Z | 2024-11-08T14:23:25.625Z |
5454537 | 5454537 | 20241031043631_NJ2PZ | BE000Q | 2024-11-02T12:23:10.930Z | 2024-11-08T14:23:23.755Z |
5454505 | 5454505 | 20241031043120_CJSo7 | BE000Q | 2024-11-02T12:23:08.949Z | 2024-11-08T14:23:23.432Z |
5454482 | 5454482 | 20241031042817_nn7rW | BE000Q | 2024-11-02T12:23:07.212Z | 2024-11-08T14:23:23.152Z |
5454476 | 5454476 | 20241031042752_42xBI | BE000Q | 2024-11-02T12:23:07.137Z | 2024-11-08T14:23:23.136Z |
5454455 | 5454455 | 20241031042520_CQq2h | BE000Q | 2024-11-02T12:23:06.480Z | 2024-11-08T14:23:23.068Z |
5454197 | 5454197 | 20241031035522_l0aMG | BE000Q | 2024-11-02T12:22:54.301Z | 2024-11-08T14:23:21.228Z |
5454118 | 5454118 | 20241031034419_KMgGK | BE000Q | 2024-11-02T12:22:51.426Z | 2024-11-08T14:23:20.624Z |
5440517 | 5440517 | 20241030222247_Yf3y5 | BE000Q | 2024-11-01T12:15:34.351Z | 2024-11-08T14:23:09.787Z |
5440423 | 5440423 | 20241030220951_YxfFl | BE000Q | 2024-11-01T12:15:30.037Z | 2024-11-08T14:23:09.412Z |
5440379 | 5440379 | 20241030220452_fiNFy | BE000Q | 2024-11-01T12:15:27.825Z | 2024-11-08T14:23:09.289Z |
5440373 | 5440373 | 20241030220348_xoUwX | BE000Q | 2024-11-01T12:15:27.367Z | 2024-11-08T14:23:09.232Z |
5440226 | 5440226 | 20241030214445_PwJEJ | BE000Q | 2024-11-01T12:15:02.314Z | 2024-11-08T14:23:08.055Z |
5440191 | 5440191 | 20241030213935_Z09Bf | BE000Q | 2024-11-01T12:14:56.404Z | 2024-11-08T14:23:07.688Z |
5440149 | 5440149 | 20241030213034_CYD6Z | BE000Q | 2024-11-01T12:14:54.314Z | 2024-11-08T14:23:07.602Z |
5440085 | 5440085 | 20241030212152_BWJG6 | BE000Q | 2024-11-01T12:14:49.276Z | 2024-11-08T14:23:07.298Z |
5440064 | 5440064 | 20241030212017_mzdIn | BE000Q | 2024-11-01T12:14:48.036Z | 2024-11-08T14:23:07.167Z |
5439993 | 5439993 | 20241030210406_6TdKg | BE000Q | 2024-11-01T12:14:43.292Z | 2024-11-08T14:23:06.617Z |
5439986 | 5439986 | 20241030210154_TTaIR | BE000Q | 2024-11-01T12:14:42.816Z | 2024-11-08T14:23:06.593Z |
5439969 | 5439969 | 20241030205849_36Lsl | BE000Q | 2024-11-01T12:14:41.641Z | 2024-11-08T14:23:06.584Z |
5439963 | 5439963 | 20241030205802_8Y933 | BE000Q | 2024-11-01T12:14:40.953Z | 2024-11-08T14:23:06.576Z |
5439946 | 5439946 | 20241030205207_N7WRg | BE000Q | 2024-11-01T12:14:39.716Z | 2024-11-08T14:23:06.451Z |
5439855 | 5439855 | 20241030203855_m83BN | BE000Q | 2024-11-01T12:14:33.823Z | 2024-11-08T14:23:05.906Z |
5439750 | 5439750 | 20241030202754_c34sg | BE000Q | 2024-11-01T12:14:24.764Z | 2024-11-08T14:23:05.543Z |
5439649 | 5439649 | 20241030201630_DPsSW | BE000Q | 2024-11-01T12:14:06.438Z | 2024-11-08T14:23:04.525Z |
5439548 | 5439548 | 20241030200602_5OmIP | BE000Q | 2024-11-01T12:13:58.439Z | 2024-11-08T14:23:04.088Z |
5439263 | 5439263 | 20241030193509_aoQE3 | BE000Q | 2024-11-01T12:13:24.743Z | 2024-11-08T14:23:02.772Z |
5439260 | 5439260 | 20241030193422_JOZg4 | BE000Q | 2024-11-01T12:13:23.408Z | 2024-11-08T14:23:02.746Z |
5430923 | 5430923 | 20241029000510_PDF2Z | BE000Q | 2024-10-31T12:19:18.649Z | 2024-11-06T14:27:22.275Z |
5420432 | 5420432 | 20241028024158_cstY5 | BE000Q | 2024-10-30T12:18:51.290Z | 2024-11-05T14:27:15.407Z |
5418839 | 5418839 | 20241027220630_Guk1H | BE000Q | 2024-10-30T12:16:21.205Z | 2024-11-05T14:27:11.414Z |
5418632 | 5418632 | 20241027212621_t6n1C | BE000Q | 2024-10-30T12:15:54.937Z | 2024-11-05T14:27:10.868Z |
5418555 | 5418555 | 20241027211028_S494b | BE000Q | 2024-10-30T12:15:49.675Z | 2024-11-05T14:27:10.560Z |
5418513 | 5418513 | 20241027210254_arER8 | BE000Q | 2024-10-30T12:15:46.877Z | 2024-11-05T14:27:10.346Z |
5418477 | 5418477 | 20241027205457_V4C0w | BE000Q | 2024-10-30T12:15:43.758Z | 2024-11-05T14:27:10.158Z |
5418353 | 5418353 | 20241027202857_lFQhp | BE000Q | 2024-10-30T12:15:34.884Z | 2024-11-05T14:27:09.833Z |
5418101 | 5418101 | 20241027195509_8WBVB | BE000Q | 2024-10-30T12:14:53.028Z | 2024-11-05T14:27:09.032Z |
5417850 | 5417850 | 20241027192147_IbekQ | BE000Q | 2024-10-30T12:14:32.685Z | 2024-11-05T14:27:08.434Z |
5417667 | 5417667 | 20241027185937_5euCc | BE000Q | 2024-10-30T12:14:09.444Z | 2024-11-05T14:27:08.066Z |
5417652 | 5417652 | 20241027185814_FIHRZ | BE000Q | 2024-10-30T12:14:07.216Z | 2024-11-05T14:27:08.034Z |
5417638 | 5417638 | 20241027185629_Yrwjd | BE000Q | 2024-10-30T12:14:04.516Z | 2024-11-05T14:27:07.865Z |
5417507 | 5417507 | 20241027183943_ylq5w | BE000Q | 2024-10-30T12:13:45.496Z | 2024-11-05T14:27:07.428Z |
5417245 | 5417245 | 20241027180043_RyLTB | BE000Q | 2024-10-30T12:13:24.717Z | 2024-11-05T14:27:06.837Z |
5405098 | 5405098 | 20241027001315_n0rGx | BE000Q | 2024-10-29T12:12:27.013Z | 2024-11-04T14:28:52.676Z |
5405020 | 5405020 | 20241027000927_MyO8i | BE000Q | 2024-10-29T12:12:17.537Z | 2024-11-04T14:28:52.595Z |
5404839 | 5404839 | 20241026235601_UVSXb | BE000Q | 2024-10-29T12:12:01.370Z | 2024-11-04T14:28:52.178Z |
5402360 | 5402360 | 20241026192223_0Ur1n | BE000Q | 2024-10-29T12:07:05.143Z | 2024-11-04T14:28:43.965Z |
5402302 | 5402302 | 20241026191341_q9lTs | BE000Q | 2024-10-29T12:06:57.979Z | 2024-11-04T14:28:43.652Z |
5402271 | 5402271 | 20241026190753_8B7A1 | BE000Q | 2024-10-29T12:06:49.293Z | 2024-11-04T14:28:43.440Z |
5402130 | 5402130 | 20241026184721_8Coz0 | BE000Q | 2024-10-29T12:06:29.579Z | 2024-11-04T14:28:42.440Z |
5402039 | 5402039 | 20241026183232_2q41e | BE000Q | 2024-10-29T12:06:07.684Z | 2024-11-04T14:28:41.786Z |
5402024 | 5402024 | 20241026182629_ppp6t | BE000Q | 2024-10-29T12:06:05.817Z | 2024-11-04T14:28:41.634Z |
5401980 | 5401980 | 20241026181540_pX23N | BE000Q | 2024-10-29T12:05:58.016Z | 2024-11-04T14:28:41.245Z |
5401938 | 5401938 | 20241026181003_42Ivg | BE000Q | 2024-10-29T12:05:52.606Z | 2024-11-04T14:28:41.085Z |
5401878 | 5401878 | 20241026175731_8ENRN | BE000Q | 2024-10-29T12:05:41.749Z | 2024-11-04T14:28:40.619Z |
5401864 | 5401864 | 20241026175359_2KWKB | BE000Q | 2024-10-29T12:05:37.570Z | 2024-11-04T14:28:40.344Z |
5401841 | 5401841 | 20241026174408_ViOrg | BE000Q | 2024-10-29T12:05:28.740Z | 2024-11-04T14:28:39.751Z |
5401829 | 5401829 | 20241026174054_fKisP | BE000Q | 2024-10-29T12:05:26.849Z | 2024-11-04T14:28:39.719Z |
5401819 | 5401819 | 20241026173738_f9EXS | BE000Q | 2024-10-29T12:05:25.236Z | 2024-11-04T14:28:39.594Z |
5401797 | 5401797 | 20241026173056_i0xlC | BE000Q | 2024-10-29T12:05:21.245Z | 2024-11-04T14:28:39.231Z |
5399437 | 5399437 | 20241026041827_PPgTd | BE000Q | 2024-10-28T12:19:59.474Z | 2024-11-03T14:27:39.720Z |
5399380 | 5399380 | 20241026041422_ifhAr | BE000Q | 2024-10-28T12:19:57.602Z | 2024-11-03T14:27:39.579Z |
5399378 | 5399378 | 20241026041414_18hv8 | BE000Q | 2024-10-28T12:19:57.159Z | 2024-11-03T14:27:39.577Z |
5399361 | 5399361 | 20241026041333_y3UGN | BE000Q | 2024-10-28T12:19:55.728Z | 2024-11-03T14:27:39.538Z |
5399334 | 5399334 | 20241026041113_jMiFM | BE000Q | 2024-10-28T12:19:55.103Z | 2024-11-03T14:27:39.491Z |
5399292 | 5399292 | 20241026040837_Rzt31 | BE000Q | 2024-10-28T12:19:53.407Z | 2024-11-03T14:27:39.348Z |
5399257 | 5399257 | 20241026040559_CdqMb | BE000Q | 2024-10-28T12:19:52.641Z | 2024-11-03T14:27:39.286Z |
5399232 | 5399232 | 20241026040352_CSfDU | BE000Q | 2024-10-28T12:19:52.261Z | 2024-11-03T14:27:39.273Z |
5399160 | 5399160 | 20241026035735_8K0Yn | BE000Q | 2024-10-28T12:19:50.271Z | 2024-11-03T14:27:39.162Z |
5399029 | 5399029 | 20241026034531_DZJak | BE000Q | 2024-10-28T12:19:44.858Z | 2024-11-03T14:27:38.909Z |
5398966 | 5398966 | 20241026034204_3Wx57 | BE000Q | 2024-10-28T12:19:41.893Z | 2024-11-03T14:27:38.748Z |
5398891 | 5398891 | 20241026033634_5deDM | BE000Q | 2024-10-28T12:19:39.326Z | 2024-11-03T14:27:38.378Z |
5398854 | 5398854 | 20241026033330_Bzs1u | BE000Q | 2024-10-28T12:19:37.366Z | 2024-11-03T14:27:38.302Z |
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);