participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,015 rows where station_code = "FR0003" 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 |
---|---|---|---|---|---|
5125010 | 5125010 | 20240917232354_tX3s3 | FR0003 | 2024-09-19T12:01:56.095Z | 2024-09-19T12:06:41.961Z |
5120500 | 5120500 | 20240914032537_dIVPC | FR0003 | 2024-09-18T12:10:42.215Z | 2024-09-19T12:20:00.505Z |
5119305 | 5119305 | 20240914022236_hUiEw | FR0003 | 2024-09-18T12:10:19.628Z | 2024-09-19T12:19:57.658Z |
5111987 | 5111987 | 20240914214944_5ZHnY | FR0003 | 2024-09-18T12:02:35.320Z | 2024-09-19T12:18:36.225Z |
5111292 | 5111292 | 20240914202015_Voqfr | FR0003 | 2024-09-18T12:01:48.026Z | 2024-09-19T12:18:28.686Z |
5101340 | 5101340 | 20240914002126_PID9W | FR0003 | 2024-09-17T12:05:37.140Z | 2024-09-19T12:19:50.330Z |
5100572 | 5100572 | 20240913233115_hUKkU | FR0003 | 2024-09-17T12:04:39.265Z | 2024-09-19T12:19:48.143Z |
5094587 | 5094587 | 20240912041152_tvFzh | FR0003 | 2024-09-16T12:14:51.944Z | 2024-09-19T12:21:16.265Z |
5094529 | 5094529 | 20240912040724_DSvCN | FR0003 | 2024-09-16T12:14:50.352Z | 2024-09-19T12:21:16.228Z |
5091913 | 5091913 | 20240912022745_rDStm | FR0003 | 2024-09-16T12:13:30.575Z | 2024-09-19T12:21:13.472Z |
5091654 | 5091654 | 20240912021707_89l3n | FR0003 | 2024-09-16T12:13:16.471Z | 2024-09-19T12:21:13.300Z |
5091412 | 5091412 | 20240912020815_wBVU4 | FR0003 | 2024-09-16T12:13:05.375Z | 2024-09-19T12:21:13.000Z |
5091359 | 5091359 | 20240912020625_8yfld | FR0003 | 2024-09-16T12:13:02.870Z | 2024-09-19T12:21:12.950Z |
5054821 | 5054821 | 20240908041200_Vg7Cr | FR0003 | 2024-09-13T12:16:56.453Z | 2024-09-16T12:21:16.940Z |
5054647 | 5054647 | 20240908032817_b2TJW | FR0003 | 2024-09-13T12:16:50.884Z | 2024-09-16T12:21:16.400Z |
5054547 | 5054547 | 20240908030721_Siw8g | FR0003 | 2024-09-13T12:16:46.414Z | 2024-09-16T12:21:15.936Z |
5054326 | 5054326 | 20240908024020_U3dt2 | FR0003 | 2024-09-13T12:16:38.383Z | 2024-09-16T12:21:14.945Z |
5054125 | 5054125 | 20240908021503_A5uPR | FR0003 | 2024-09-13T12:16:30.699Z | 2024-09-16T12:21:13.989Z |
5054073 | 5054073 | 20240908020657_BeW2Q | FR0003 | 2024-09-13T12:16:28.456Z | 2024-09-16T12:21:13.879Z |
5053954 | 5053954 | 20240908015543_UpCev | FR0003 | 2024-09-13T12:16:24.066Z | 2024-09-16T12:21:13.373Z |
5053727 | 5053727 | 20240908012141_n7xrT | FR0003 | 2024-09-13T12:16:15.451Z | 2024-09-16T12:21:12.605Z |
5053626 | 5053626 | 20240908010937_8RbKP | FR0003 | 2024-09-13T12:16:10.657Z | 2024-09-16T12:21:12.188Z |
5053217 | 5053217 | 20240907235157_yL5hD | FR0003 | 2024-09-13T12:15:54.030Z | 2024-09-16T12:21:10.015Z |
5000048 | 5000048 | 20240902012729_VcvHb | FR0003 | 2024-09-08T12:15:01.454Z | 2024-09-10T12:19:24.357Z |
4999907 | 4999907 | 20240902011020_FI0dm | FR0003 | 2024-09-08T12:14:49.948Z | 2024-09-10T12:19:23.955Z |
4991097 | 4991097 | 20240901015738_mL4Vk | FR0003 | 2024-09-07T12:11:34.066Z | 2024-09-09T12:26:59.889Z |
4989076 | 4989076 | 20240901223611_rgamh | FR0003 | 2024-09-07T12:08:28.536Z | 2024-09-10T12:19:16.623Z |
4988377 | 4988377 | 20240901204100_yFK11 | FR0003 | 2024-09-07T12:07:20.156Z | 2024-09-10T12:19:13.880Z |
4983358 | 4983358 | 20240812004344_KLh2U | FR0003 | 2024-09-06T12:15:28.541Z | 2024-09-06T12:15:28.541Z |
4981987 | 4981987 | 20240812002857_3KWVd | FR0003 | 2024-09-06T12:14:41.224Z | 2024-09-06T12:14:41.224Z |
4979730 | 4979730 | 20240812000401_qGYB9 | FR0003 | 2024-09-06T12:13:24.849Z | 2024-09-06T12:13:24.849Z |
4978955 | 4978955 | 20240811235723_caB9L | FR0003 | 2024-09-06T12:12:46.671Z | 2024-09-06T12:12:46.671Z |
4978302 | 4978302 | 20240811234944_x1c88 | FR0003 | 2024-09-06T12:12:32.342Z | 2024-09-06T12:12:32.342Z |
4977930 | 4977930 | 20240811234623_L5AQD | FR0003 | 2024-09-06T12:12:26.746Z | 2024-09-06T12:12:26.746Z |
4976293 | 4976293 | 20240811232817_gEeue | FR0003 | 2024-09-06T12:11:22.835Z | 2024-09-06T12:11:22.835Z |
4976123 | 4976123 | 20240811232558_SjB5L | FR0003 | 2024-09-06T12:11:13.285Z | 2024-09-06T12:11:13.285Z |
4974939 | 4974939 | 20240811231259_kjNZ9 | FR0003 | 2024-09-05T12:11:36.890Z | 2024-09-06T12:10:34.655Z |
4974616 | 4974616 | 20240811230912_L8j0D | FR0003 | 2024-09-05T12:11:28.051Z | 2024-09-06T12:10:29.326Z |
4974477 | 4974477 | 20240811230724_ATRf3 | FR0003 | 2024-09-05T12:11:24.968Z | 2024-09-06T12:10:26.930Z |
4974037 | 4974037 | 20240811230234_9vQnF | FR0003 | 2024-09-05T12:11:16.562Z | 2024-09-06T12:10:15.778Z |
4973373 | 4973373 | 20240811225622_GFixe | FR0003 | 2024-09-05T12:10:50.024Z | 2024-09-06T12:09:53.497Z |
4973023 | 4973023 | 20240811225238_IjPTs | FR0003 | 2024-09-05T12:10:40.893Z | 2024-09-06T12:09:39.607Z |
4972812 | 4972812 | 20240811225057_5xw3f | FR0003 | 2024-09-05T12:10:35.357Z | 2024-09-06T12:09:30.205Z |
4971791 | 4971791 | 20240811223954_bL9G6 | FR0003 | 2024-09-05T12:10:00.862Z | 2024-09-06T12:08:58.283Z |
4971467 | 4971467 | 20240811223541_PsVqV | FR0003 | 2024-09-05T12:09:44.628Z | 2024-09-06T12:08:53.624Z |
4968997 | 4968997 | 20240811220536_1x88J | FR0003 | 2024-09-05T12:08:33.134Z | 2024-09-06T12:07:41.026Z |
4968138 | 4968138 | 20240811215456_wUWse | FR0003 | 2024-09-05T12:08:04.214Z | 2024-09-06T12:07:25.203Z |
4965248 | 4965248 | 20240811211119_3F9wp | FR0003 | 2024-09-04T12:06:52.710Z | 2024-09-06T12:05:51.978Z |
4964021 | 4964021 | 20240811204252_vcaBy | FR0003 | 2024-09-04T12:06:04.037Z | 2024-09-06T12:05:08.348Z |
4963768 | 4963768 | 20240811203358_UM1Wp | FR0003 | 2024-09-04T12:05:54.906Z | 2024-09-06T12:04:55.426Z |
4963609 | 4963609 | 20240811202525_2MKdO | FR0003 | 2024-09-04T12:05:45.555Z | 2024-09-06T12:04:46.211Z |
4955050 | 4955050 | 20240811032851_gJKEc | FR0003 | 2024-09-03T12:18:38.210Z | 2024-09-06T12:29:16.180Z |
4954927 | 4954927 | 20240811031704_oY2IJ | FR0003 | 2024-09-03T12:18:27.496Z | 2024-09-06T12:29:12.625Z |
4954901 | 4954901 | 20240811031609_MXE7t | FR0003 | 2024-09-03T12:18:25.039Z | 2024-09-06T12:29:11.296Z |
4953960 | 4953960 | 20240811024859_xw0Il | FR0003 | 2024-09-03T12:18:04.626Z | 2024-09-06T12:28:44.362Z |
4953951 | 4953951 | 20240811024834_gmLmx | FR0003 | 2024-09-03T12:18:04.415Z | 2024-09-06T12:28:43.165Z |
4953274 | 4953274 | 20240811023521_zFp8M | FR0003 | 2024-09-03T12:17:30.068Z | 2024-09-06T12:28:22.216Z |
4953188 | 4953188 | 20240811023420_MAbaA | FR0003 | 2024-09-03T12:17:22.887Z | 2024-09-06T12:28:20.808Z |
4950905 | 4950905 | 20240811021359_uCeO3 | FR0003 | 2024-09-02T12:16:39.101Z | 2024-09-06T12:27:51.293Z |
4950392 | 4950392 | 20240811020618_WK8A4 | FR0003 | 2024-09-02T12:16:27.565Z | 2024-09-06T12:27:44.186Z |
4949532 | 4949532 | 20240811015136_ywezO | FR0003 | 2024-09-02T12:15:48.353Z | 2024-09-06T12:27:34.423Z |
4949229 | 4949229 | 20240811014637_TBmyD | FR0003 | 2024-09-02T12:15:40.797Z | 2024-09-06T12:27:30.936Z |
4948280 | 4948280 | 20240811013157_KY2ZO | FR0003 | 2024-09-02T12:14:58.850Z | 2024-09-06T12:27:13.702Z |
4947652 | 4947652 | 20240811012214_m4jn8 | FR0003 | 2024-09-02T12:14:42.958Z | 2024-09-06T12:26:56.835Z |
4946081 | 4946081 | 20240811005622_J1f2p | FR0003 | 2024-09-02T12:13:34.819Z | 2024-09-06T12:26:13.711Z |
4946022 | 4946022 | 20240811005535_YLk8C | FR0003 | 2024-09-02T12:13:33.673Z | 2024-09-06T12:26:12.551Z |
4945345 | 4945345 | 20240811004435_n3oQR | FR0003 | 2024-09-02T12:13:15.365Z | 2024-09-06T12:25:53.302Z |
4944723 | 4944723 | 20240811003439_S3MS8 | FR0003 | 2024-09-02T12:12:43.947Z | 2024-09-06T12:25:34.324Z |
4941951 | 4941951 | 20240810234252_apTuG | FR0003 | 2024-09-02T12:10:58.120Z | 2024-09-06T12:24:00.601Z |
4940058 | 4940058 | 20240810230358_PxEkb | FR0003 | 2024-09-01T12:10:16.399Z | 2024-09-06T12:23:30.467Z |
4939878 | 4939878 | 20240810225919_yr2T6 | FR0003 | 2024-09-01T12:10:11.853Z | 2024-09-06T12:23:28.646Z |
4939660 | 4939660 | 20240810225253_HN5C3 | FR0003 | 2024-09-01T12:09:57.886Z | 2024-09-06T12:23:25.724Z |
4939570 | 4939570 | 20240810225019_gDcmt | FR0003 | 2024-09-01T12:09:54.989Z | 2024-09-06T12:23:24.692Z |
4937221 | 4937221 | 20240810214312_BTDbj | FR0003 | 2024-09-01T12:08:06.492Z | 2024-09-06T12:22:04.247Z |
4937092 | 4937092 | 20240810213904_PyotH | FR0003 | 2024-09-01T12:08:02.281Z | 2024-09-06T12:21:58.501Z |
4937065 | 4937065 | 20240810213846_V3zsv | FR0003 | 2024-09-01T12:08:01.476Z | 2024-09-06T12:21:57.836Z |
4936831 | 4936831 | 20240810213220_pCGki | FR0003 | 2024-09-01T12:07:47.951Z | 2024-09-06T12:21:48.332Z |
4935599 | 4935599 | 20240810203127_xMHWH | FR0003 | 2024-09-01T12:06:37.812Z | 2024-09-06T12:20:46.400Z |
4935497 | 4935497 | 20240810202351_39DAT | FR0003 | 2024-09-01T12:06:33.461Z | 2024-09-06T12:20:42.648Z |
4929252 | 4929252 | 20240810031847_uNEvb | FR0003 | 2024-08-31T12:21:55.434Z | 2024-09-02T12:29:30.102Z |
4928807 | 4928807 | 20240810025043_mEhya | FR0003 | 2024-08-31T12:21:40.133Z | 2024-09-02T12:29:18.826Z |
4928640 | 4928640 | 20240810024509_2u3cL | FR0003 | 2024-08-31T12:21:31.215Z | 2024-09-02T12:29:13.726Z |
4928402 | 4928402 | 20240810023855_BnoZj | FR0003 | 2024-08-31T12:21:19.912Z | 2024-09-02T12:29:08.341Z |
4927764 | 4927764 | 20240810022153_4pvUM | FR0003 | 2024-08-31T12:20:54.460Z | 2024-09-02T12:28:50.471Z |
4927178 | 4927178 | 20240810020547_sLidh | FR0003 | 2024-08-31T12:20:19.255Z | 2024-09-02T12:28:21.742Z |
4922540 | 4922540 | 20240810011811_nAPlS | FR0003 | 2024-08-30T12:14:52.001Z | 2024-09-02T12:27:27.907Z |
4922050 | 4922050 | 20240810010806_OY3KM | FR0003 | 2024-08-30T12:14:31.420Z | 2024-09-02T12:27:21.353Z |
4922036 | 4922036 | 20240810010731_2k6oC | FR0003 | 2024-08-30T12:14:30.881Z | 2024-09-02T12:27:20.845Z |
4920516 | 4920516 | 20240810003448_b1Eip | FR0003 | 2024-08-30T12:13:31.380Z | 2024-09-02T12:26:27.279Z |
4919075 | 4919075 | 20240810000400_NMbL6 | FR0003 | 2024-08-30T12:12:31.096Z | 2024-09-02T12:25:40.887Z |
4918470 | 4918470 | 20240809235230_gcT32 | FR0003 | 2024-08-30T12:12:03.366Z | 2024-09-02T12:25:32.021Z |
4917327 | 4917327 | 20240809233149_q3B4D | FR0003 | 2024-08-30T12:11:21.764Z | 2024-09-02T12:24:59.663Z |
4917179 | 4917179 | 20240809233013_c2h8J | FR0003 | 2024-08-30T12:11:18.647Z | 2024-09-02T12:24:54.587Z |
4915951 | 4915951 | 20240809230134_sXX0o | FR0003 | 2024-08-30T12:10:23.054Z | 2024-09-02T12:24:07.340Z |
4914559 | 4914559 | 20240809222310_DTVfb | FR0003 | 2024-08-30T12:09:16.576Z | 2024-09-02T12:23:36.748Z |
4913986 | 4913986 | 20240809220207_z5b4P | FR0003 | 2024-08-30T12:08:46.771Z | 2024-09-02T12:23:11.248Z |
4912129 | 4912129 | 20240809205922_lH7OG | FR0003 | 2024-08-29T12:08:11.833Z | 2024-09-02T12:22:09.170Z |
4911589 | 4911589 | 20240809201841_2TxAg | FR0003 | 2024-08-29T12:07:35.298Z | 2024-09-02T12:21:51.243Z |
4901220 | 4901220 | 20240808011442_aDlb1 | FR0003 | 2024-08-28T12:18:37.879Z | 2024-08-28T12:18:37.879Z |
4901100 | 4901100 | 20240808010527_bEt1M | FR0003 | 2024-08-28T12:18:33.584Z | 2024-08-28T12:18:33.584Z |
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);