Contract work related to venue Donations list website for Vipul Naik

Table of contents

Task payments due for tasks related to venue Donations list website by type and year

Task typeTotal across yearsTotal in year 2022Total in year 2021Total in year 2020Total in year 2019Total in year 2018Total in year 2017
Coding 3,689.36 29.55 68.87 141.60 410.34 1,839.00 1,200.00
Data entry 613.28 0.00 0.00 0.00 0.00 168.28 445.00
Preliminary research 11.40 0.00 0.00 0.00 11.40 0.00 0.00
Consulting 7.79 6.84 0.95 0.00 0.00 0.00 0.00
Total 4,321.83 36.39 69.82 141.60 421.74 2,007.28 1,645.00

Graph of task payments due by type and year (incremental, not cumulative)

Graph of payments should have loaded here

Graph of task payments due by type and year (cumulative)

Graph of payments should have loaded here

Task payments due for tasks related to venue Donations list website by payer and year

Task payerTotal across yearsTotal in year 2022Total in year 2021Total in year 2020Total in year 2019Total in year 2018Total in year 2017
Vipul Naik4,246.8336.3969.82141.60421.742,007.281,570.00
Peter Hurford75.000.000.000.000.000.0075.00
Total4,321.8336.3969.82141.60421.742,007.281,645.00

Graph of task payments due by payer and year (incremental, not cumulative)

Graph of payments should have loaded here

Graph of task payments due by payer and year (cumulative)

Graph of payments should have loaded here

Task payments due for tasks related to venue Donations list website by worker and year

Task workerTotal across yearsTotal in year 2022Total in year 2021Total in year 2020Total in year 2019Total in year 2018Total in year 2017
Issa Rice4,321.8336.3969.82141.60421.742,007.281,645.00
Total4,321.8336.3969.82141.60421.742,007.281,645.00

Graph of task payments due by worker and year (incremental, not cumulative)

Graph of payments should have loaded here

Graph of task payments due by worker and year (cumulative)

Graph of payments should have loaded here

Task payments due for tasks related to venue Donations list website by type and month

MonthTotal across task typesCodingData entryPreliminary researchConsulting
2022-0610.7410.740.000.000.00
2022-056.840.000.000.006.84
2022-0418.8118.810.000.000.00
2021-126.846.840.000.000.00
2021-0662.0362.030.000.000.00
2021-010.950.000.000.000.95
2020-0712.1612.160.000.000.00
2020-0514.5414.540.000.000.00
2020-01114.90114.900.000.000.00
2019-128.848.840.000.000.00
2019-0911.400.000.0011.400.00
2019-0614.0614.060.000.000.00
2019-0569.9269.920.000.000.00
2019-04166.73166.730.000.000.00
2019-0333.0933.090.000.000.00
2019-0242.4742.470.000.000.00
2019-0175.2375.230.000.000.00
2018-128.760.008.760.000.00
2018-1153.980.0053.980.000.00
2018-1066.440.0066.440.000.00
2018-0939.100.0039.100.000.00
2018-08215.00215.000.000.000.00
2018-07146.00146.000.000.000.00
2018-0655.0055.000.000.000.00
2018-0578.0078.000.000.000.00
2018-04250.00250.000.000.000.00
2018-0370.0070.000.000.000.00
2018-02350.00350.000.000.000.00
2018-01675.00675.000.000.000.00
2017-12260.00260.000.000.000.00
2017-09200.00200.000.000.000.00
2017-08400.00400.000.000.000.00
2017-07300.00300.000.000.000.00
2017-0640.0040.000.000.000.00
2017-04230.000.00230.000.000.00
2017-0360.000.0060.000.000.00
2017-01155.000.00155.000.000.00
Total across months4,321.833,689.36613.2811.407.79

Graph of task payments due by type and month (incremental, not cumulative)

Graph of payments should have loaded here

Graph of task payments due by type and month (cumulative)

Graph of payments should have loaded here

Task payments due for tasks related to venue Donations list website by payer and month

