participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,491 rows where station_code = "DE000B" 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 |
---|---|---|---|---|---|
5128491 | 5128491 | 20240917015114_W6V2B | DE000B | 2024-09-19T12:10:38.430Z | 2024-09-19T12:10:38.430Z |
5128449 | 5128449 | 20240917014331_DUpuo | DE000B | 2024-09-19T12:10:34.945Z | 2024-09-19T12:10:34.945Z |
5128415 | 5128415 | 20240917014042_E2muw | DE000B | 2024-09-19T12:10:33.295Z | 2024-09-19T12:10:33.295Z |
5128174 | 5128174 | 20240917010211_3z2dr | DE000B | 2024-09-19T12:10:19.126Z | 2024-09-19T12:10:19.126Z |
5128148 | 5128148 | 20240917005209_SZo9K | DE000B | 2024-09-19T12:10:10.109Z | 2024-09-19T12:10:10.109Z |
5127163 | 5127163 | 20240916203754_GatFc | DE000B | 2024-09-19T12:08:22.504Z | 2024-09-19T12:08:22.504Z |
5126948 | 5126948 | 20240916200115_sZ3jP | DE000B | 2024-09-19T12:07:48.205Z | 2024-09-19T12:07:48.205Z |
5126742 | 5126742 | 20240916185841_C27RO | DE000B | 2024-09-19T12:06:59.623Z | 2024-09-19T12:06:59.623Z |
5120171 | 5120171 | 20240914030322_gsDhS | DE000B | 2024-09-18T12:10:33.557Z | 2024-09-19T12:19:59.535Z |
5116566 | 5116566 | 20240915033153_3XlN3 | DE000B | 2024-09-18T12:07:10.274Z | 2024-09-19T12:19:11.533Z |
5116230 | 5116230 | 20240915031653_DA969 | DE000B | 2024-09-18T12:06:50.126Z | 2024-09-19T12:19:09.920Z |
5116011 | 5116011 | 20240915030340_qZJGe | DE000B | 2024-09-18T12:06:34.284Z | 2024-09-19T12:19:08.197Z |
5115784 | 5115784 | 20240915025336_393oP | DE000B | 2024-09-18T12:06:23.988Z | 2024-09-19T12:19:07.352Z |
5115640 | 5115640 | 20240915024658_cR5HB | DE000B | 2024-09-18T12:06:20.081Z | 2024-09-19T12:19:05.887Z |
5114586 | 5114586 | 20240915015112_u049m | DE000B | 2024-09-18T12:05:23.326Z | 2024-09-19T12:18:59.014Z |
5114516 | 5114516 | 20240915014554_gwQjF | DE000B | 2024-09-18T12:05:20.308Z | 2024-09-19T12:18:58.647Z |
5113581 | 5113581 | 20240915005916_N1xs8 | DE000B | 2024-09-18T12:04:33.338Z | 2024-09-19T12:18:50.501Z |
5113436 | 5113436 | 20240915004946_ibZ97 | DE000B | 2024-09-18T12:04:17.278Z | 2024-09-19T12:18:49.129Z |
5113082 | 5113082 | 20240915001942_ktQ45 | DE000B | 2024-09-18T12:03:55.511Z | 2024-09-19T12:18:46.973Z |
5112756 | 5112756 | 20240914234935_M3oSO | DE000B | 2024-09-18T12:03:28.126Z | 2024-09-19T12:18:44.291Z |
5112388 | 5112388 | 20240914230650_NwTjN | DE000B | 2024-09-18T12:03:02.303Z | 2024-09-19T12:18:40.802Z |
5112284 | 5112284 | 20240914225106_wZgfh | DE000B | 2024-09-18T12:02:58.448Z | 2024-09-19T12:18:40.373Z |
5111959 | 5111959 | 20240914214804_hQmmW | DE000B | 2024-09-18T12:02:33.283Z | 2024-09-19T12:18:35.797Z |
5111777 | 5111777 | 20240914211600_8dG4M | DE000B | 2024-09-18T12:02:16.544Z | 2024-09-19T12:18:33.956Z |
5111469 | 5111469 | 20240914204114_pC9Qa | DE000B | 2024-09-18T12:01:58.312Z | 2024-09-19T12:18:30.616Z |
5111206 | 5111206 | 20240914201038_DK8LV | DE000B | 2024-09-18T12:01:43.319Z | 2024-09-19T12:18:27.414Z |
5111126 | 5111126 | 20240914200336_MS7yM | DE000B | 2024-09-18T12:01:37.245Z | 2024-09-19T12:18:26.894Z |
5110895 | 5110895 | 20240914192019_Zfj9F | DE000B | 2024-09-18T12:01:09.568Z | 2024-09-19T12:18:24.581Z |
5110870 | 5110870 | 20240914191710_KkI5m | DE000B | 2024-09-18T12:01:07.476Z | 2024-09-19T12:18:24.424Z |
5106518 | 5106518 | 20240913032841_UCSLD | DE000B | 2024-09-17T12:12:56.903Z | 2024-09-19T12:20:46.165Z |
5106411 | 5106411 | 20240913032402_NV0pS | DE000B | 2024-09-17T12:12:53.216Z | 2024-09-19T12:20:46.057Z |
5106302 | 5106302 | 20240913031804_p70Da | DE000B | 2024-09-17T12:12:48.894Z | 2024-09-19T12:20:45.760Z |
5106284 | 5106284 | 20240913031658_Vxnl3 | DE000B | 2024-09-17T12:12:47.936Z | 2024-09-19T12:20:45.740Z |
5106010 | 5106010 | 20240913030631_h3UBP | DE000B | 2024-09-17T12:12:37.706Z | 2024-09-19T12:20:45.141Z |
5105787 | 5105787 | 20240913025830_LaNpo | DE000B | 2024-09-17T12:12:29.030Z | 2024-09-19T12:20:44.882Z |
5105622 | 5105622 | 20240913025315_yVQCp | DE000B | 2024-09-17T12:12:23.825Z | 2024-09-19T12:20:44.760Z |
5105550 | 5105550 | 20240913025138_OaBkN | DE000B | 2024-09-17T12:12:21.241Z | 2024-09-19T12:20:44.662Z |
5105153 | 5105153 | 20240913023354_dtBK0 | DE000B | 2024-09-17T12:11:59.671Z | 2024-09-19T12:20:44.010Z |
5105141 | 5105141 | 20240913023221_7w3a7 | DE000B | 2024-09-17T12:11:58.177Z | 2024-09-19T12:20:43.750Z |
5105139 | 5105139 | 20240913023202_oSxji | DE000B | 2024-09-17T12:11:57.706Z | 2024-09-19T12:20:43.747Z |
5105061 | 5105061 | 20240913022848_6a7M7 | DE000B | 2024-09-17T12:11:52.112Z | 2024-09-19T12:20:43.460Z |
5105052 | 5105052 | 20240913022825_LeKnw | DE000B | 2024-09-17T12:11:51.163Z | 2024-09-19T12:20:43.437Z |
5104575 | 5104575 | 20240913021532_T1dSt | DE000B | 2024-09-17T12:11:39.499Z | 2024-09-19T12:20:41.707Z |
5104526 | 5104526 | 20240913021425_n0i2m | DE000B | 2024-09-17T12:11:38.149Z | 2024-09-19T12:20:41.642Z |
5103338 | 5103338 | 20240913012643_uNykN | DE000B | 2024-09-17T12:10:53.311Z | 2024-09-19T12:20:40.071Z |
5102184 | 5102184 | 20240914011127_1wAby | DE000B | 2024-09-17T12:06:53.755Z | 2024-09-19T12:19:52.724Z |
5101101 | 5101101 | 20240914000416_UTpL3 | DE000B | 2024-09-17T12:05:20.433Z | 2024-09-19T12:19:49.782Z |
5099077 | 5099077 | 20240913201901_24845 | DE000B | 2024-09-17T12:02:17.949Z | 2024-09-19T12:19:43.357Z |
5098986 | 5098986 | 20240913200417_kUT37 | DE000B | 2024-09-17T12:02:08.002Z | 2024-09-19T12:19:42.941Z |
5098809 | 5098809 | 20240913193951_U9KFJ | DE000B | 2024-09-17T12:01:40.069Z | 2024-09-19T12:19:41.281Z |
5098662 | 5098662 | 20240913185247_N78n0 | DE000B | 2024-09-17T12:01:15.395Z | 2024-09-19T12:19:39.928Z |
5098660 | 5098660 | 20240913185208_eGQnE | DE000B | 2024-09-17T12:01:15.010Z | 2024-09-19T12:19:39.912Z |
5098148 | 5098148 | 20240913012018_9fMc3 | DE000B | 2024-09-16T12:17:20.874Z | 2024-09-19T12:20:39.727Z |
5093480 | 5093480 | 20240912032348_nFmj9 | DE000B | 2024-09-16T12:14:18.391Z | 2024-09-19T12:21:15.367Z |
5093265 | 5093265 | 20240912031536_tdyKp | DE000B | 2024-09-16T12:14:13.919Z | 2024-09-19T12:21:15.073Z |
5093194 | 5093194 | 20240912031450_kjWtv | DE000B | 2024-09-16T12:14:13.068Z | 2024-09-19T12:21:15.004Z |
5092986 | 5092986 | 20240912030418_P5ehi | DE000B | 2024-09-16T12:14:08.986Z | 2024-09-19T12:21:14.796Z |
5092450 | 5092450 | 20240912024634_WhyaY | DE000B | 2024-09-16T12:13:56.796Z | 2024-09-19T12:21:14.117Z |
5091711 | 5091711 | 20240912021928_ZC3JI | DE000B | 2024-09-16T12:13:19.772Z | 2024-09-19T12:21:13.359Z |
5091555 | 5091555 | 20240912021335_6BY1M | DE000B | 2024-09-16T12:13:10.860Z | 2024-09-19T12:21:13.215Z |
5090318 | 5090318 | 20240912012031_nonSN | DE000B | 2024-09-16T12:12:12.537Z | 2024-09-19T12:21:11.194Z |
5089525 | 5089525 | 20240912004821_r33LA | DE000B | 2024-09-16T12:11:28.488Z | 2024-09-19T12:21:10.024Z |
5089487 | 5089487 | 20240912004542_PCkoZ | DE000B | 2024-09-16T12:11:26.820Z | 2024-09-19T12:21:09.986Z |
5089290 | 5089290 | 20240912003356_YPr0u | DE000B | 2024-09-16T12:11:19.520Z | 2024-09-19T12:21:09.880Z |
5089130 | 5089130 | 20240912002715_cEWgu | DE000B | 2024-09-16T12:11:15.897Z | 2024-09-19T12:21:09.779Z |
5088939 | 5088939 | 20240912001428_udLJq | DE000B | 2024-09-16T12:11:09.824Z | 2024-09-19T12:21:09.627Z |
5087725 | 5087725 | 20240912234116_W546Q | DE000B | 2024-09-16T12:07:20.322Z | 2024-09-19T12:20:35.620Z |
5087701 | 5087701 | 20240912234025_t8ZRF | DE000B | 2024-09-16T12:07:17.464Z | 2024-09-19T12:20:35.592Z |
5087687 | 5087687 | 20240912234008_H3aoS | DE000B | 2024-09-16T12:07:14.769Z | 2024-09-19T12:20:35.559Z |
5087462 | 5087462 | 20240912232826_1UQ0f | DE000B | 2024-09-16T12:06:57.211Z | 2024-09-19T12:20:35.038Z |
5086938 | 5086938 | 20240912225751_5Pn5R | DE000B | 2024-09-16T12:06:15.240Z | 2024-09-19T12:20:33.158Z |
5086865 | 5086865 | 20240912225249_EXQpf | DE000B | 2024-09-16T12:06:10.384Z | 2024-09-19T12:20:32.776Z |
5086400 | 5086400 | 20240912223222_wgpPK | DE000B | 2024-09-16T12:05:41.817Z | 2024-09-19T12:20:31.061Z |
5086086 | 5086086 | 20240912220856_b3Y08 | DE000B | 2024-09-16T12:05:13.248Z | 2024-09-19T12:20:30.154Z |
5085946 | 5085946 | 20240912215906_RuL0B | DE000B | 2024-09-16T12:05:05.063Z | 2024-09-19T12:20:29.813Z |
5085826 | 5085826 | 20240912215325_MiCMU | DE000B | 2024-09-16T12:04:56.948Z | 2024-09-19T12:20:29.636Z |
5085475 | 5085475 | 20240912212223_768Z4 | DE000B | 2024-09-16T12:04:17.929Z | 2024-09-19T12:20:28.746Z |
5085372 | 5085372 | 20240912211510_4kmgG | DE000B | 2024-09-16T12:04:10.821Z | 2024-09-19T12:20:28.525Z |
5085325 | 5085325 | 20240912211024_lBuu2 | DE000B | 2024-09-16T12:04:02.664Z | 2024-09-19T12:20:28.440Z |
5084690 | 5084690 | 20240912200638_FC2YL | DE000B | 2024-09-16T12:02:48.446Z | 2024-09-19T12:20:26.955Z |
5084604 | 5084604 | 20240912195543_U4v8E | DE000B | 2024-09-16T12:02:38.451Z | 2024-09-19T12:20:26.488Z |
5075794 | 5075794 | 20240912000744_7xGAh | DE000B | 2024-09-15T12:10:13.968Z | 2024-09-19T12:21:09.513Z |
5075766 | 5075766 | 20240912000553_g1ccb | DE000B | 2024-09-15T12:10:12.608Z | 2024-09-19T12:21:09.484Z |
5075595 | 5075595 | 20240911235628_dR5du | DE000B | 2024-09-15T12:10:03.612Z | 2024-09-19T12:21:09.319Z |
5075590 | 5075590 | 20240911235612_OL333 | DE000B | 2024-09-15T12:10:03.085Z | 2024-09-19T12:21:09.315Z |
5075489 | 5075489 | 20240911235041_ECTyE | DE000B | 2024-09-15T12:09:52.880Z | 2024-09-19T12:21:09.233Z |
5075383 | 5075383 | 20240911234508_WxjO1 | DE000B | 2024-09-15T12:09:40.693Z | 2024-09-19T12:21:09.181Z |
5074890 | 5074890 | 20240911231422_eIkjG | DE000B | 2024-09-15T12:09:11.584Z | 2024-09-19T12:21:07.888Z |
5074633 | 5074633 | 20240911225059_Gnj6L | DE000B | 2024-09-15T12:08:41.122Z | 2024-09-19T12:21:07.554Z |
5074612 | 5074612 | 20240911224918_A5pMW | DE000B | 2024-09-15T12:08:39.735Z | 2024-09-19T12:21:07.533Z |
5074497 | 5074497 | 20240911224211_vkq1T | DE000B | 2024-09-15T12:08:34.868Z | 2024-09-19T12:21:07.367Z |
5074405 | 5074405 | 20240911223746_Iz7Nm | DE000B | 2024-09-15T12:08:30.957Z | 2024-09-19T12:21:07.227Z |
5074352 | 5074352 | 20240911223309_zzmC5 | DE000B | 2024-09-15T12:08:26.156Z | 2024-09-19T12:21:07.132Z |
5074092 | 5074092 | 20240911221305_corwT | DE000B | 2024-09-15T12:07:57.812Z | 2024-09-19T12:21:06.883Z |
5074090 | 5074090 | 20240911221231_zAtEB | DE000B | 2024-09-15T12:07:57.423Z | 2024-09-19T12:21:06.882Z |
5073963 | 5073963 | 20240911215848_2Jc7e | DE000B | 2024-09-15T12:07:46.985Z | 2024-09-19T12:21:06.478Z |
5073839 | 5073839 | 20240911215052_9cTLf | DE000B | 2024-09-15T12:07:40.564Z | 2024-09-19T12:21:06.306Z |
5072648 | 5072648 | 20240911203441_y5s2e | DE000B | 2024-09-15T12:05:57.516Z | 2024-09-19T12:21:04.575Z |
5072644 | 5072644 | 20240911203423_lX2ba | DE000B | 2024-09-15T12:05:56.702Z | 2024-09-19T12:21:04.571Z |
5072507 | 5072507 | 20240911201635_2E13W | DE000B | 2024-09-15T12:05:31.689Z | 2024-09-19T12:21:04.282Z |
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);