participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,849 rows where station_code = "FR0013" 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 |
---|---|---|---|---|---|
5133865 | 5133865 | 20240916041205_EYKhl | FR0013 | 2024-09-19T12:17:11.208Z | 2024-09-19T12:17:11.208Z |
5133042 | 5133042 | 20240916024640_sAk5g | FR0013 | 2024-09-19T12:16:42.271Z | 2024-09-19T12:16:42.271Z |
5132575 | 5132575 | 20240916013356_2Cxen | FR0013 | 2024-09-19T12:16:19.627Z | 2024-09-19T12:16:19.627Z |
5132293 | 5132293 | 20240916002607_bhMLi | FR0013 | 2024-09-19T12:16:03.989Z | 2024-09-19T12:16:03.989Z |
5125198 | 5125198 | 20240918010622_79sAZ | FR0013 | 2024-09-19T12:02:29.338Z | 2024-09-19T12:06:41.990Z |
5124819 | 5124819 | 20240917220944_roD7t | FR0013 | 2024-09-19T12:01:37.875Z | 2024-09-19T12:06:41.938Z |
5121920 | 5121920 | 20240914042121_Ge34S | FR0013 | 2024-09-18T12:11:03.077Z | 2024-09-19T12:20:02.520Z |
5121910 | 5121910 | 20240914042121_KCxWZ | FR0013 | 2024-09-18T12:11:03.012Z | 2024-09-19T12:20:02.510Z |
5121552 | 5121552 | 20240914040827_9O551 | FR0013 | 2024-09-18T12:10:58.282Z | 2024-09-19T12:20:02.088Z |
5121281 | 5121281 | 20240914035702_NSNW2 | FR0013 | 2024-09-18T12:10:53.935Z | 2024-09-19T12:20:01.575Z |
5120948 | 5120948 | 20240914034245_BMoDW | FR0013 | 2024-09-18T12:10:48.891Z | 2024-09-19T12:20:01.077Z |
5120914 | 5120914 | 20240914034153_8i7I9 | FR0013 | 2024-09-18T12:10:48.759Z | 2024-09-19T12:20:01.073Z |
5120601 | 5120601 | 20240914032953_cRQIp | FR0013 | 2024-09-18T12:10:43.633Z | 2024-09-19T12:20:00.629Z |
5120231 | 5120231 | 20240914030917_cakP3 | FR0013 | 2024-09-18T12:10:35.778Z | 2024-09-19T12:19:59.744Z |
5120076 | 5120076 | 20240914025843_rhZwx | FR0013 | 2024-09-18T12:10:31.648Z | 2024-09-19T12:19:59.365Z |
5119947 | 5119947 | 20240914025435_342zJ | FR0013 | 2024-09-18T12:10:29.911Z | 2024-09-19T12:19:59.188Z |
5119941 | 5119941 | 20240914025421_ur313 | FR0013 | 2024-09-18T12:10:29.803Z | 2024-09-19T12:19:59.184Z |
5119551 | 5119551 | 20240914023837_0vAXD | FR0013 | 2024-09-18T12:10:22.245Z | 2024-09-19T12:19:58.529Z |
5119218 | 5119218 | 20240914021827_rmW7L | FR0013 | 2024-09-18T12:10:18.707Z | 2024-09-19T12:19:57.468Z |
5107879 | 5107879 | 20240913041341_Jj022 | FR0013 | 2024-09-17T12:13:25.461Z | 2024-09-19T12:20:47.623Z |
5107871 | 5107871 | 20240913041242_H8xeN | FR0013 | 2024-09-17T12:13:25.244Z | 2024-09-19T12:20:47.612Z |
5107593 | 5107593 | 20240913040418_nyTHn | FR0013 | 2024-09-17T12:13:17.708Z | 2024-09-19T12:20:47.295Z |
5107384 | 5107384 | 20240913035358_R1cLb | FR0013 | 2024-09-17T12:13:14.099Z | 2024-09-19T12:20:47.037Z |
5107221 | 5107221 | 20240913034718_Uop2i | FR0013 | 2024-09-17T12:13:10.883Z | 2024-09-19T12:20:46.917Z |
5107148 | 5107148 | 20240913034536_AfdxN | FR0013 | 2024-09-17T12:13:10.078Z | 2024-09-19T12:20:46.863Z |
5107125 | 5107125 | 20240913034510_dBYnT | FR0013 | 2024-09-17T12:13:09.519Z | 2024-09-19T12:20:46.844Z |
5107069 | 5107069 | 20240913034345_Uzh11 | FR0013 | 2024-09-17T12:13:08.935Z | 2024-09-19T12:20:46.804Z |
5106189 | 5106189 | 20240913031525_CmI1q | FR0013 | 2024-09-17T12:12:44.460Z | 2024-09-19T12:20:45.612Z |
5106105 | 5106105 | 20240913031144_GR0PG | FR0013 | 2024-09-17T12:12:42.401Z | 2024-09-19T12:20:45.496Z |
5105774 | 5105774 | 20240913025820_kNv3a | FR0013 | 2024-09-17T12:12:28.806Z | 2024-09-19T12:20:44.875Z |
5105554 | 5105554 | 20240913025139_2mBaD | FR0013 | 2024-09-17T12:12:21.459Z | 2024-09-19T12:20:44.663Z |
5105507 | 5105507 | 20240913024943_BTqKC | FR0013 | 2024-09-17T12:12:19.616Z | 2024-09-19T12:20:44.610Z |
5105421 | 5105421 | 20240913024446_gf31Y | FR0013 | 2024-09-17T12:12:14.504Z | 2024-09-19T12:20:44.409Z |
5105369 | 5105369 | 20240913024234_TokVl | FR0013 | 2024-09-17T12:12:11.587Z | 2024-09-19T12:20:44.356Z |
5104775 | 5104775 | 20240913022109_NoJDj | FR0013 | 2024-09-17T12:11:44.558Z | 2024-09-19T12:20:42.881Z |
5104334 | 5104334 | 20240913020532_v7aHg | FR0013 | 2024-09-17T12:11:33.555Z | 2024-09-19T12:20:41.405Z |
5104313 | 5104313 | 20240913020318_2YN4s | FR0013 | 2024-09-17T12:11:32.764Z | 2024-09-19T12:20:41.352Z |
5104273 | 5104273 | 20240913020159_43ImQ | FR0013 | 2024-09-17T12:11:31.539Z | 2024-09-19T12:20:41.307Z |
5103751 | 5103751 | 20240913013855_aMQ0A | FR0013 | 2024-09-17T12:11:09.798Z | 2024-09-19T12:20:40.446Z |
5103550 | 5103550 | 20240913013227_p597S | FR0013 | 2024-09-17T12:11:03.777Z | 2024-09-19T12:20:40.293Z |
5103545 | 5103545 | 20240913013226_ZJ3Ky | FR0013 | 2024-09-17T12:11:02.511Z | 2024-09-19T12:20:40.281Z |
5103386 | 5103386 | 20240913012923_cas72 | FR0013 | 2024-09-17T12:10:55.750Z | 2024-09-19T12:20:40.140Z |
5103122 | 5103122 | 20240914020119_cqd83 | FR0013 | 2024-09-17T12:07:52.579Z | 2024-09-19T12:19:56.651Z |
5102802 | 5102802 | 20240914014534_HvsKk | FR0013 | 2024-09-17T12:07:37.356Z | 2024-09-19T12:19:55.723Z |
5102679 | 5102679 | 20240914013700_QzYKJ | FR0013 | 2024-09-17T12:07:30.966Z | 2024-09-19T12:19:55.397Z |
5102632 | 5102632 | 20240914013344_u6Ydn | FR0013 | 2024-09-17T12:07:27.930Z | 2024-09-19T12:19:55.246Z |
5102351 | 5102351 | 20240914012135_vs4u7 | FR0013 | 2024-09-17T12:07:04.133Z | 2024-09-19T12:19:53.874Z |
5102285 | 5102285 | 20240914011559_2eLth | FR0013 | 2024-09-17T12:06:58.359Z | 2024-09-19T12:19:53.268Z |
5102220 | 5102220 | 20240914011225_Ry2D1 | FR0013 | 2024-09-17T12:06:55.028Z | 2024-09-19T12:19:52.885Z |
5101983 | 5101983 | 20240914005815_Td1ZU | FR0013 | 2024-09-17T12:06:35.863Z | 2024-09-19T12:19:52.085Z |
5101972 | 5101972 | 20240914005753_PF5vp | FR0013 | 2024-09-17T12:06:33.018Z | 2024-09-19T12:19:52.018Z |
5101734 | 5101734 | 20240914004418_23skb | FR0013 | 2024-09-17T12:06:10.467Z | 2024-09-19T12:19:51.322Z |
5101705 | 5101705 | 20240914004340_8M1TP | FR0013 | 2024-09-17T12:06:09.652Z | 2024-09-19T12:19:51.305Z |
5101684 | 5101684 | 20240914004316_9xWbQ | FR0013 | 2024-09-17T12:06:08.854Z | 2024-09-19T12:19:51.248Z |
5101571 | 5101571 | 20240914003548_IbtzG | FR0013 | 2024-09-17T12:06:02.563Z | 2024-09-19T12:19:50.970Z |
5101468 | 5101468 | 20240914002755_U1atr | FR0013 | 2024-09-17T12:05:53.762Z | 2024-09-19T12:19:50.650Z |
5101169 | 5101169 | 20240914000824_1gw3t | FR0013 | 2024-09-17T12:05:23.488Z | 2024-09-19T12:19:49.918Z |
5101070 | 5101070 | 20240914000036_CD4f4 | FR0013 | 2024-09-17T12:05:17.925Z | 2024-09-19T12:19:49.651Z |
5100485 | 5100485 | 20240913232838_Zt08a | FR0013 | 2024-09-17T12:04:36.606Z | 2024-09-19T12:19:48.057Z |
5100210 | 5100210 | 20240913230536_E7QmG | FR0013 | 2024-09-17T12:04:17.213Z | 2024-09-19T12:19:47.275Z |
5100206 | 5100206 | 20240913230522_O8IUp | FR0013 | 2024-09-17T12:04:16.291Z | 2024-09-19T12:19:47.238Z |
5100147 | 5100147 | 20240913225607_1v4SC | FR0013 | 2024-09-17T12:04:02.395Z | 2024-09-19T12:19:47.030Z |
5099990 | 5099990 | 20240913223419_qizHO | FR0013 | 2024-09-17T12:03:48.698Z | 2024-09-19T12:19:46.648Z |
5099890 | 5099890 | 20240913222044_FYxaB | FR0013 | 2024-09-17T12:03:42.452Z | 2024-09-19T12:19:46.312Z |
5099854 | 5099854 | 20240913221130_Laxhg | FR0013 | 2024-09-17T12:03:39.510Z | 2024-09-19T12:19:46.171Z |
5099628 | 5099628 | 20240913214232_CHcVs | FR0013 | 2024-09-17T12:03:15.634Z | 2024-09-19T12:19:45.519Z |
5099470 | 5099470 | 20240913211838_Zagv7 | FR0013 | 2024-09-17T12:03:00.051Z | 2024-09-19T12:19:45.000Z |
5097540 | 5097540 | 20240913005319_nJ3uE | FR0013 | 2024-09-16T12:17:13.311Z | 2024-09-19T12:20:38.700Z |
5094127 | 5094127 | 20240912034906_Hs1x5 | FR0013 | 2024-09-16T12:14:35.501Z | 2024-09-19T12:21:15.895Z |
5094087 | 5094087 | 20240912034730_3T2Vp | FR0013 | 2024-09-16T12:14:33.683Z | 2024-09-19T12:21:15.876Z |
5093875 | 5093875 | 20240912034005_raaAf | FR0013 | 2024-09-16T12:14:26.937Z | 2024-09-19T12:21:15.702Z |
5093795 | 5093795 | 20240912033604_Sqwk3 | FR0013 | 2024-09-16T12:14:25.580Z | 2024-09-19T12:21:15.657Z |
5093757 | 5093757 | 20240912033407_wN3Il | FR0013 | 2024-09-16T12:14:24.907Z | 2024-09-19T12:21:15.638Z |
5093754 | 5093754 | 20240912033405_XC3iu | FR0013 | 2024-09-16T12:14:24.824Z | 2024-09-19T12:21:15.635Z |
5093716 | 5093716 | 20240912033338_f5QSy | FR0013 | 2024-09-16T12:14:24.521Z | 2024-09-19T12:21:15.616Z |
5093710 | 5093710 | 20240912033313_2dJ2O | FR0013 | 2024-09-16T12:14:24.385Z | 2024-09-19T12:21:15.612Z |
5093582 | 5093582 | 20240912032723_xlJNx | FR0013 | 2024-09-16T12:14:21.526Z | 2024-09-19T12:21:15.420Z |
5093553 | 5093553 | 20240912032658_U4P7d | FR0013 | 2024-09-16T12:14:21.199Z | 2024-09-19T12:21:15.412Z |
5093546 | 5093546 | 20240912032530_riuHc | FR0013 | 2024-09-16T12:14:20.475Z | 2024-09-19T12:21:15.406Z |
5093184 | 5093184 | 20240912031352_qjjR1 | FR0013 | 2024-09-16T12:14:12.827Z | 2024-09-19T12:21:14.999Z |
5093141 | 5093141 | 20240912031237_zLpso | FR0013 | 2024-09-16T12:14:12.088Z | 2024-09-19T12:21:14.968Z |
5093038 | 5093038 | 20240912030836_2VtIp | FR0013 | 2024-09-16T12:14:10.448Z | 2024-09-19T12:21:14.908Z |
5092888 | 5092888 | 20240912030039_v5uih | FR0013 | 2024-09-16T12:14:06.079Z | 2024-09-19T12:21:14.638Z |
5092801 | 5092801 | 20240912025816_SjZHQ | FR0013 | 2024-09-16T12:14:04.570Z | 2024-09-19T12:21:14.586Z |
5092742 | 5092742 | 20240912025559_CBTko | FR0013 | 2024-09-16T12:14:02.925Z | 2024-09-19T12:21:14.472Z |
5092474 | 5092474 | 20240912024711_Z6cC2 | FR0013 | 2024-09-16T12:13:57.870Z | 2024-09-19T12:21:14.271Z |
5092448 | 5092448 | 20240912024626_IaXnh | FR0013 | 2024-09-16T12:13:56.237Z | 2024-09-19T12:21:14.115Z |
5092393 | 5092393 | 20240912024419_FzVw5 | FR0013 | 2024-09-16T12:13:51.277Z | 2024-09-19T12:21:13.934Z |
5091903 | 5091903 | 20240912022730_vxLxG | FR0013 | 2024-09-16T12:13:29.932Z | 2024-09-19T12:21:13.471Z |
5091584 | 5091584 | 20240912021405_ieXtn | FR0013 | 2024-09-16T12:13:11.465Z | 2024-09-19T12:21:13.225Z |
5091565 | 5091565 | 20240912021347_KzsVa | FR0013 | 2024-09-16T12:13:11.365Z | 2024-09-19T12:21:13.223Z |
5091485 | 5091485 | 20240912021041_KTbSe | FR0013 | 2024-09-16T12:13:07.964Z | 2024-09-19T12:21:13.083Z |
5091117 | 5091117 | 20240912015801_zRdnu | FR0013 | 2024-09-16T12:12:49.819Z | 2024-09-19T12:21:12.570Z |
5090911 | 5090911 | 20240912015033_yEgfC | FR0013 | 2024-09-16T12:12:41.561Z | 2024-09-19T12:21:12.342Z |
5090815 | 5090815 | 20240912014704_gyXbK | FR0013 | 2024-09-16T12:12:37.352Z | 2024-09-19T12:21:12.122Z |
5089905 | 5089905 | 20240912010230_ZYdiN | FR0013 | 2024-09-16T12:11:49.109Z | 2024-09-19T12:21:10.612Z |
5089686 | 5089686 | 20240912005234_oc2aQ | FR0013 | 2024-09-16T12:11:36.366Z | 2024-09-19T12:21:10.173Z |
5089486 | 5089486 | 20240912004517_W7TMT | FR0013 | 2024-09-16T12:11:26.697Z | 2024-09-19T12:21:09.985Z |
5089469 | 5089469 | 20240912004447_cFHiZ | FR0013 | 2024-09-16T12:11:26.131Z | 2024-09-19T12:21:09.971Z |
5089207 | 5089207 | 20240912002906_2R9o6 | FR0013 | 2024-09-16T12:11:17.674Z | 2024-09-19T12:21:09.833Z |
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);