MonthTotal across task payersVipul NaikPeter Hurford
2022-0610.7410.740.00
2022-056.846.840.00
2022-0418.8118.810.00
2021-126.846.840.00
2021-0662.0362.030.00
2021-010.950.950.00
2020-0712.1612.160.00
2020-0514.5414.540.00
2020-01114.90114.900.00
2019-128.848.840.00
2019-0911.4011.400.00
2019-0614.0614.060.00
2019-0569.9269.920.00
2019-04166.73166.730.00
2019-0333.0933.090.00
2019-0242.4742.470.00
2019-0175.2375.230.00
2018-128.768.760.00
2018-1153.9853.980.00
2018-1066.4466.440.00
2018-0939.1039.100.00
2018-08215.00215.000.00
2018-07146.00146.000.00
2018-0655.0055.000.00
2018-0578.0078.000.00
2018-04250.00250.000.00
2018-0370.0070.000.00
2018-02350.00350.000.00
2018-01675.00675.000.00
2017-12260.00260.000.00
2017-09200.00200.000.00
2017-08400.00325.0075.00
2017-07300.00300.000.00
2017-0640.0040.000.00
2017-04230.00230.000.00
2017-0360.0060.000.00
2017-01155.00155.000.00
Total across months4,321.834,246.8375.00

Graph of task payments due by payer and month (incremental, not cumulative)

Graph of payments should have loaded here

Graph of task payments due by payer and month (cumulative)

Graph of payments should have loaded here

Task payments due for tasks related to venue Donations list website by worker and month

MonthTotal across task workersIssa Rice
2022-0610.7410.74
2022-056.846.84
2022-0418.8118.81
2021-126.846.84
2021-0662.0362.03
2021-010.950.95
2020-0712.1612.16
2020-0514.5414.54
2020-01114.90114.90
2019-128.848.84
2019-0911.4011.40
2019-0614.0614.06
2019-0569.9269.92
2019-04166.73166.73
2019-0333.0933.09
2019-0242.4742.47
2019-0175.2375.23
2018-128.768.76
2018-1153.9853.98
2018-1066.4466.44
2018-0939.1039.10
2018-08215.00215.00
2018-07146.00146.00
2018-0655.0055.00
2018-0578.0078.00
2018-04250.00250.00
2018-0370.0070.00
2018-02350.00350.00
2018-01675.00675.00
2017-12260.00260.00
2017-09200.00200.00
2017-08400.00400.00
2017-07300.00300.00
2017-0640.0040.00
2017-04230.00230.00
2017-0360.0060.00
2017-01155.00155.00
Total across months4,321.834,321.83

Graph of task payments due by worker and month (incremental, not cumulative)

Graph of payments should have loaded here

Graph of task payments due by worker and month (cumulative)

Graph of payments should have loaded here

Full list of tasks in reverse chronological order (40 tasks)

