DUNS to UEI crosswalk (view)
3,323,130 rows
| awardee_or_recipient_uniqu | uei |
|---|---|
| 197124639 | C111G5E25LZ7 |
| 600856835 | C111JJBMS328 |
| 144887429 | C111NFV4VEB6 |
| 027165740 | C112AFETUAL1 |
| 079420377 | C112BKR3N6U6 |
| 041371407 | C112EA93WK45 |
| 078859351 | C112MNP6S585 |
| 561202525 | C112XJF97T95 |
| 007507845 | C113E4798JC5 |
| 078701656 | C113F9JLF4D9 |
| 031063931 | C113JMW3WGS7 |
| 627345189 | C113LMD4SNH5 |
| 118204519 | C113MJ7NGPT9 |
| 808838705 | C113NA791JP9 |
| 117817991 | C113PAZ2CKD7 |
| 040901787 | C113UKGDACE7 |
| 786101597 | C113Y844DE35 |
| 832953199 | C114AG5RHN43 |
| 118032688 | C114FEYK19L5 |
| 832298454 | C114GMCDP475 |
| 155246390 | C114LMMJ61L5 |
| 792254422 | C114PFVZLMU6 |
| 111142399 | C115ANT52W47 |
| 967488276 | C115HRKETCN8 |
| 063802250 | C115J41MGLP5 |
| 879401255 | C115TCG3UFD7 |
| 021321979 | C115XJJJM3N5 |
| 118267497 | C115ZDCMMR37 |
| 045215717 | C116AZQCPMB9 |
| 175088632 | C116F38TK319 |
| 947803362 | C116KLN64EG7 |
| 828278346 | C116L3VC4TS3 |
| 126200158 | C116MESFPCK1 |
| 117634715 | C116NN3P3L83 |
| 159052609 | C116SQKDS137 |
| 800235939 | C117CYDJWMG1 |
| 080739341 | C117LV1CRFJ5 |
| 081029975 | C117ML2B8PT5 |
| 117620595 | C117N2MRMER8 |
| 364025114 | C117TJEWEPF5 |
| 079673550 | C117YL4KLRK6 |
| 013976295 | C118C4V35RJ7 |
| 792927357 | C118PJH389B9 |
| 835952185 | C119Q54MAYK5 |
| 829586767 | C119ZNWZD713 |
| 784429123 | C11AC96DBGE7 |
| 202958468 | C11AHU5D9CF3 |
| 078433755 | C11AKLK388H9 |
| 831089979 | C11ANBUMXMW1 |
| 827388161 | C11BE3DNZH55 |
| 009314111 | C11CR8G26LG5 |
| 188466192 | C11CYRNRYGM9 |
| 078314660 | C11DADSBEB17 |
| 018607002 | C11DF6CGKH37 |
| 606960610 | C11DGN39BG59 |
| 605043194 | C11DJWNNDQZ9 |
| 962323510 | C11DKDWW4HQ8 |
| 131071060 | C11DMEJMGZ95 |
| 140988325 | C11DWNTCPGG9 |
| 079955234 | C11DYQR1JG55 |
| 044553345 | C11EA5LT26X3 |
| 604179791 | C11EDJMRK1K9 |
| 693709427 | C11ENX27JHM5 |
| 116956103 | C11EPF3JMH15 |
| 315551861 | C11FD6GS6N19 |
| 962718813 | C11FGL674S25 |
| 803610331 | C11FHAQZ8RX6 |
| 339096121 | C11FJKCALRY5 |
| 421296811 | C11FM4VGNK64 |
| 080157486 | C11FW9DW7PG8 |
| 930875484 | C11GAF7MCP36 |
| 194778171 | C11GXLCB8VK3 |
| 091102892 | C11HGLJUQ6D8 |
| 140314894 | C11HKGNN71F7 |
| 010223626 | C11JBCN7TN45 |
| 006261121 | C11JGYMK2LN7 |
| 050614296 | C11JJKBH9HM6 |
| 054132899 | C11JKHK6NFJ1 |
| 114932325 | C11JMEM91MT9 |
| 852437128 | C11JNA4JM5Y6 |
| 789084118 | C11JSYY9KMK7 |
| 118074029 | C11JWMS5JRE5 |
| 078391204 | C11KF8ENJ8T4 |
| 081235450 | C11KK3MFH4L7 |
| 068382779 | C11KLYUPKN88 |
| 016505192 | C11LGLYZNTK8 |
| 833252351 | C11LKJMBKEL5 |
| 801267761 | C11LVZHVXX74 |
| 131608523 | C11LW2AP6GM5 |
| 828477120 | C11LZ8SGLJL7 |
| 861238106 | C11MDDK85WJ1 |
| 079626740 | C11MPAMBKM29 |
| 968607726 | C11MRQ1EN8D7 |
| 801941407 | C11MUREN3F57 |
| 838216559 | C11NBBXB8K45 |
| 176093859 | C11NF78326Y1 |
| 078369911 | C11NKCQ6UD17 |
| 008181497 | C11NSHXXJDG1 |
| 557815802 | C11NVJUU2DS5 |
| 001016930 | C11PJRKZ4VL1 |
View definition
CREATE VIEW uei_crosswalk AS SELECT * FROM read_parquet(main.list_value('/data/usaspending/uei_crosswalk.parquet'));