participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
252 rows where station_code = "DE000V" 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 |
---|---|---|---|---|---|
5132023 | 5132023 | 20240915224857_386Lh | DE000V | 2024-09-19T12:15:44.078Z | 2024-09-20T12:12:54.808Z |
5131816 | 5131816 | 20240915212012_a7O6b | DE000V | 2024-09-19T12:15:23.502Z | 2024-09-20T12:12:45.608Z |
5131770 | 5131770 | 20240915210420_tOpa1 | DE000V | 2024-09-19T12:15:19.946Z | 2024-09-20T12:12:41.952Z |
5129182 | 5129182 | 20240917033337_4bKyB | DE000V | 2024-09-19T12:11:22.352Z | 2024-09-20T12:11:17.077Z |
5129082 | 5129082 | 20240917031511_BTqNn | DE000V | 2024-09-19T12:11:14.485Z | 2024-09-20T12:11:13.626Z |
5127774 | 5127774 | 20240916232439_71t2E | DE000V | 2024-09-19T12:09:37.322Z | 2024-09-20T12:10:31.248Z |
5127650 | 5127650 | 20240916224506_MQ1VS | DE000V | 2024-09-19T12:09:29.158Z | 2024-09-20T12:10:25.318Z |
5127541 | 5127541 | 20240916222116_fF3A7 | DE000V | 2024-09-19T12:09:19.946Z | 2024-09-20T12:10:21.956Z |
5127461 | 5127461 | 20240916215505_DNjgq | DE000V | 2024-09-19T12:09:10.734Z | 2024-09-20T12:10:19.927Z |
5120300 | 5120300 | 20240914031354_WuIwN | DE000V | 2024-09-18T12:10:36.777Z | 2024-09-20T12:19:00.701Z |
5119340 | 5119340 | 20240914022605_PUH7b | DE000V | 2024-09-18T12:10:20.299Z | 2024-09-20T12:18:57.509Z |
5116266 | 5116266 | 20240915031949_m3zjw | DE000V | 2024-09-18T12:06:53.387Z | 2024-09-20T12:16:44.955Z |
5115855 | 5115855 | 20240915025623_aAtNh | DE000V | 2024-09-18T12:06:29.132Z | 2024-09-20T12:16:38.180Z |
5115727 | 5115727 | 20240915025102_NxguA | DE000V | 2024-09-18T12:06:22.132Z | 2024-09-20T12:16:35.101Z |
5115468 | 5115468 | 20240915024009_WjlB3 | DE000V | 2024-09-18T12:06:15.687Z | 2024-09-20T12:16:31.897Z |
5114136 | 5114136 | 20240915012837_lBXM2 | DE000V | 2024-09-18T12:05:03.646Z | 2024-09-20T12:16:09.795Z |
5112814 | 5112814 | 20240914235728_whozE | DE000V | 2024-09-18T12:03:38.771Z | 2024-09-20T12:15:38.937Z |
5112801 | 5112801 | 20240914235647_V2N5Q | DE000V | 2024-09-18T12:03:36.137Z | 2024-09-20T12:15:38.554Z |
5112454 | 5112454 | 20240914231719_muq2e | DE000V | 2024-09-18T12:03:08.233Z | 2024-09-20T12:15:30.869Z |
5111865 | 5111865 | 20240914212757_jYXLa | DE000V | 2024-09-18T12:02:25.692Z | 2024-09-20T12:15:17.530Z |
5111862 | 5111862 | 20240914212621_6k2Vc | DE000V | 2024-09-18T12:02:24.660Z | 2024-09-20T12:15:17.430Z |
5111573 | 5111573 | 20240914204927_pYpEg | DE000V | 2024-09-18T12:02:04.077Z | 2024-09-20T12:15:12.661Z |
5106751 | 5106751 | 20240913033321_5ked2 | DE000V | 2024-09-17T12:13:00.471Z | 2024-09-20T12:20:42.431Z |
5106320 | 5106320 | 20240913031856_J8H5g | DE000V | 2024-09-17T12:12:49.937Z | 2024-09-20T12:20:41.120Z |
5104035 | 5104035 | 20240913014938_lK2d9 | DE000V | 2024-09-17T12:11:23.264Z | 2024-09-20T12:20:32.873Z |
5102451 | 5102451 | 20240914012632_Gc3VZ | DE000V | 2024-09-17T12:07:12.942Z | 2024-09-20T12:18:53.538Z |
5101414 | 5101414 | 20240914002531_NeE3e | DE000V | 2024-09-17T12:05:44.508Z | 2024-09-20T12:18:45.465Z |
5100969 | 5100969 | 20240913235522_Gqrz3 | DE000V | 2024-09-17T12:05:12.927Z | 2024-09-20T12:18:38.925Z |
5099393 | 5099393 | 20240913210757_V04xI | DE000V | 2024-09-17T12:02:52.593Z | 2024-09-20T12:18:19.701Z |
5099094 | 5099094 | 20240913202300_oeL1w | DE000V | 2024-09-17T12:02:19.935Z | 2024-09-20T12:18:14.453Z |
5099045 | 5099045 | 20240913201534_c295y | DE000V | 2024-09-17T12:02:14.133Z | 2024-09-20T12:18:13.362Z |
5098737 | 5098737 | 20240913191558_kf27E | DE000V | 2024-09-17T12:01:27.939Z | 2024-09-20T12:18:06.549Z |
5097483 | 5097483 | 20240913005012_Vqv7g | DE000V | 2024-09-16T12:17:12.963Z | 2024-09-20T12:20:26.164Z |
5093455 | 5093455 | 20240912032200_P2pEh | DE000V | 2024-09-16T12:14:17.239Z | 2024-09-20T12:21:53.452Z |
5093094 | 5093094 | 20240912031059_LDP1l | DE000V | 2024-09-16T12:14:11.415Z | 2024-09-20T12:21:52.807Z |
5093045 | 5093045 | 20240912030901_iftFA | DE000V | 2024-09-16T12:14:10.620Z | 2024-09-20T12:21:52.687Z |
5089863 | 5089863 | 20240912010028_qpPNp | DE000V | 2024-09-16T12:11:46.842Z | 2024-09-20T12:21:43.972Z |
5089371 | 5089371 | 20240912003813_x5VKV | DE000V | 2024-09-16T12:11:22.004Z | 2024-09-20T12:21:42.031Z |
5088115 | 5088115 | 20240912235638_x1R47 | DE000V | 2024-09-16T12:07:44.161Z | 2024-09-20T12:20:20.478Z |
5086268 | 5086268 | 20240912222248_n3zE6 | DE000V | 2024-09-16T12:05:26.325Z | 2024-09-20T12:20:10.465Z |
5085956 | 5085956 | 20240912215933_3tIAl | DE000V | 2024-09-16T12:05:06.025Z | 2024-09-20T12:20:08.731Z |
5085647 | 5085647 | 20240912213912_a5oSU | DE000V | 2024-09-16T12:04:33.269Z | 2024-09-20T12:20:06.570Z |
5085365 | 5085365 | 20240912211428_RrLxA | DE000V | 2024-09-16T12:04:09.612Z | 2024-09-20T12:20:03.763Z |
5085323 | 5085323 | 20240912211005_kSAZS | DE000V | 2024-09-16T12:04:01.642Z | 2024-09-20T12:20:03.501Z |
5085165 | 5085165 | 20240912205405_mYdbf | DE000V | 2024-09-16T12:03:38.269Z | 2024-09-20T12:20:02.414Z |
5084946 | 5084946 | 20240912203523_53QPz | DE000V | 2024-09-16T12:03:18.947Z | 2024-09-20T12:20:00.252Z |
5084643 | 5084643 | 20240912200114_qbnJn | DE000V | 2024-09-16T12:02:43.112Z | 2024-09-20T12:19:57.166Z |
5084363 | 5084363 | 20240912192816_xhej8 | DE000V | 2024-09-16T12:01:57.681Z | 2024-09-20T12:19:53.215Z |
5075564 | 5075564 | 20240911235536_V2pi3 | DE000V | 2024-09-15T12:10:01.716Z | 2024-09-20T12:21:40.354Z |
5074875 | 5074875 | 20240911231159_W9Dp2 | DE000V | 2024-09-15T12:09:08.226Z | 2024-09-20T12:21:37.181Z |
5074417 | 5074417 | 20240911223800_2Gq2f | DE000V | 2024-09-15T12:08:31.909Z | 2024-09-20T12:21:36.135Z |
5074154 | 5074154 | 20240911222047_cug0q | DE000V | 2024-09-15T12:08:04.305Z | 2024-09-20T12:21:35.496Z |
5074152 | 5074152 | 20240911222010_UngR9 | DE000V | 2024-09-15T12:08:03.524Z | 2024-09-20T12:21:35.487Z |
5073076 | 5073076 | 20240911205936_Vzljp | DE000V | 2024-09-15T12:06:40.060Z | 2024-09-20T12:21:31.556Z |
5054519 | 5054519 | 20240908030415_rzBzU | DE000V | 2024-09-13T12:16:45.785Z | 2024-09-16T12:21:15.879Z |
5054517 | 5054517 | 20240908030345_U6bAM | DE000V | 2024-09-13T12:16:45.753Z | 2024-09-16T12:21:15.875Z |
5054505 | 5054505 | 20240908030303_TOHGk | DE000V | 2024-09-13T12:16:45.015Z | 2024-09-16T12:21:15.805Z |
5054436 | 5054436 | 20240908025007_k63UQ | DE000V | 2024-09-13T12:16:41.144Z | 2024-09-16T12:21:15.552Z |
5054399 | 5054399 | 20240908024635_b428u | DE000V | 2024-09-13T12:16:40.143Z | 2024-09-16T12:21:15.452Z |
5054169 | 5054169 | 20240908021842_RxXp1 | DE000V | 2024-09-13T12:16:32.180Z | 2024-09-16T12:21:14.185Z |
5040167 | 5040167 | 20240906030839_ZbdoW | DE000V | 2024-09-12T12:16:00.840Z | 2024-09-14T12:23:08.022Z |
5039976 | 5039976 | 20240906023915_pPtBu | DE000V | 2024-09-12T12:15:53.620Z | 2024-09-14T12:23:06.304Z |
5039297 | 5039297 | 20240906001459_6DiMY | DE000V | 2024-09-12T12:15:25.479Z | 2024-09-14T12:23:01.310Z |
5039147 | 5039147 | 20240905233146_NnsMS | DE000V | 2024-09-12T12:15:17.386Z | 2024-09-14T12:23:00.450Z |
5038706 | 5038706 | 20240905212839_wMA6f | DE000V | 2024-09-12T12:14:55.495Z | 2024-09-14T12:22:57.289Z |
5038421 | 5038421 | 20240905201034_Gdxr9 | DE000V | 2024-09-12T12:14:39.377Z | 2024-09-14T12:22:55.986Z |
5033612 | 5033612 | 20240907031725_2dYcB | DE000V | 2024-09-12T12:09:44.977Z | 2024-09-15T12:21:30.705Z |
5031685 | 5031685 | 20240906230015_4fjK7 | DE000V | 2024-09-12T12:05:25.591Z | 2024-09-15T12:21:23.881Z |
5031158 | 5031158 | 20240906204247_VU6bC | DE000V | 2024-09-12T12:04:04.890Z | 2024-09-15T12:21:21.598Z |
5031141 | 5031141 | 20240906203709_VwVb8 | DE000V | 2024-09-12T12:04:01.389Z | 2024-09-15T12:21:21.545Z |
5026338 | 5026338 | 20240905030639_z49le | DE000V | 2024-09-11T12:12:17.903Z | 2024-09-13T12:19:57.692Z |
5026284 | 5026284 | 20240905025718_2ERy5 | DE000V | 2024-09-11T12:12:12.934Z | 2024-09-13T12:19:57.522Z |
5026216 | 5026216 | 20240905024055_PUBjy | DE000V | 2024-09-11T12:12:05.399Z | 2024-09-13T12:19:57.183Z |
5026144 | 5026144 | 20240905022317_irM2Y | DE000V | 2024-09-11T12:11:58.717Z | 2024-09-13T12:19:56.957Z |
5026068 | 5026068 | 20240905021155_Npap6 | DE000V | 2024-09-11T12:11:51.898Z | 2024-09-13T12:19:56.721Z |
5026016 | 5026016 | 20240905015949_3IDT3 | DE000V | 2024-09-11T12:11:44.635Z | 2024-09-13T12:19:56.576Z |
5025798 | 5025798 | 20240905011815_GeIoH | DE000V | 2024-09-11T12:11:05.414Z | 2024-09-13T12:19:55.658Z |
5025791 | 5025791 | 20240905011740_VtIlE | DE000V | 2024-09-11T12:11:03.365Z | 2024-09-13T12:19:55.655Z |
5025734 | 5025734 | 20240905010238_urP8A | DE000V | 2024-09-11T12:10:54.457Z | 2024-09-13T12:19:55.294Z |
5025714 | 5025714 | 20240905005930_b98Gv | DE000V | 2024-09-11T12:10:50.737Z | 2024-09-13T12:19:55.241Z |
5025691 | 5025691 | 20240905005716_W4U0x | DE000V | 2024-09-11T12:10:47.236Z | 2024-09-13T12:19:55.201Z |
5025616 | 5025616 | 20240906022947_ibjYW | DE000V | 2024-09-11T12:06:58.468Z | 2024-09-14T12:23:06.091Z |
5025603 | 5025603 | 20240906022746_oClSM | DE000V | 2024-09-11T12:06:56.141Z | 2024-09-14T12:23:05.840Z |
5025320 | 5025320 | 20240906014715_GGbUd | DE000V | 2024-09-11T12:06:13.628Z | 2024-09-14T12:23:03.904Z |
5024923 | 5024923 | 20240906001459_Elqpd | DE000V | 2024-09-11T12:05:11.646Z | 2024-09-11T12:16:32.384Z |
5024773 | 5024773 | 20240905234157_PloHx | DE000V | 2024-09-11T12:04:43.779Z | 2024-09-14T12:23:00.574Z |
5024769 | 5024769 | 20240905233914_HsFzO | DE000V | 2024-09-11T12:04:42.903Z | 2024-09-14T12:23:00.558Z |
5024746 | 5024746 | 20240905233146_0Yymn | DE000V | 2024-09-11T12:04:40.282Z | 2024-09-14T12:23:00.450Z |
5024617 | 5024617 | 20240905230940_N0V3h | DE000V | 2024-09-11T12:04:15.652Z | 2024-09-14T12:22:59.887Z |
5024276 | 5024276 | 20240905212839_AzLsP | DE000V | 2024-09-11T12:03:12.641Z | 2024-09-14T12:22:57.293Z |
5020794 | 5020794 | 20240905030639_GZbU0 | DE000V | 2024-09-10T12:15:01.619Z | 2024-09-10T12:16:55.243Z |
5020734 | 5020734 | 20240905025718_Jj3zx | DE000V | 2024-09-10T12:14:59.105Z | 2024-09-10T12:16:55.229Z |
5020660 | 5020660 | 20240905024055_yVNKi | DE000V | 2024-09-10T12:14:55.077Z | 2024-09-10T12:16:55.209Z |
5020579 | 5020579 | 20240905022317_iIwrQ | DE000V | 2024-09-10T12:14:45.438Z | 2024-09-10T12:16:55.185Z |
5020506 | 5020506 | 20240905021155_l7g16 | DE000V | 2024-09-10T12:14:36.227Z | 2024-09-10T12:16:55.166Z |
5020453 | 5020453 | 20240905015949_eSeAQ | DE000V | 2024-09-10T12:14:29.484Z | 2024-09-10T12:16:55.153Z |
5020227 | 5020227 | 20240905011815_bcrHc | DE000V | 2024-09-10T12:14:08.416Z | 2024-09-10T12:16:55.103Z |
5020220 | 5020220 | 20240905011740_b2AlZ | DE000V | 2024-09-10T12:14:08.042Z | 2024-09-10T12:16:55.102Z |
5020151 | 5020151 | 20240905010238_BHh3y | DE000V | 2024-09-10T12:14:00.533Z | 2024-09-10T12:16:55.083Z |
5020131 | 5020131 | 20240905005930_4UqsI | DE000V | 2024-09-10T12:13:57.903Z | 2024-09-10T12:16:55.078Z |
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);