WorkerTask typeTask receptacleCompletion datePayerPaymentTopicFormatTime spent (hours:minutes)Effective pay per hourNotes
Issa RiceCodingN/A2022-06-16Vipul Naik10.74PhilanthropyN/A1:089.48Spent 68 minutes at $9.50/hour. Work on reviewing some scripts to monitor foundation grants. Work done 2022-06-16.
Issa RiceConsultingN/A2022-05-12Vipul Naik6.84PhilanthropyN/A0:439.54Work replying to an inbound query somewhat related to DLW. Work done 2022-05-12.
Issa RiceCodingAdd theme changer2022-04-10Vipul Naik18.81PhilanthropyCode1:599.48Work done 2022-04-10 at https://github.com/vipulnaik/donations/pull/140 extending dark mode, previously developed for AI Watch / Org Watch, to the donations list website.
Issa RiceCodingSeparate out reset and read by table in Makefile2021-12-24Vipul Naik6.84PhilanthropyCode0:439.54Work done 2021-12-24. Work at https://github.com/vipulnaik/donations/pull/139 for https://github.com/vipulnaik/donations/issues/138
Issa RiceCodingShow original currency info in notes column2021-06-16Vipul Naik24.03PhilanthropyCode2:329.49Spent 2 hours 32 minutes at $9.50/hour. Work on https://github.com/vipulnaik/donations/pull/135 for https://github.com/vipulnaik/donations/issues/134 (currency info display). Work done 2021-06-09 to 2021-06-16.
Issa RiceCodingExplore the creation of graphical timelines for donors; Rename "Open Philanthropy Project" -> "Open Philanthropy"2021-06-04Vipul Naik38.00PhilanthropyCode3:0012.67Spent 3 hours for max($38, $9.50 * number of hours). Work on https://github.com/vipulnaik/donations/issues/125 and https://github.com/vipulnaik/donations/issues/129 started last year (2020-12-16 to 2020-12-18) and wrapped up 2021-06-04.
Issa RiceConsultingN/A2021-01-25Vipul Naik0.95PhilanthropyN/A0:069.50Spent 6 minutes at $9.50/hour. Work done 2021-01-25. This was to help answer some questions over email.
Issa RiceCodingN/A2020-07-13Vipul Naik12.16PhilanthropyCode1:179.48Work to fix a backend script. Work done 2020-07-10 to 2020-07-13.
Issa RiceCodingImprove the way we deal with renamings for donors and donees2020-05-19Vipul Naik14.54PhilanthropyCode1:329.48Work done 2020-05-18 and 2020-05-19
Issa RiceCodingMove completely to a safe query structure on donations.vipulnaik.com2020-01-20Vipul Naik75.00PhilanthropyCode3:2422.06Work done on 2020-01-20. Payment determined as max{$75, $9.50/hour * 3.41 hours}
Issa RiceCodingExplore the creation of graphical timeline for donors, donees, and donor-donee pairs based on intended_funding_timeframe_in_months2020-01-08Vipul Naik39.90PhilanthropyCode4:129.50Work done on 2020-01-08. See https://github.com/vipulnaik/donations/issues/125#issuecomment-572384312 for a summary of the work done. This is part of a multi-month effort on the issue
Issa RiceCodingFix regex for donor and donee document list matching2019-12-19Vipul Naik8.84PhilanthropyCode0:569.47Fix for a regex bug https://github.com/vipulnaik/donations/issues/126 at the request of Vipul; all work done within one day 2019-12-19
Issa RicePreliminary researchExplore the creation of graphical timeline for donors, donees, and donor-donee pairs based on intended_funding_timeframe_in_months2019-09-18Vipul Naik11.40PhilanthropyCode and comments1:129.50Exploratory work related to graphical timelines. The results are recorded in the comments on https://github.com/vipulnaik/donations/issues/125
Issa RiceCodingDonations list website2019-06-30Vipul Naik14.06PhilanthropyCode and data1:299.48See https://github.com/vipulnaik/donations/commits?author=riceissa&since=2019-06-01&until=2019-07-01 for the work done. Work was done between 2019-06-20 and 2019-05-30
Issa RiceCodingDonations list website2019-05-13Vipul Naik69.92PhilanthropyCode and data7:229.49See https://github.com/vipulnaik/donations/commits?author=riceissa&since=2019-05-01&until=2019-06-01 for the work done. Work was done between 2019-05-01 and 2019-05-13
Issa RiceCodingDonations list website2019-04-28Vipul Naik166.73PhilanthropyCode and data17:339.50See https://github.com/vipulnaik/donations/commits?author=riceissa&since=2019-04-01&until=2019-05-01 for the work done. Work was done between 2019-04-08 and 2019-04-28
Issa RiceCodingDonations list website2019-03-27Vipul Naik33.09PhilanthropyCode and data3:299.50See https://github.com/vipulnaik/donations/commits?author=riceissa&since=2019-03-01&until=2019-04-01 for the work done. Work was done between 2019-03-10 and 2019-03-27
Issa RiceCodingDonations list website2019-02-26Vipul Naik42.47PhilanthropyCode and data4:299.47Most of the focus was on adding various kinds of donation statistics that are particularly useful for large donors who have made lots of donations. Work was done between 2019-02-02 and 2019-02-26
Issa RiceCodingDonations list website2019-01-21Vipul Naik75.23PhilanthropyCode and data8:518.50Most of the focus was on writing code to process grants lists for a number of foundation donors. See issues #89 to #107 (not all of them were completed or worked on within the month of January). Work was done between 2019-01-10 and 2019-01-21
Issa RiceData entryDonations list website2018-12-27Vipul Naik8.76PhilanthropyCode and data1:028.48Most of the focus was on adding metadata for a number of donees. Work was done between 2018-12-05 and 2018-12-27
Issa RiceData entryDonations list website2018-11-29Vipul Naik53.98PhilanthropyCode and data6:218.50Most of the focus was on adding metadata for a number of donees. Work was done between 2018-11-06 and 2018-11-29
Issa RiceData entryDonations list website2018-10-22Vipul Naik66.44PhilanthropyCode and data7:498.50Most of the focus was on adding metadata for a number of donees. Work was done between 2018-10-05 and 2018-10-22
Issa RiceData entryDonations list website2018-09-21Vipul Naik39.10PhilanthropyCode and data4:368.50Work on MIRI top donors updates and BERI grants. Work done between 2018-09-01 and 2018-09-21. See https://github.com/vipulnaik/donations/commits/master/sql?author=riceissa and check the September 2018 commits for more information
Issa RiceCodingDonations list website2018-08-30Vipul Naik215.00PhilanthropyCode and data25:188.50Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in August 2018 on http://github.com/vipulnaik/donations/issues for more information. Dates of work ranged from August 5 to August 30
Issa RiceCodingDonations list website2018-07-31Vipul Naik146.00PhilanthropyCode and data17:118.50Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in July 2018 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2018-06-30Vipul Naik55.00PhilanthropyCode and data6:278.53Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in June 2018 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2018-05-31Vipul Naik78.00PhilanthropyCode and data9:088.54Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in May 2018 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2018-04-30Vipul Naik250.00PhilanthropyCode and data29:438.41Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in April 2018 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2018-03-31Vipul Naik70.00PhilanthropyCode and data8:128.54Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in March 2018 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2018-02-28Vipul Naik350.00PhilanthropyCode and data41:008.54Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in February 2018 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2018-01-31Vipul Naik675.00PhilanthropyCode and data79:208.51Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in January 2018 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2017-12-30Vipul Naik260.00PhilanthropyCode and data30:188.58Work on a bunch of issues related to importing grants databases for different donors into the donations list website. See comments made in December 2017 on http://github.com/vipulnaik/donations/issues for more information.
Issa RiceCodingDonations list website2017-09-30Vipul Naik200.00Philanthropy/tabular presentationCodeSee commits from September 28 to September 30 by Issa Rice, specifically https://github.com/vipulnaik/donations/commits?author=riceissa&since=2017-09-28T07:00:00Z&until=2017-10-01T07:00:00Z for the full list. This included incorporating data from the Effective Altruism Survey (separate repository https://github.com/riceissa/ea-survey-donations with 12 commits) and Effective Altruism Grants (separate repository https://github.com/riceissa/ea-grants-processing/commits?author=riceissa&since=2017-09-01T07:00:00Z&until=2017-10-01T07:00:00Z with 6 commits)
Issa RiceCodingDonation amounts by disclosures and year2017-08-12Peter Hurford75.00Philanthropy/Open Philanthropy ProjectTableSchema design, data entry, and coding to render tables in the Donations list website for Open Philanthropy Project grant-related relationship disclosures data
Issa RiceCodingDonations list website2017-08-12Vipul Naik325.00Philanthropy/tabular presentationCodeSee commits by riceissa from 2017-08-04 to 2017-08-12. Work was for 6.5 working days, spanning 8.5 calendar days
Issa RiceCodingDonee deduplication, donor similarity, notes column expansion2017-07-22Vipul Naik300.00Graphs and data cleaningCodeSee the branches https://github.com/vipulnaik/donations/tree/donee-deduplication https://github.com/vipulnaik/donations/tree/donor-similarity and https://github.com/vipulnaik/donations/tree/notes-col-expansion for the relevant commits. Some commits done directly in master. Worked for about 5.5 working days (starting July 15, 2017)
Issa RiceCodingComma sorting2017-06-18Vipul Naik40.00DonationsCodeFixed sorting tool we use in JavaScript so that it can sort tables while also using comma separation for greater ease of reading numbers. The commits were all made in https://github.com/vipulnaik/donations/tree/comma-sort and https://github.com/vipulnaik/donations/commit/f7f99b4f0db39d3147d72a5a7f8f30f856fa4e9f was the last commit
Issa RiceData entryBill and Melinda Gates Foundation2017-04-23Vipul Naik230.00Foundation grantsCode and dataProcessed Bill and Melinda Gates Foundation grants from IATI at https://iatiregistry.org/publisher/bmgf to generate data for insertion in donations database. Code available at https://github.com/riceissa/gates-foundation-iati-processing -- run the commands there and then pass the generated SQL to the donations database
Issa RiceData entryLaura and John Arnold Foundation2017-03-22Vipul Naik60.00Foundation grantsCode and dataProcessed Arnold Foundation grants to generate data for insertion in donations database. Code available at https://github.com/riceissa/arnold-foundation-grants and insertion code can be pasted from https://github.com/riceissa/arnold-foundation-grants in MySQL
Issa RiceData entryDonations list website2017-01-08Vipul Naik155.00Effective altruism/donation historyStructured dataDesigned SQL tables and provided initial set of rows to insert