participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,424 rows where station_code = "US002Y" 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 |
---|---|---|---|---|---|
4903243 | 4903243 | 20240808024653_87LR9 | US002Y | 2024-08-28T12:19:33.135Z | 2024-08-28T12:19:33.135Z |
4892832 | 4892832 | 20240809071026_lGhs7 | US002Y | 2024-08-28T12:10:45.201Z | 2024-08-30T12:22:36.401Z |
4771844 | 4771844 | 20240801042014_vYPpN | US002Y | 2024-08-07T12:01:42.402Z | 2024-08-11T12:11:02.364Z |
4721491 | 4721491 | 20240728033837_0tVxE | US002Y | 2024-07-31T12:06:45.536Z | 2024-08-05T12:19:57.276Z |
4700071 | 4700071 | 20240727045101_KQw3K | US002Y | 2024-07-28T12:07:28.389Z | 2024-08-04T12:19:18.889Z |
4691893 | 4691893 | 20240726044904_Im6Zw | US002Y | 2024-07-27T12:06:38.107Z | 2024-08-03T12:21:26.961Z |
4663338 | 4663338 | 20240718090638_2g5Wq | US002Y | 2024-07-19T12:05:53.810Z | 2024-07-26T12:17:52.353Z |
4663258 | 4663258 | 20240718081046_6hUBg | US002Y | 2024-07-19T12:05:49.645Z | 2024-07-26T12:17:51.382Z |
4663226 | 4663226 | 20240718075608_U9set | US002Y | 2024-07-19T12:05:48.275Z | 2024-07-26T12:17:51.226Z |
4659312 | 4659312 | 20240716091326_3hVsc | US002Y | 2024-07-18T12:10:44.774Z | 2024-07-24T12:17:32.585Z |
4659283 | 4659283 | 20240716090817_zTymY | US002Y | 2024-07-18T12:10:43.157Z | 2024-07-24T12:17:32.490Z |
4659279 | 4659279 | 20240716090721_vPUtt | US002Y | 2024-07-18T12:10:42.694Z | 2024-07-24T12:17:32.457Z |
4659254 | 4659254 | 20240716085955_u1kcI | US002Y | 2024-07-18T12:10:39.227Z | 2024-07-24T12:17:32.219Z |
4659129 | 4659129 | 20240716081940_FMAhn | US002Y | 2024-07-18T12:10:28.485Z | 2024-07-24T12:17:31.495Z |
4659090 | 4659090 | 20240716080710_lA62r | US002Y | 2024-07-18T12:10:24.721Z | 2024-07-24T12:17:30.697Z |
4659088 | 4659088 | 20240716080638_2L3Jz | US002Y | 2024-07-18T12:10:24.651Z | 2024-07-24T12:17:30.688Z |
4659076 | 4659076 | 20240716075952_BFZYY | US002Y | 2024-07-18T12:10:24.050Z | 2024-07-24T12:17:30.592Z |
4659014 | 4659014 | 20240716074226_ovAb3 | US002Y | 2024-07-18T12:10:22.385Z | 2024-07-24T12:17:30.013Z |
4658923 | 4658923 | 20240716071607_eb207 | US002Y | 2024-07-18T12:10:18.671Z | 2024-07-24T12:17:29.041Z |
4658895 | 4658895 | 20240716070820_F6Y4i | US002Y | 2024-07-18T12:10:17.726Z | 2024-07-24T12:17:28.761Z |
4658862 | 4658862 | 20240716065622_JJORy | US002Y | 2024-07-18T12:10:16.655Z | 2024-07-24T12:17:28.332Z |
4658778 | 4658778 | 20240716062435_3NfNh | US002Y | 2024-07-18T12:10:13.224Z | 2024-07-24T12:17:27.282Z |
4658771 | 4658771 | 20240716061709_oBEY3 | US002Y | 2024-07-18T12:10:13.044Z | 2024-07-24T12:17:27.185Z |
4658697 | 4658697 | 20240716050815_tvt6w | US002Y | 2024-07-18T12:10:10.379Z | 2024-07-24T12:17:26.107Z |
4658684 | 4658684 | 20240716045822_ElWga | US002Y | 2024-07-18T12:10:09.978Z | 2024-07-24T12:17:25.945Z |
4651791 | 4651791 | 20240716102921_lJW2U | US002Y | 2024-07-18T12:00:39.748Z | 2024-07-25T12:13:35.753Z |
4651717 | 4651717 | 20240716101315_gBqYW | US002Y | 2024-07-18T12:00:30.267Z | 2024-07-25T12:13:34.881Z |
4651599 | 4651599 | 20240716095135_wp4aM | US002Y | 2024-07-18T12:00:20.929Z | 2024-07-25T12:13:32.682Z |
4651501 | 4651501 | 20240716092808_pqtSV | US002Y | 2024-07-18T12:00:12.995Z | 2024-07-25T12:13:31.538Z |
4651334 | 4651334 | 20240715073509_36GuX | US002Y | 2024-07-17T12:09:59.474Z | 2024-07-23T12:08:50.486Z |
4651315 | 4651315 | 20240715071300_CLqXZ | US002Y | 2024-07-17T12:09:58.843Z | 2024-07-23T12:08:50.303Z |
4651296 | 4651296 | 20240715070456_qwl3V | US002Y | 2024-07-17T12:09:57.909Z | 2024-07-23T12:08:50.139Z |
4651290 | 4651290 | 20240715070146_kVahO | US002Y | 2024-07-17T12:09:57.630Z | 2024-07-23T12:08:50.058Z |
4651264 | 4651264 | 20240715063751_Jt1Kx | US002Y | 2024-07-17T12:09:56.318Z | 2024-07-23T12:08:49.765Z |
4651236 | 4651236 | 20240715061735_1PsYx | US002Y | 2024-07-17T12:09:54.806Z | 2024-07-23T12:08:49.456Z |
4651230 | 4651230 | 20240715061248_AFIMj | US002Y | 2024-07-17T12:09:54.356Z | 2024-07-23T12:08:49.360Z |
4651198 | 4651198 | 20240715055554_WpVl3 | US002Y | 2024-07-17T12:09:52.571Z | 2024-07-23T12:08:49.191Z |
4651196 | 4651196 | 20240715055532_63L4L | US002Y | 2024-07-17T12:09:52.428Z | 2024-07-23T12:08:49.174Z |
4651153 | 4651153 | 20240715052052_R6nup | US002Y | 2024-07-17T12:09:49.267Z | 2024-07-23T12:08:49.014Z |
4651142 | 4651142 | 20240715050801_PjU9P | US002Y | 2024-07-17T12:09:48.686Z | 2024-07-23T12:08:48.955Z |
4643819 | 4643819 | 20240715100556_P5rwK | US002Y | 2024-07-17T12:00:36.591Z | 2024-07-24T12:16:34.138Z |
4643796 | 4643796 | 20240715095838_kX2Wf | US002Y | 2024-07-17T12:00:32.002Z | 2024-07-24T12:16:33.588Z |
4643787 | 4643787 | 20240715095425_jzQ1g | US002Y | 2024-07-17T12:00:29.767Z | 2024-07-24T12:16:33.426Z |
4643781 | 4643781 | 20240715095123_Q0OTf | US002Y | 2024-07-17T12:00:28.929Z | 2024-07-24T12:16:33.127Z |
4643772 | 4643772 | 20240715095000_YZURc | US002Y | 2024-07-17T12:00:28.120Z | 2024-07-24T12:16:32.533Z |
4643736 | 4643736 | 20240715093657_n1Fil | US002Y | 2024-07-17T12:00:25.641Z | 2024-07-24T12:16:31.589Z |
4643643 | 4643643 | 20240715090657_jfUXD | US002Y | 2024-07-17T12:00:18.787Z | 2024-07-24T12:16:29.816Z |
4643637 | 4643637 | 20240715090126_OrgNz | US002Y | 2024-07-17T12:00:18.301Z | 2024-07-24T12:16:29.734Z |
4643635 | 4643635 | 20240715085827_beukg | US002Y | 2024-07-17T12:00:17.986Z | 2024-07-24T12:16:29.649Z |
4643612 | 4643612 | 20240715084711_r4XAr | US002Y | 2024-07-17T12:00:15.424Z | 2024-07-24T12:16:29.002Z |
4643602 | 4643602 | 20240715084047_rd0eV | US002Y | 2024-07-17T12:00:14.118Z | 2024-07-24T12:16:28.890Z |
4643593 | 4643593 | 20240715083429_Lb6JC | US002Y | 2024-07-17T12:00:13.176Z | 2024-07-24T12:16:28.552Z |
4643576 | 4643576 | 20240715083143_43LBm | US002Y | 2024-07-17T12:00:11.355Z | 2024-07-24T12:16:28.312Z |
4643518 | 4643518 | 20240714064756_VlWs5 | US002Y | 2024-07-16T12:07:04.417Z | 2024-07-22T12:10:32.235Z |
4643450 | 4643450 | 20240714062530_BbsSC | US002Y | 2024-07-16T12:07:02.731Z | 2024-07-22T12:10:31.689Z |
4643422 | 4643422 | 20240714061436_rtkjc | US002Y | 2024-07-16T12:07:01.835Z | 2024-07-22T12:10:31.371Z |
4643385 | 4643385 | 20240714060059_05YWD | US002Y | 2024-07-16T12:06:58.886Z | 2024-07-22T12:10:31.026Z |
4643296 | 4643296 | 20240714052842_NmVQR | US002Y | 2024-07-16T12:06:52.616Z | 2024-07-22T12:10:30.459Z |
4643224 | 4643224 | 20240714044805_BJjGb | US002Y | 2024-07-16T12:06:50.424Z | 2024-07-22T12:10:29.591Z |
4643219 | 4643219 | 20240714044640_o3dR7 | US002Y | 2024-07-16T12:06:50.299Z | 2024-07-22T12:10:29.545Z |
4643209 | 4643209 | 20240714043838_fhYqB | US002Y | 2024-07-16T12:06:50.139Z | 2024-07-22T12:10:29.520Z |
4643178 | 4643178 | 20240714041230_ABdGB | US002Y | 2024-07-16T12:06:49.105Z | 2024-07-22T12:10:29.184Z |
4643176 | 4643176 | 20240714041227_2Hq15 | US002Y | 2024-07-16T12:06:49.047Z | 2024-07-22T12:10:29.166Z |
4643167 | 4643167 | 20240714040452_MZxFJ | US002Y | 2024-07-16T12:06:48.827Z | 2024-07-22T12:10:29.111Z |
4643123 | 4643123 | 20240714031728_2qFwd | US002Y | 2024-07-16T12:06:46.683Z | 2024-07-22T12:10:28.783Z |
4643082 | 4643082 | 20240714024209_BOEQ1 | US002Y | 2024-07-16T12:06:45.650Z | 2024-07-22T12:10:28.605Z |
4636379 | 4636379 | 20240714100450_8j2e2 | US002Y | 2024-07-16T12:01:24.572Z | 2024-07-23T12:08:34.083Z |
4636333 | 4636333 | 20240714095507_IsD2p | US002Y | 2024-07-16T12:01:21.454Z | 2024-07-23T12:08:33.879Z |
4636300 | 4636300 | 20240714094703_MFCJV | US002Y | 2024-07-16T12:01:18.394Z | 2024-07-23T12:08:33.747Z |
4636258 | 4636258 | 20240714094122_bWCRJ | US002Y | 2024-07-16T12:01:15.045Z | 2024-07-23T12:08:33.589Z |
4636211 | 4636211 | 20240714092706_f5HN3 | US002Y | 2024-07-16T12:01:09.798Z | 2024-07-23T12:08:33.373Z |
4636208 | 4636208 | 20240714092652_pXn9b | US002Y | 2024-07-16T12:01:09.577Z | 2024-07-23T12:08:33.351Z |
4636132 | 4636132 | 20240714090643_lN3tW | US002Y | 2024-07-16T12:01:02.763Z | 2024-07-23T12:08:32.991Z |
4636100 | 4636100 | 20240714090044_ynLTZ | US002Y | 2024-07-16T12:01:00.132Z | 2024-07-23T12:08:32.820Z |
4636090 | 4636090 | 20240714085958_8l2Ec | US002Y | 2024-07-16T12:00:59.242Z | 2024-07-23T12:08:32.775Z |
4636083 | 4636083 | 20240714085718_lj0bI | US002Y | 2024-07-16T12:00:58.440Z | 2024-07-23T12:08:32.735Z |
4636074 | 4636074 | 20240714085527_ED3hy | US002Y | 2024-07-16T12:00:57.970Z | 2024-07-23T12:08:32.725Z |
4636061 | 4636061 | 20240714084951_2FPq4 | US002Y | 2024-07-16T12:00:56.640Z | 2024-07-23T12:08:32.689Z |
4636047 | 4636047 | 20240714084226_GAb7M | US002Y | 2024-07-16T12:00:54.949Z | 2024-07-23T12:08:32.595Z |
4635995 | 4635995 | 20240714083014_2TDaw | US002Y | 2024-07-16T12:00:51.506Z | 2024-07-23T12:08:32.390Z |
4635947 | 4635947 | 20240714081314_7WLgE | US002Y | 2024-07-16T12:00:45.551Z | 2024-07-23T12:08:32.106Z |
4635925 | 4635925 | 20240714080410_SVSG3 | US002Y | 2024-07-16T12:00:43.093Z | 2024-07-23T12:08:31.980Z |
4635916 | 4635916 | 20240714080132_cgbAp | US002Y | 2024-07-16T12:00:42.065Z | 2024-07-23T12:08:31.927Z |
4635895 | 4635895 | 20240714075959_WpS5a | US002Y | 2024-07-16T12:00:40.533Z | 2024-07-23T12:08:31.833Z |
4635893 | 4635893 | 20240714075916_PURlb | US002Y | 2024-07-16T12:00:40.292Z | 2024-07-23T12:08:31.829Z |
4635841 | 4635841 | 20240714075015_akLzG | US002Y | 2024-07-16T12:00:32.765Z | 2024-07-23T12:08:31.493Z |
4635716 | 4635716 | 20240714072748_A1W39 | US002Y | 2024-07-16T12:00:21.637Z | 2024-07-23T12:08:30.918Z |
4635627 | 4635627 | 20240714070819_tAF9V | US002Y | 2024-07-16T12:00:13.057Z | 2024-07-23T12:08:30.485Z |
4635558 | 4635558 | 20240713054549_vtdup | US002Y | 2024-07-15T12:07:41.361Z | 2024-07-21T12:13:34.421Z |
4635544 | 4635544 | 20240713052955_OqO9H | US002Y | 2024-07-15T12:07:40.665Z | 2024-07-21T12:13:34.082Z |
4635530 | 4635530 | 20240713051159_dznMj | US002Y | 2024-07-15T12:07:40.101Z | 2024-07-21T12:13:33.980Z |
4635528 | 4635528 | 20240713051019_gFhgU | US002Y | 2024-07-15T12:07:39.985Z | 2024-07-21T12:13:33.965Z |
4635517 | 4635517 | 20240713045406_LJtNO | US002Y | 2024-07-15T12:07:39.464Z | 2024-07-21T12:13:33.938Z |
4635487 | 4635487 | 20240713032028_i4N3Q | US002Y | 2024-07-15T12:07:38.114Z | 2024-07-21T12:13:33.709Z |
4628948 | 4628948 | 20240713102217_F3i6g | US002Y | 2024-07-15T12:01:23.658Z | 2024-07-22T12:09:56.801Z |
4628776 | 4628776 | 20240713095621_5zJHU | US002Y | 2024-07-15T12:01:11.049Z | 2024-07-22T12:09:56.180Z |
4628764 | 4628764 | 20240713095523_lHqh7 | US002Y | 2024-07-15T12:01:10.419Z | 2024-07-22T12:09:56.151Z |
4628681 | 4628681 | 20240713093703_G1SAN | US002Y | 2024-07-15T12:01:03.613Z | 2024-07-22T12:09:55.744Z |
4628651 | 4628651 | 20240713092650_kAk0w | US002Y | 2024-07-15T12:01:00.591Z | 2024-07-22T12:09:55.650Z |
4628644 | 4628644 | 20240713092340_aXuX0 | US002Y | 2024-07-15T12:00:59.886Z | 2024-07-22T12:09:55.601Z |
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);