However I don't need help running queries, I need help with the dynamic solution to make the reports viewable like we did for these 1 million people...
Can you explain i more detail what you are asking for? I can run the queries through Crystal Reports and create graphs for you if that's what you're looking for...?
Thank you so much I appreciate it and don't want to miss an opportunity, so I try to explain it here briefly that is explained in my documented collaboration with Aravind from Vaccine Data Science, See Arvind's write-ups and read the few comments because they are mostly mine here:
I'm familiar with crystal reports, and we are on the right track however instead of graphs I want the ability to produce a registrants unique reports with all details included for that registrant ID# like the visual representation Aravind has done. ICAN's dashboard as an example can query a few data fields for a macro view, but you can then ask the Power BI dashboard to show me just one unique registrant report.
Aravind and I have now been able to add this unique view functionality to view single reports, but only for the ~1million registrants pre defined data set. There are over 10M unique registrants so I'm trying to figure out how to work through this challenge and gain the ability to "view" each and every report. Medalerts.org which is geared to VAERS as an example can technically produce all 2.6M reports back to 1990, but without the fancy visualizations and graphs of Tableau. So I'm trying to bring the best of both worlds together, I have the fancy bells and whistles of Tableau but I'm needing the infrastructure to visualize ALL individual reports. I currently "iframe" medalerts.org "report view" into vaersaware.com. I am currently doing the same and VSAFE and iframing Arvind's VSAFE report view into vaersaware/vsafe.
In the perfect world Aravind could just do exactly what he did for these 1M registrants but do it for all 10M. But he can't either for limitations of github or his own server or hardware or whatever? Everybody has been operating under free licenses so I'm not sure if it's a matter of needing some paid upgrade to github for more space and resources or what?
This project would not be a one off custom report gathering mission, the objective is to create a free VSAFE Interactive dashboard with all the visualizations (graphs) in addition to jumping in a reading individual reports like VAERS. Thanks for your interest and if you are still interested let's comm off line. welcometheeagle88@protonmail.com
If the VSAFE databse can be downloaded like VAERS, I can do so and run any queries/reports you'd like on the data. Let me know.
You can download VSAFE into it's .csv format no problem here: https://icandecide.org/v-safe-data/
However I don't need help running queries, I need help with the dynamic solution to make the reports viewable like we did for these 1 million people...
Can you explain i more detail what you are asking for? I can run the queries through Crystal Reports and create graphs for you if that's what you're looking for...?
Thank you so much I appreciate it and don't want to miss an opportunity, so I try to explain it here briefly that is explained in my documented collaboration with Aravind from Vaccine Data Science, See Arvind's write-ups and read the few comments because they are mostly mine here:
https://vaccinedatascience.substack.com/p/v-safe-visualization-tool-with-dynamic
https://vaccinedatascience.substack.com/p/improvements-to-the-v-safe-visualization
https://vaccinedatascience.substack.com/p/i-have-added-200k-v-safe-records
I'm familiar with crystal reports, and we are on the right track however instead of graphs I want the ability to produce a registrants unique reports with all details included for that registrant ID# like the visual representation Aravind has done. ICAN's dashboard as an example can query a few data fields for a macro view, but you can then ask the Power BI dashboard to show me just one unique registrant report.
Aravind and I have now been able to add this unique view functionality to view single reports, but only for the ~1million registrants pre defined data set. There are over 10M unique registrants so I'm trying to figure out how to work through this challenge and gain the ability to "view" each and every report. Medalerts.org which is geared to VAERS as an example can technically produce all 2.6M reports back to 1990, but without the fancy visualizations and graphs of Tableau. So I'm trying to bring the best of both worlds together, I have the fancy bells and whistles of Tableau but I'm needing the infrastructure to visualize ALL individual reports. I currently "iframe" medalerts.org "report view" into vaersaware.com. I am currently doing the same and VSAFE and iframing Arvind's VSAFE report view into vaersaware/vsafe.
In the perfect world Aravind could just do exactly what he did for these 1M registrants but do it for all 10M. But he can't either for limitations of github or his own server or hardware or whatever? Everybody has been operating under free licenses so I'm not sure if it's a matter of needing some paid upgrade to github for more space and resources or what?
This project would not be a one off custom report gathering mission, the objective is to create a free VSAFE Interactive dashboard with all the visualizations (graphs) in addition to jumping in a reading individual reports like VAERS. Thanks for your interest and if you are still interested let's comm off line. welcometheeagle88@protonmail.com
God Bless
Thank you for bringing this out in the open.
A bit out of topic:
Does anybody know since when exactly they provided the Code 10085503 "POST-ACUTE COVID-19 SYNDROME" in VAERS?
I report came from a vaccination on date Dec 19 2020... There are 1382 reports total:
https://medalerts.org/vaersdb/findfield.php?TABLE=ON&GROUP1=CAT&EVENTS=ON&SYMPTOMS=Post-acute+COVID-19+syndrome+%2810085503%29
.
My favorite parts of Covid:
#71
Dopes on Dope.
They are just doctors.
… History’s Jekyll’s.
.