Does anyone have a dataset of the location distribution of each publicly traded restaurant?

Help
,
#1

Hello, does anyone have a dataset of the location distribution of each publicly traded restaurant? (I am currently conducting a research of investigating the effect of COVID-19 on publicly traded restaurants.) Thank you so much!

#2

@Jifan_He Have you tried perhaps the WRDS data sets?

#3

Is it in Safe Graph?

#4

@Jifan_He No. It’s a subscription database that business school usually purchase. It would have the NAICS codes for publicly traded restaurants.

#5

OK, I will look that first. Thanks!

#6

@Jifan_He If you need help, I can take a look as well.

#7

Ok, could you take a look if you have time? I will also search it and ask my school.

#8

SafeGraph data has all restaurants (public and private) in the US

#9

Where? In Core Places?

#10

Do I have to buy?

#11

@Jifan_He The two items you need are the patterns data and the core places. Then, the two need to be merged. If it would be helpful, I can send you R or STATA code to get started.

#12

yeah. Could you send me that? (My initial thought is Panel Data model, so the time fixed effect (plm package from R) is my current focus.)

#13

And my Professor suggests me to see the location information for these restaurants, and that’s why I am currently looking for …

#14

@Jifan_He You need to download the Core Places data and the monthly patterns data.

#15

Yeah, when I clicked “Preview”, and chose notepad for the main app, it turns out to this:

#16

‹Î”ù^ core-places-us-only.csv …TQoÛ6~ï¯ ô°=ìb%‘ykÒi‘¤EÜŠ@ ¥“ET=Šjûï;YqãmɽyOßÝ}wÉÜ»kË]g+,]@²³ûX&gt;ëë|e£ó}ÙÛ-Òù ´¶¯ 4ÐíÞžŒèw%=Àz\{몡¬|=Eê(ngÓ÷›ƒ=Ä€K[ׇ)dåâô6à†hLlýmwˆâOæØÇðp¸Úµ¾Ç²·ktô;ìËÖaì‘LífH^ ›sÎEªDƒFÙu¾®ól½Ö¼ÈŒ¶ÊÞw5[º€c@¶ªZï; ¸l9ÞØvIõc+_]…Ë÷¹TJpH‹…6¼H œ )BèT‚ÑŠÝø7–ÝÕpmû€1"\¾£2eà·ü"ŒÌ¤V*•’ï,In¨É9ûü9I4å‘$@—¢8Oɼ¿ŸG<ø„õ©íx±îbeã1Æ™ö=û+¹ÒH¡UÑ®*“Ú¼nTAMHEu->’>[öú+ö#²6|¡ú’7ÔŽq; »rCôÁU¶c+©ÔŒÔHæÖu6°·ý0 m1)àÖÆ1Ì1†=ì}l1<†BHa8(¹Y&x
gÚ,¸Î¤ eÆ’R«w¾úÒøPÃÛkÈå0µ©ÕMÃUQ«¢²:Ï…¥ÌLj¸É«ƒ˜g\Z.Œ^Ss¹škÛ˜J6¹A©áŠäMw]g7È>¹ö»vŽ>S).ìs¸y¢ä¤_©,s¢Bå)%Z¨…”\Ë
™v™Lí#¸ý‰YΪ̄–9VÿTå¿(Ò’mÌ2ù_‚Ið%È‘…ü‘âráÿAÆþÈ= 6ç¹È1k(ëLg–ËÜòušf´Y× Ki ñç©;wHk¤
÷+¿~Ã>L«v€åØug«‚= òËLP|a”ÖRí[#2•e)H®Øg·ž‚^W“6hDàÊ~‹ÔëÛw@{Œç냖Ž¢gÓð`M£è’h{¶ô¾†ÕÖûØ:$i½’6ÀŠsé¼õ»äÕß61A

#17

I have no idea about how to fix this … (So, would I contact the manager?)

#18

Wait, it seems like your computer interface has different options than me. You have “Web” and “CRL”, but I only have “Contact Us” and “Preview” …

#19

@Jifan_He - did you sign a form when you joined the community with your university information? if you did you should be good to go otherwise @Jack_Lindsay_Kraken1 may be able to assist

#20

Thread continues HERE

Sorry guys, meant to link theses. Didn’t know 2 threads were going