participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,081 rows where station_code = "GR0009" 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 |
---|---|---|---|---|---|
5497650 | 5497650 | 20241107041717_Tbdxj | GR0009 | 2024-11-08T14:14:07.987Z | 2024-11-08T14:14:35.392Z |
5497569 | 5497569 | 20241107040202_4ahvd | GR0009 | 2024-11-08T14:13:59.189Z | 2024-11-08T14:14:35.372Z |
5497541 | 5497541 | 20241107035745_t2z5K | GR0009 | 2024-11-08T14:13:57.167Z | 2024-11-08T14:14:35.367Z |
5497521 | 5497521 | 20241107035256_4Qhoj | GR0009 | 2024-11-08T14:13:55.806Z | 2024-11-08T14:14:35.362Z |
5497437 | 5497437 | 20241107034025_xjsQL | GR0009 | 2024-11-08T14:13:46.393Z | 2024-11-08T14:14:35.342Z |
5497401 | 5497401 | 20241107033435_H53Fm | GR0009 | 2024-11-08T14:13:41.544Z | 2024-11-08T14:14:35.332Z |
5497399 | 5497399 | 20241107033407_XZU52 | GR0009 | 2024-11-08T14:13:41.218Z | 2024-11-08T14:14:35.332Z |
5497390 | 5497390 | 20241107033214_qgCQW | GR0009 | 2024-11-08T14:13:40.761Z | 2024-11-08T14:14:35.330Z |
5497286 | 5497286 | 20241107031408_nOm3E | GR0009 | 2024-11-08T14:13:29.703Z | 2024-11-08T14:14:35.301Z |
5497269 | 5497269 | 20241107031105_qAqHo | GR0009 | 2024-11-08T14:13:27.814Z | 2024-11-08T14:14:35.297Z |
5497267 | 5497267 | 20241107031045_iRaYJ | GR0009 | 2024-11-08T14:13:27.684Z | 2024-11-08T14:14:35.296Z |
5497202 | 5497202 | 20241107025452_6A9kr | GR0009 | 2024-11-08T14:13:21.126Z | 2024-11-08T14:14:35.280Z |
5497158 | 5497158 | 20241107025054_3yBBC | GR0009 | 2024-11-08T14:13:17.652Z | 2024-11-08T14:14:35.271Z |
5497111 | 5497111 | 20241107024409_fFlm1 | GR0009 | 2024-11-08T14:13:11.143Z | 2024-11-08T14:14:35.260Z |
5497109 | 5497109 | 20241107024352_jBr82 | GR0009 | 2024-11-08T14:13:11.076Z | 2024-11-08T14:14:35.259Z |
5497063 | 5497063 | 20241107023620_MzEUV | GR0009 | 2024-11-08T14:13:07.928Z | 2024-11-08T14:14:35.248Z |
5497016 | 5497016 | 20241107022722_BQhoo | GR0009 | 2024-11-08T14:13:05.339Z | 2024-11-08T14:14:35.237Z |
5496978 | 5496978 | 20241107022112_4cb2Z | GR0009 | 2024-11-08T14:13:01.655Z | 2024-11-08T14:14:35.228Z |
5496920 | 5496920 | 20241107021105_n7lFu | GR0009 | 2024-11-08T14:12:58.923Z | 2024-11-08T14:14:35.214Z |
5496898 | 5496898 | 20241107020814_0w3Ho | GR0009 | 2024-11-08T14:12:57.918Z | 2024-11-08T14:14:35.209Z |
5496881 | 5496881 | 20241107020548_35kXf | GR0009 | 2024-11-08T14:12:56.750Z | 2024-11-08T14:14:35.204Z |
5496879 | 5496879 | 20241107020533_wRQ2n | GR0009 | 2024-11-08T14:12:56.573Z | 2024-11-08T14:14:35.204Z |
5496865 | 5496865 | 20241107020152_9ye3e | GR0009 | 2024-11-08T14:12:55.939Z | 2024-11-08T14:14:35.201Z |
5496854 | 5496854 | 20241107015519_s9CsN | GR0009 | 2024-11-08T14:12:55.227Z | 2024-11-08T14:14:35.198Z |
5496779 | 5496779 | 20241107013747_2H78V | GR0009 | 2024-11-08T14:12:51.280Z | 2024-11-08T14:14:35.180Z |
5496774 | 5496774 | 20241107013500_tJfGh | GR0009 | 2024-11-08T14:12:51.108Z | 2024-11-08T14:14:35.179Z |
5496767 | 5496767 | 20241107013407_P5MUC | GR0009 | 2024-11-08T14:12:50.567Z | 2024-11-08T14:14:35.178Z |
5496719 | 5496719 | 20241107012403_Dps1C | GR0009 | 2024-11-08T14:12:47.548Z | 2024-11-08T14:14:35.167Z |
5496674 | 5496674 | 20241107011321_Lk67m | GR0009 | 2024-11-08T14:12:39.835Z | 2024-11-08T14:14:35.157Z |
5496672 | 5496672 | 20241107011301_UebZ0 | GR0009 | 2024-11-08T14:12:39.791Z | 2024-11-08T14:14:35.156Z |
5496649 | 5496649 | 20241107010909_7sZ2z | GR0009 | 2024-11-08T14:12:36.588Z | 2024-11-08T14:14:35.151Z |
5496635 | 5496635 | 20241107010702_hhzG9 | GR0009 | 2024-11-08T14:12:34.849Z | 2024-11-08T14:14:35.147Z |
5496633 | 5496633 | 20241107010647_TTzQ8 | GR0009 | 2024-11-08T14:12:34.774Z | 2024-11-08T14:14:35.147Z |
5496520 | 5496520 | 20241107004336_Muj3H | GR0009 | 2024-11-08T14:12:18.740Z | 2024-11-08T14:14:35.118Z |
5496388 | 5496388 | 20241107000957_bL4FY | GR0009 | 2024-11-08T14:12:05.955Z | 2024-11-08T14:14:35.086Z |
5496198 | 5496198 | 20241106232156_Vf99K | GR0009 | 2024-11-08T14:11:45.302Z | 2024-11-08T14:14:35.041Z |
5496165 | 5496165 | 20241106231130_odOgB | GR0009 | 2024-11-08T14:11:40.852Z | 2024-11-08T14:14:35.032Z |
5496114 | 5496114 | 20241106225834_Wr0Ta | GR0009 | 2024-11-08T14:11:35.568Z | 2024-11-08T14:14:35.021Z |
5496108 | 5496108 | 20241106225603_L7jhZ | GR0009 | 2024-11-08T14:11:35.188Z | 2024-11-08T14:14:35.019Z |
5496083 | 5496083 | 20241106225310_FBzfL | GR0009 | 2024-11-08T14:11:30.858Z | 2024-11-08T14:14:35.013Z |
5496059 | 5496059 | 20241106224903_R6D6E | GR0009 | 2024-11-08T14:11:28.685Z | 2024-11-08T14:14:35.008Z |
5496028 | 5496028 | 20241106224043_4tUu6 | GR0009 | 2024-11-08T14:11:24.532Z | 2024-11-08T14:14:35.000Z |
5496012 | 5496012 | 20241106223509_8mkUz | GR0009 | 2024-11-08T14:11:23.284Z | 2024-11-08T14:14:34.996Z |
5495965 | 5495965 | 20241106222436_UpR8Y | GR0009 | 2024-11-08T14:11:14.523Z | 2024-11-08T14:14:34.984Z |
5495940 | 5495940 | 20241106221525_UMcLQ | GR0009 | 2024-11-08T14:11:11.255Z | 2024-11-08T14:14:34.977Z |
5495908 | 5495908 | 20241106220229_LlLrT | GR0009 | 2024-11-08T14:11:05.851Z | 2024-11-08T14:14:34.969Z |
5495872 | 5495872 | 20241106215346_09OC4 | GR0009 | 2024-11-08T14:11:03.048Z | 2024-11-08T14:14:34.960Z |
5495767 | 5495767 | 20241106212808_DkIVA | GR0009 | 2024-11-08T14:10:48.749Z | 2024-11-08T14:14:34.937Z |
5495754 | 5495754 | 20241106212226_4iVw3 | GR0009 | 2024-11-08T14:10:45.691Z | 2024-11-08T14:14:34.934Z |
5495751 | 5495751 | 20241106212134_WgU5Q | GR0009 | 2024-11-08T14:10:45.477Z | 2024-11-08T14:14:34.933Z |
5495718 | 5495718 | 20241106211146_AJfnL | GR0009 | 2024-11-08T14:10:41.329Z | 2024-11-08T14:14:34.924Z |
5495699 | 5495699 | 20241106210604_u06dP | GR0009 | 2024-11-08T14:10:38.926Z | 2024-11-08T14:14:34.919Z |
5495692 | 5495692 | 20241106210449_7UnJw | GR0009 | 2024-11-08T14:10:38.262Z | 2024-11-08T14:14:34.917Z |
5495645 | 5495645 | 20241106204847_u73jp | GR0009 | 2024-11-08T14:10:32.704Z | 2024-11-08T14:14:34.899Z |
5495639 | 5495639 | 20241106204558_r8P15 | GR0009 | 2024-11-08T14:10:31.903Z | 2024-11-08T14:14:34.896Z |
5495624 | 5495624 | 20241106204202_mOV5Y | GR0009 | 2024-11-08T14:10:30.357Z | 2024-11-08T14:14:34.893Z |
5495588 | 5495588 | 20241106202640_zD6S2 | GR0009 | 2024-11-08T14:10:26.230Z | 2024-11-08T14:14:34.878Z |
5495519 | 5495519 | 20241106200754_fDdR1 | GR0009 | 2024-11-08T14:10:20.050Z | 2024-11-08T14:14:34.850Z |
5495492 | 5495492 | 20241106200224_zKV06 | GR0009 | 2024-11-08T14:10:18.083Z | 2024-11-08T14:14:34.842Z |
5495456 | 5495456 | 20241106195445_l9Qib | GR0009 | 2024-11-08T14:10:15.131Z | 2024-11-08T14:14:34.832Z |
5495454 | 5495454 | 20241106195413_3AAqu | GR0009 | 2024-11-08T14:10:15.093Z | 2024-11-08T14:14:34.831Z |
5495437 | 5495437 | 20241106194758_9azPZ | GR0009 | 2024-11-08T14:10:13.456Z | 2024-11-08T14:14:34.823Z |
5495345 | 5495345 | 20241106193248_3wCLH | GR0009 | 2024-11-08T14:10:04.349Z | 2024-11-08T14:14:34.798Z |
5495235 | 5495235 | 20241106190344_nfT3N | GR0009 | 2024-11-08T14:09:42.802Z | 2024-11-08T14:14:34.756Z |
5495023 | 5495023 | 20241106181958_vMR8p | GR0009 | 2024-11-08T14:09:03.511Z | 2024-11-08T14:14:34.687Z |
5495017 | 5495017 | 20241106181730_eztSg | GR0009 | 2024-11-08T14:09:02.616Z | 2024-11-08T14:14:34.684Z |
5494806 | 5494806 | 20241106172446_PhRmc | GR0009 | 2024-11-08T14:08:37.754Z | 2024-11-08T14:14:34.609Z |
5494754 | 5494754 | 20241106171037_TI3Wy | GR0009 | 2024-11-08T14:08:32.822Z | 2024-11-08T14:14:34.591Z |
5494732 | 5494732 | 20241106170646_xGgbL | GR0009 | 2024-11-08T14:08:30.263Z | 2024-11-08T14:14:34.581Z |
5494700 | 5494700 | 20241106165730_HvUif | GR0009 | 2024-11-08T14:08:23.139Z | 2024-11-08T14:14:34.570Z |
5494670 | 5494670 | 20241106164749_c41J5 | GR0009 | 2024-11-08T14:08:17.300Z | 2024-11-08T14:14:34.561Z |
5491176 | 5491176 | 20241106021634_V703z | GR0009 | 2024-11-07T14:15:24.655Z | 2024-11-08T14:16:46.808Z |
5490943 | 5490943 | 20241106012105_TD0tC | GR0009 | 2024-11-07T14:15:06.507Z | 2024-11-08T14:16:39.015Z |
5490806 | 5490806 | 20241106004320_oOFx2 | GR0009 | 2024-11-07T14:14:56.976Z | 2024-11-08T14:16:35.751Z |
5490658 | 5490658 | 20241105235701_kFVlc | GR0009 | 2024-11-07T14:14:24.968Z | 2024-11-08T14:16:31.978Z |
5490173 | 5490173 | 20241105213007_kBaXG | GR0009 | 2024-11-07T14:13:28.599Z | 2024-11-08T14:16:18.940Z |
5490027 | 5490027 | 20241105204429_yvvPO | GR0009 | 2024-11-07T14:13:04.158Z | 2024-11-08T14:16:15.566Z |
5489154 | 5489154 | 20241105175808_uPv2O | GR0009 | 2024-11-07T14:11:23.454Z | 2024-11-08T14:15:56.367Z |
5489017 | 5489017 | 20241105173614_JgSem | GR0009 | 2024-11-07T14:11:11.116Z | 2024-11-08T14:15:52.711Z |
5488918 | 5488918 | 20241105172023_f1w2Y | GR0009 | 2024-11-07T14:10:56.818Z | 2024-11-08T14:15:49.717Z |
5488916 | 5488916 | 20241105171840_Blygi | GR0009 | 2024-11-07T14:10:55.408Z | 2024-11-08T14:15:49.685Z |
5484917 | 5484917 | 20241105034102_3VcC2 | GR0009 | 2024-11-06T14:17:29.344Z | 2024-11-08T14:18:47.784Z |
5484034 | 5484034 | 20241105020344_ofNPU | GR0009 | 2024-11-06T14:16:06.274Z | 2024-11-08T14:18:40.711Z |
5484019 | 5484019 | 20241105015723_DAp6p | GR0009 | 2024-11-06T14:16:03.482Z | 2024-11-08T14:18:40.589Z |
5483792 | 5483792 | 20241105013112_RtC7q | GR0009 | 2024-11-06T14:15:43.053Z | 2024-11-08T14:18:39.310Z |
5483416 | 5483416 | 20241105003831_u3Rrl | GR0009 | 2024-11-06T14:15:14.059Z | 2024-11-08T14:18:37.312Z |
5483256 | 5483256 | 20241105001937_0yKlh | GR0009 | 2024-11-06T14:14:50.251Z | 2024-11-08T14:18:36.204Z |
5483238 | 5483238 | 20241105001709_1Fofh | GR0009 | 2024-11-06T14:14:48.882Z | 2024-11-08T14:18:36.010Z |
5483069 | 5483069 | 20241104235359_w53Zv | GR0009 | 2024-11-06T14:14:37.903Z | 2024-11-08T14:18:32.929Z |
5483067 | 5483067 | 20241104235325_uaDmt | GR0009 | 2024-11-06T14:14:37.720Z | 2024-11-08T14:18:32.883Z |
5483023 | 5483023 | 20241104234838_3yDeI | GR0009 | 2024-11-06T14:14:35.123Z | 2024-11-08T14:18:32.150Z |
5482993 | 5482993 | 20241104234528_IN5EL | GR0009 | 2024-11-06T14:14:33.576Z | 2024-11-08T14:18:31.764Z |
5482915 | 5482915 | 20241104233335_L3dxH | GR0009 | 2024-11-06T14:14:18.903Z | 2024-11-08T14:18:30.414Z |
5482759 | 5482759 | 20241104231013_cftcm | GR0009 | 2024-11-06T14:13:51.976Z | 2024-11-08T14:18:28.191Z |
5482693 | 5482693 | 20241104230322_0gbm7 | GR0009 | 2024-11-06T14:13:38.707Z | 2024-11-08T14:18:27.191Z |
5482691 | 5482691 | 20241104230302_gSaUW | GR0009 | 2024-11-06T14:13:38.196Z | 2024-11-08T14:18:27.149Z |
5482680 | 5482680 | 20241104230027_NdOEN | GR0009 | 2024-11-06T14:13:35.895Z | 2024-11-08T14:18:27.096Z |
5482634 | 5482634 | 20241104225200_ILdWu | GR0009 | 2024-11-06T14:13:28.591Z | 2024-11-08T14:18:26.250Z |
5482569 | 5482569 | 20241104224001_dOT34 | GR0009 | 2024-11-06T14:13:21.948Z | 2024-11-08T14:18:24.853Z |
5482500 | 5482500 | 20241104223232_kTLg6 | GR0009 | 2024-11-06T14:13:16.638Z | 2024-11-08T14:18:23.679Z |
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);