../../_images/badge-colab.svg ../../_images/badge-github-custom.svg

Enriching Grants part 1: Matching your grants records to Dimensions

In this tutorial we are going to match a sample local grants datasets to Dimensions.

By matching we mean discovering the unique Dimensions identifier for these grants, so that we can then use the IDs to extract from Dimensions more related objects (eg researchers, publications, patents, clinical trials etc.. related to the grants).

A sample grants list

Our starting point is a sample list of completed grants on the topic of vaccines, which contains common fields such as title, funder, grant/project ID, funding amount etc..

We will show below how to enrich this dataset with Dimensions IDs.

Prerequisites

This notebook assumes you have installed the Dimcli library and are familiar with the Getting Started tutorial.

[1]:
!pip install dimcli tqdm -U --quiet

import dimcli
from dimcli.shortcuts import *
import sys, time
import pandas as pd


print("==\nLogging in..")
# https://github.com/digital-science/dimcli#authentication
ENDPOINT = "https://app.dimensions.ai"
if 'google.colab' in sys.modules:
  import getpass
  USERNAME = getpass.getpass(prompt='Username: ')
  PASSWORD = getpass.getpass(prompt='Password: ')
  dimcli.login(USERNAME, PASSWORD, ENDPOINT)
else:
  USERNAME, PASSWORD  = "", ""
  dimcli.login(USERNAME, PASSWORD, ENDPOINT)
dsl = dimcli.Dsl()
==
Logging in..
Dimcli - Dimensions API Client (v0.7.5)
Connected to: https://app.dimensions.ai - DSL v1.28
Method: dsl.ini file

Loading the sample grants data

First we are going to load the sample dataset “vaccines-grants-sample-part-0.csv”.

[2]:
grants_source = pd.read_csv("http://api-sample-data.dimensions.ai/data/vaccines-grants-sample-part-0.csv")

Now we can preview the contents of the file.

[3]:
grants_source.head(5)
[3]:
Grant Number Title Funding Amount in USD Start Year End Year Funder Funder Country
0 30410203277 疫苗-整体方案 1208.0 2004 2004 National Natural Science Foundation of China China
1 620792 Engineering Inhalable Vaccines 26956.0 2017 2018 Natural Sciences and Engineering Research Council Canada
2 599115 Engineering Inhalable Vaccines 26403.0 2016 2017 Natural Sciences and Engineering Research Council Canada
3 251564 HIV Vaccine research 442366.0 2003 2007 National Health and Medical Research Council Australia
4 334174 HIV Vaccine Development 236067.0 2005 2009 National Health and Medical Research Council Australia

Matching grants data

The are two possible situations to consider.

A) Matching grants when we have a grant number

The Dimensions API includes a special function ``extract_grants` <https://docs.dimensions.ai/dsl/functions.html#function-extract-grants>`__ that makes it easier to find a grant in Dimensions, by using information such as funder name and the funder grant identifier.

So one approach is the following:

[4]:
dsl.query("""extract_grants(grant_number="30410203277",
    funder_name="National Natural Science Foundation of China")""").json
[4]:
{'grant_id': 'grant.8172033'}
[5]:
dsl.query("""extract_grants(grant_number="334174",
    funder_name="National Health and Medical Research Council")""").json
[5]:
{'grant_id': 'grant.6722306'}

Note: this won’t work without funder name

[6]:
dsl.query("""extract_grants(grant_number="30410203277",
    funder_name="")""").json
[6]:
{'grant_id': None}

But we can pass a fundref ID if we have it (also available via GRID)

[7]:
dsl.query("""extract_grants(grant_number="30410203277",
    fundref="501100001809")""").json
[7]:
{'grant_id': 'grant.8172033'}

B) What if we don’t have a grant number?

Then the only way is to * query Dimensions using the best grants metadata we have available * if we get only one result, we just take it * if we get more than one result, we need to manually review them at a later point, or develop some sort of algorithm to sort them by relevancy so that we can take the first result

Let’s take some of the grants without a number:

[8]:
grants_without_number = grants_source[grants_source['Grant Number'].isnull()]
[9]:
grants_without_number.head(5)
[9]:
Grant Number Title Funding Amount in USD Start Year End Year Funder Funder Country
38 NaN DENGUE VACCINE DEVELOPMENT 50000.0 1985 1986 United States Department of the Army United States
79 NaN Sterilization Vaccine for Cattle 0.0 2006 2006 Council for International Exchange of Scholars United States
80 NaN Vaccine Production in Plants 0.0 2011 2011 Council for International Exchange of Scholars United States
81 NaN Novel vaccine formulations against tuberculosis 295003.0 2002 2005 Canadian Institutes of Health Research Canada
446 NaN Development of recombinant TB vaccine 101459.0 1999 2003 Canadian Institutes of Health Research Canada

Now let’s try to find the second grant in the list above, using only its title and the funder country

[10]:
%%dsldf

search grants
    in title_only for "Vaccine Production in Plants"
    where funder_countries.name="United States"
return grants
Returned Grants: 1 (total = 1)
Time: 0.64s
[10]:
title_language project_num language funding_org_name end_date funders id start_date title start_year original_title active_year
0 en N/A en Council for International Exchange of Scholars 2011-09-30 [{'id': 'grid.497587.0', 'city_name': 'Washing... grant.7685445 2011-01-01 Vaccine Production in Plants 2011 Vaccine Production in Plants [2011]
[11]:
# we're in luck! only one record found
print("The Dimensions ID is: ", dsl_last_results.iloc[0]['id'])
The Dimensions ID is:  grant.7685445

Back to our grants list

We can set up a loop to go through all the grants we want to get a Dimensions ID for, so that we can enrich our original dataset with those IDs. A simple approach is the following:

  • we try to use the extract_grants function first

  • second we try the search operation as a fall back plan

    • if that returns more than one record, we simply take the first one (even though in real life we’d want a more sophisticated approach)

  • note: we pause a second after each query to ensure we don’t hit the max queries quota (~30 per minute)

NOTE For the purpose of this exercise, you can select less that the ~1200 grants in the original list, so to speed things up.

[12]:
grants = grants_source[:1200].copy()
[13]:
grants.head(10)
[13]:
Grant Number Title Funding Amount in USD Start Year End Year Funder Funder Country
0 30410203277 疫苗-整体方案 1208.0 2004 2004 National Natural Science Foundation of China China
1 620792 Engineering Inhalable Vaccines 26956.0 2017 2018 Natural Sciences and Engineering Research Council Canada
2 599115 Engineering Inhalable Vaccines 26403.0 2016 2017 Natural Sciences and Engineering Research Council Canada
3 251564 HIV Vaccine research 442366.0 2003 2007 National Health and Medical Research Council Australia
4 334174 HIV Vaccine Development 236067.0 2005 2009 National Health and Medical Research Council Australia
5 910292 Dengue virus vaccine. 130890.0 1991 1993 National Health and Medical Research Council Australia
6 578221 Engineering Inhalable Vaccines 27386.0 2015 2016 Natural Sciences and Engineering Research Council Canada
7 IC18980360 Schistosomiasis Vaccine Network. 0.0 1998 2000 European Commission Belgium
8 7621798 Pneumococcal Ribosomal Vaccines 46000.0 1977 1980 Directorate for Biological Sciences United States
9 255890 Rational vaccine design 7138.0 2003 2004 Natural Sciences and Engineering Research Council Canada

Setting up the loop

[15]:
# load the progress bar widget for jupyter
from tqdm.notebook import tqdm as progressbar

output = []

def remove_punctuation(s):
  import string
  return s.translate(str.maketrans('', '', string.punctuation))

def find_grant_first_method(grantno, funder):
  match = dsl.query(f"""extract_grants(grant_number="{grantno}", funder_name="{funder}")""").json
  grant_id = match.get("grant_id")
  if grant_id:
    print("Found a match with method 1: ", grant_id)
    return grant_id

def find_grant_second_method(title, country):
  res = dsl.query(f"""search grants in title_only for "{title}" where funder_countries.name="{country}" return grants""")
  if not res.errors:
      if res.grants and res.grants[0].get('id'):
        grant_id = res.grants[0].get('id')
        print("=== Found a match with method 2: ", grant_id)
        return grant_id


for index, row in progressbar(grants.iterrows(), total=grants.shape[0]):
  # get data from table
  grantno, funder = row['Grant Number'], row['Funder']
  # try first method
  grant_id = find_grant_first_method(grantno, funder)
  if not grant_id:
    # try second method
    title, country = remove_punctuation(row['Title']), row['Funder Country']
    grant_id = find_grant_second_method(title, country)
    if not grant_id:
      print("Failed - skipping")
  output.append(grant_id)
  time.sleep(1)

Found a match with method 1:  grant.8172033
Found a match with method 1:  grant.7715379
Found a match with method 1:  grant.6962629
Found a match with method 1:  grant.6723913
Found a match with method 1:  grant.6722306
Found a match with method 1:  grant.6716312
Found a match with method 1:  grant.5526688
Found a match with method 1:  grant.3733803
Found a match with method 1:  grant.3274273
Found a match with method 1:  grant.2936015
Found a match with method 1:  grant.2863615
Found a match with method 1:  grant.2815666
Found a match with method 1:  grant.2807651
Found a match with method 1:  grant.2800991
Found a match with method 1:  grant.2710461
Found a match with method 1:  grant.2657659
Found a match with method 1:  grant.2640369
Found a match with method 1:  grant.2640228
Found a match with method 1:  grant.2426045
Found a match with method 1:  grant.2426044
Found a match with method 1:  grant.2426039
Found a match with method 1:  grant.2425936
Found a match with method 1:  grant.2425935
Found a match with method 1:  grant.2425932
Found a match with method 1:  grant.2425010
Found a match with method 1:  grant.2424436
Found a match with method 1:  grant.8068979
Found a match with method 1:  grant.7106480
Found a match with method 1:  grant.2639983
Found a match with method 1:  grant.2355874
Found a match with method 1:  grant.7566903
Found a match with method 1:  grant.7042623
Found a match with method 1:  grant.7040393
Found a match with method 1:  grant.6731478
Found a match with method 1:  grant.6728996
Found a match with method 1:  grant.6723289
Found a match with method 1:  grant.6718929
Found a match with method 1:  grant.6713873
Returned Grants: 20 (total = 20)
Time: 0.65s
=== Found a match with method 2:  grant.8579320
Returned Grants: 2 (total = 2)
Time: 0.58s
=== Found a match with method 2:  grant.4035473
Found a match with method 1:  grant.2987461
Found a match with method 1:  grant.2972379
Found a match with method 1:  grant.2964974
Found a match with method 1:  grant.2957579
Found a match with method 1:  grant.2950584
Found a match with method 1:  grant.2920553
Found a match with method 1:  grant.2915638
Found a match with method 1:  grant.2912254
Found a match with method 1:  grant.2880945
Found a match with method 1:  grant.2877426
Found a match with method 1:  grant.2828580
Found a match with method 1:  grant.2805504
Found a match with method 1:  grant.2795214
Found a match with method 1:  grant.2692263
Found a match with method 1:  grant.2688631
Found a match with method 1:  grant.2657670
Found a match with method 1:  grant.2640366
Found a match with method 1:  grant.2597598
Found a match with method 1:  grant.2424826
Found a match with method 1:  grant.2424691
Found a match with method 1:  grant.2424653
Found a match with method 1:  grant.2424634
Found a match with method 1:  grant.2424633
Found a match with method 1:  grant.2424632
Found a match with method 1:  grant.2424631
Found a match with method 1:  grant.2424630
Found a match with method 1:  grant.2424629
Found a match with method 1:  grant.2424455
Found a match with method 1:  grant.2424372
Found a match with method 1:  grant.2393802
Found a match with method 1:  grant.2393756
Found a match with method 1:  grant.7987079
Found a match with method 1:  grant.8217971
Found a match with method 1:  grant.8176576
Found a match with method 1:  grant.8175344
Found a match with method 1:  grant.8172020
Found a match with method 1:  grant.8166566
Found a match with method 1:  grant.7988463
Found a match with method 1:  grant.7821014
Returned Grants: 2 (total = 2)
Time: 0.80s
=== Found a match with method 2:  grant.7688859
Returned Grants: 1 (total = 1)
Time: 0.62s
=== Found a match with method 2:  grant.7685445
Returned Grants: 1 (total = 1)
Time: 0.79s
=== Found a match with method 2:  grant.7666696
Returned Errors: 1
Time: 0.60s
1 QuerySyntaxError found
1 ParserError found
  * [Line 1:34] ('200003') no viable alternative at input 'KaiserWashingtonVTEUsupplement200003'
Failed - skipping
Found a match with method 1:  grant.8633207
Found a match with method 1:  grant.8633389
Found a match with method 1:  grant.8633097
Found a match with method 1:  grant.8557183
Found a match with method 1:  grant.8554194
Found a match with method 1:  grant.8553708
Found a match with method 1:  grant.8554075
Found a match with method 1:  grant.8553908
Found a match with method 1:  grant.8473170
Found a match with method 1:  grant.8387795
Found a match with method 1:  grant.8384515
Found a match with method 1:  grant.8383668
Found a match with method 1:  grant.7909702
Found a match with method 1:  grant.7908868
Found a match with method 1:  grant.7752832
Found a match with method 1:  grant.7754464
Found a match with method 1:  grant.7752982
Found a match with method 1:  grant.7752239
Found a match with method 1:  grant.7570107
Found a match with method 1:  grant.7552760
Found a match with method 1:  grant.7519279
Found a match with method 1:  grant.7908654
Found a match with method 1:  grant.7211786
Found a match with method 1:  grant.7211819
Found a match with method 1:  grant.7172267
Found a match with method 1:  grant.7072290
Found a match with method 1:  grant.7073139
Found a match with method 1:  grant.7028511
Found a match with method 1:  grant.7026885
Found a match with method 1:  grant.7029428
Found a match with method 1:  grant.6953393
Found a match with method 1:  grant.6952716
Found a match with method 1:  grant.6953451
Found a match with method 1:  grant.6918902
Found a match with method 1:  grant.6803779
Found a match with method 1:  grant.6618975
Found a match with method 1:  grant.6618566
Found a match with method 1:  grant.6617517
Found a match with method 1:  grant.6616704
Found a match with method 1:  grant.6501723
Found a match with method 1:  grant.6377370
Found a match with method 1:  grant.6377835
Found a match with method 1:  grant.5503773
Found a match with method 1:  grant.5504846
Found a match with method 1:  grant.5503968
Found a match with method 1:  grant.5475490
Found a match with method 1:  grant.5475455
Found a match with method 1:  grant.5244126
Found a match with method 1:  grant.5244595
Found a match with method 1:  grant.5124204
Found a match with method 1:  grant.5054465
Found a match with method 1:  grant.4897681
Found a match with method 1:  grant.4897863
Found a match with method 1:  grant.4897922
Found a match with method 1:  grant.4897999
Found a match with method 1:  grant.4729155
Found a match with method 1:  grant.4454777
Found a match with method 1:  grant.4454801
Found a match with method 1:  grant.4316569
Found a match with method 1:  grant.4243510
Found a match with method 1:  grant.4244081
Found a match with method 1:  grant.4177200
Found a match with method 1:  grant.4103605
Found a match with method 1:  grant.4103659
Found a match with method 1:  grant.4102763
Found a match with method 1:  grant.4054900
Found a match with method 1:  grant.3936039
Found a match with method 1:  grant.3858813
Found a match with method 1:  grant.3801786
Found a match with method 1:  grant.3801873
Found a match with method 1:  grant.3801962
Found a match with method 1:  grant.3802322
Found a match with method 1:  grant.3625586
Found a match with method 1:  grant.3537186
Found a match with method 1:  grant.3535432
Found a match with method 1:  grant.3536099
Found a match with method 1:  grant.3535073
Found a match with method 1:  grant.3536471
Found a match with method 1:  grant.3536949
Found a match with method 1:  grant.3537031
Found a match with method 1:  grant.3535806
Found a match with method 1:  grant.3493683
Found a match with method 1:  grant.3493163
Found a match with method 1:  grant.2459965
Found a match with method 1:  grant.2440246
Found a match with method 1:  grant.2449124
Found a match with method 1:  grant.2482400
Found a match with method 1:  grant.4102133
Found a match with method 1:  grant.2482297
Found a match with method 1:  grant.2688187
Found a match with method 1:  grant.2595180
Found a match with method 1:  grant.2704745
Found a match with method 1:  grant.2459576
Found a match with method 1:  grant.4244457
Found a match with method 1:  grant.2482026
Found a match with method 1:  grant.2487364
Found a match with method 1:  grant.2691196
Found a match with method 1:  grant.2459603
Found a match with method 1:  grant.2481994
Found a match with method 1:  grant.2481879
Found a match with method 1:  grant.2695898
Found a match with method 1:  grant.2692269
Found a match with method 1:  grant.2692273
Found a match with method 1:  grant.2437148
Found a match with method 1:  grant.2528433
Found a match with method 1:  grant.2417946
Found a match with method 1:  grant.2481398
Found a match with method 1:  grant.2692276
Found a match with method 1:  grant.2690826
Found a match with method 1:  grant.2486959
Found a match with method 1:  grant.2695895
Found a match with method 1:  grant.2521249
Found a match with method 1:  grant.2692237
Found a match with method 1:  grant.2695923
Found a match with method 1:  grant.2689217
Found a match with method 1:  grant.2440235
Found a match with method 1:  grant.2699112
Found a match with method 1:  grant.2354594
Found a match with method 1:  grant.2695874
Found a match with method 1:  grant.2695875
Found a match with method 1:  grant.2480743
Found a match with method 1:  grant.2479129
Found a match with method 1:  grant.2695866
Found a match with method 1:  grant.2458536
Found a match with method 1:  grant.2612839
Found a match with method 1:  grant.2480550
Found a match with method 1:  grant.2595050
Found a match with method 1:  grant.2695854
Found a match with method 1:  grant.2668950
Found a match with method 1:  grant.2669408
Found a match with method 1:  grant.2669273
Found a match with method 1:  grant.2669252
Found a match with method 1:  grant.2668338
Found a match with method 1:  grant.2405732
Found a match with method 1:  grant.2438666
Found a match with method 1:  grant.2692241
Found a match with method 1:  grant.2440237
Found a match with method 1:  grant.2542406
Found a match with method 1:  grant.2596587
Found a match with method 1:  grant.2605071
Found a match with method 1:  grant.2605041
Found a match with method 1:  grant.2465669
Found a match with method 1:  grant.2479960
Found a match with method 1:  grant.2435850
Found a match with method 1:  grant.2661855
Found a match with method 1:  grant.2604859
Found a match with method 1:  grant.2437505
Found a match with method 1:  grant.2435348
Found a match with method 1:  grant.2527987
Found a match with method 1:  grant.2604950
Found a match with method 1:  grant.2486607
Found a match with method 1:  grant.2604757
Found a match with method 1:  grant.2480039
Found a match with method 1:  grant.2479498
Found a match with method 1:  grant.2695638
Found a match with method 1:  grant.2606994
Found a match with method 1:  grant.2604548
Found a match with method 1:  grant.2541233
Found a match with method 1:  grant.2705148
Found a match with method 1:  grant.2705159
Found a match with method 1:  grant.2689113
Found a match with method 1:  grant.2606936
Found a match with method 1:  grant.2604968
Found a match with method 1:  grant.2692215
Found a match with method 1:  grant.2692217
Found a match with method 1:  grant.7072727
Found a match with method 1:  grant.2440403
Found a match with method 1:  grant.2705137
Found a match with method 1:  grant.2705144
Found a match with method 1:  grant.2599609
Found a match with method 1:  grant.2420351
Found a match with method 1:  grant.2458098
Found a match with method 1:  grant.5504882
Found a match with method 1:  grant.2508355
Found a match with method 1:  grant.2457605
Found a match with method 1:  grant.2598957
Found a match with method 1:  grant.2604286
Found a match with method 1:  grant.2438714
Found a match with method 1:  grant.2705114
Found a match with method 1:  grant.2705125
Found a match with method 1:  grant.2689384
Found a match with method 1:  grant.2689390
Found a match with method 1:  grant.2479168
Found a match with method 1:  grant.2692202
Found a match with method 1:  grant.2602398
Found a match with method 1:  grant.2604551
Found a match with method 1:  grant.2689092
Found a match with method 1:  grant.2440219
Found a match with method 1:  grant.2705261
Found a match with method 1:  grant.2687793
Found a match with method 1:  grant.2687787
Found a match with method 1:  grant.2477898
Found a match with method 1:  grant.2659188
Found a match with method 1:  grant.2599095
Found a match with method 1:  grant.2553760
Found a match with method 1:  grant.4455400
Found a match with method 1:  grant.2457319
Found a match with method 1:  grant.2500994
Found a match with method 1:  grant.2687750
Found a match with method 1:  grant.2695778
Found a match with method 1:  grant.2485811
Found a match with method 1:  grant.2503734
Found a match with method 1:  grant.2604201
Found a match with method 1:  grant.2603843
Found a match with method 1:  grant.2550846
Found a match with method 1:  grant.2477864
Found a match with method 1:  grant.2687742
Found a match with method 1:  grant.2687738
Found a match with method 1:  grant.2435126
Found a match with method 1:  grant.2440212
Found a match with method 1:  grant.2438712
Found a match with method 1:  grant.2603257
Found a match with method 1:  grant.2603582
Found a match with method 1:  grant.2689337
Found a match with method 1:  grant.2490908
Found a match with method 1:  grant.2641176
Found a match with method 1:  grant.2440195
Found a match with method 1:  grant.2485745
Found a match with method 1:  grant.2485747
Found a match with method 1:  grant.2699292
Found a match with method 1:  grant.2699521
Found a match with method 1:  grant.2440199
Found a match with method 1:  grant.2603838
Found a match with method 1:  grant.2440200
Found a match with method 1:  grant.2603831
Found a match with method 1:  grant.2695741
Found a match with method 1:  grant.2694404
Found a match with method 1:  grant.2698983
Found a match with method 1:  grant.2698981
Found a match with method 1:  grant.2695759
Found a match with method 1:  grant.2695761
Found a match with method 1:  grant.2435110
Found a match with method 1:  grant.2455742
Found a match with method 1:  grant.2455853
Found a match with method 1:  grant.2418414
Found a match with method 1:  grant.2434755
Found a match with method 1:  grant.2440207
Found a match with method 1:  grant.2485242
Found a match with method 1:  grant.2687567
Found a match with method 1:  grant.2695737
Found a match with method 1:  grant.2689673
Found a match with method 1:  grant.2539155
Found a match with method 1:  grant.2440186
Found a match with method 1:  grant.2550162
Found a match with method 1:  grant.2440188
Found a match with method 1:  grant.2455438
Found a match with method 1:  grant.2475817
Found a match with method 1:  grant.2424052
Found a match with method 1:  grant.2438874
Found a match with method 1:  grant.2409959
Found a match with method 1:  grant.2550038
Found a match with method 1:  grant.2476088
Found a match with method 1:  grant.2455701
Found a match with method 1:  grant.2435776
Found a match with method 1:  grant.2435773
Found a match with method 1:  grant.2455566
Found a match with method 1:  grant.2691735
Found a match with method 1:  grant.2689988
Found a match with method 1:  grant.2538393
Found a match with method 1:  grant.2603357
Found a match with method 1:  grant.2435070
Found a match with method 1:  grant.2684418
Found a match with method 1:  grant.2694218
Found a match with method 1:  grant.2694221
Found a match with method 1:  grant.2694217
Found a match with method 1:  grant.2694225
Found a match with method 1:  grant.2475224
Found a match with method 1:  grant.2475203
Found a match with method 1:  grant.2687680
Found a match with method 1:  grant.2435058
Found a match with method 1:  grant.2447007
Found a match with method 1:  grant.2454586
Found a match with method 1:  grant.2687451
Found a match with method 1:  grant.2475134
Found a match with method 1:  grant.2446737
Found a match with method 1:  grant.2454889
Found a match with method 1:  grant.2440150
Found a match with method 1:  grant.2693681
Found a match with method 1:  grant.2602921
Found a match with method 1:  grant.2474417
Found a match with method 1:  grant.2438870
Found a match with method 1:  grant.2435718
Found a match with method 1:  grant.2435034
Found a match with method 1:  grant.2454445
Found a match with method 1:  grant.2435022
Found a match with method 1:  grant.2424955
Found a match with method 1:  grant.2691028
Found a match with method 1:  grant.2688806
Found a match with method 1:  grant.2473626
Found a match with method 1:  grant.2438867
Found a match with method 1:  grant.2435679
Found a match with method 1:  grant.2416431
Found a match with method 1:  grant.2453708
Found a match with method 1:  grant.2687417
Found a match with method 1:  grant.2441127
Found a match with method 1:  grant.2438866
Found a match with method 1:  grant.2440735
Found a match with method 1:  grant.2694198
Found a match with method 1:  grant.2435657
Found a match with method 1:  grant.2688755
Found a match with method 1:  grant.2688759
Found a match with method 1:  grant.2688662
Found a match with method 1:  grant.2688655
Found a match with method 1:  grant.2688664
Found a match with method 1:  grant.2534757
Found a match with method 1:  grant.2688632
Found a match with method 1:  grant.2438861
Found a match with method 1:  grant.2440137
Found a match with method 1:  grant.2440139
Found a match with method 1:  grant.2424041
Found a match with method 1:  grant.2688565
Found a match with method 1:  grant.2471259
Found a match with method 1:  grant.2452395
Found a match with method 1:  grant.2438859
Found a match with method 1:  grant.2452138
Found a match with method 1:  grant.2694140
Found a match with method 1:  grant.2694141
Found a match with method 1:  grant.2694169
Found a match with method 1:  grant.2694162
Found a match with method 1:  grant.2438858
Found a match with method 1:  grant.2634352
Found a match with method 1:  grant.2438852
Found a match with method 1:  grant.2438851
Found a match with method 1:  grant.2416545
Found a match with method 1:  grant.2434634
Found a match with method 1:  grant.2438847
Found a match with method 1:  grant.2441054
Found a match with method 1:  grant.2693347
Found a match with method 1:  grant.2693350
Found a match with method 1:  grant.2435461
Found a match with method 1:  grant.2438845
Found a match with method 1:  grant.2693310
Found a match with method 1:  grant.2438805
Found a match with method 1:  grant.2438813
Found a match with method 1:  grant.2438790
Found a match with method 1:  grant.2438835
Found a match with method 1:  grant.2423981
Found a match with method 1:  grant.2423956
Found a match with method 1:  grant.2424011
Found a match with method 1:  grant.2438836
Found a match with method 1:  grant.2435422
Found a match with method 1:  grant.2438826
Found a match with method 1:  grant.2438839
Found a match with method 1:  grant.2438818
Found a match with method 1:  grant.2693275
Found a match with method 1:  grant.2438791
Found a match with method 1:  grant.2423963
Found a match with method 1:  grant.2438789
Found a match with method 1:  grant.2438817
Found a match with method 1:  grant.2438833
Found a match with method 1:  grant.2438819
Found a match with method 1:  grant.2438800
Found a match with method 1:  grant.2438810
Found a match with method 1:  grant.2438793
Found a match with method 1:  grant.2438816
Found a match with method 1:  grant.2435375
Found a match with method 1:  grant.2438807
Found a match with method 1:  grant.2438796
Found a match with method 1:  grant.2436693
Found a match with method 1:  grant.2438809
Found a match with method 1:  grant.2423955
Found a match with method 1:  grant.2423961
Found a match with method 1:  grant.2423965
Returned Grants: 1 (total = 1)
Time: 0.60s
=== Found a match with method 2:  grant.7664870
Returned Grants: 1 (total = 1)
Time: 0.56s
=== Found a match with method 2:  grant.7628231
Returned Grants: 2 (total = 2)
Time: 0.51s
=== Found a match with method 2:  grant.7623304
Found a match with method 1:  grant.7575791
Found a match with method 1:  grant.7568437
Found a match with method 1:  grant.7567590
Returned Grants: 0
Time: 0.66s
Failed - skipping
Found a match with method 1:  grant.7437133
Found a match with method 1:  grant.7167590
Returned Grants: 2 (total = 2)
Time: 0.61s
=== Found a match with method 2:  grant.7148384
Returned Grants: 2 (total = 2)
Time: 0.52s
=== Found a match with method 2:  grant.7148384
Found a match with method 1:  grant.7043734
Found a match with method 1:  grant.7042974
Found a match with method 1:  grant.7042624
Found a match with method 1:  grant.7042622
Found a match with method 1:  grant.6972056
Found a match with method 1:  grant.6968725
Found a match with method 1:  grant.6966722
Found a match with method 1:  grant.6844591
Found a match with method 1:  grant.6735165
Found a match with method 1:  grant.6732885
Found a match with method 1:  grant.6731341
Found a match with method 1:  grant.6730713
Found a match with method 1:  grant.6729465
Found a match with method 1:  grant.6729082
Found a match with method 1:  grant.6726453
Found a match with method 1:  grant.6725165
Found a match with method 1:  grant.6725082
Found a match with method 1:  grant.6725032
Found a match with method 1:  grant.6724834
Found a match with method 1:  grant.6723804
Found a match with method 1:  grant.6723056
Found a match with method 1:  grant.6716599
Found a match with method 1:  grant.6714669
Found a match with method 1:  grant.6714037
Found a match with method 1:  grant.6713255
Found a match with method 1:  grant.6582874
Found a match with method 1:  grant.6370857
Found a match with method 1:  grant.6363940
Found a match with method 1:  grant.6363488
Found a match with method 1:  grant.6343961
Found a match with method 1:  grant.6317005
Found a match with method 1:  grant.6315891
Found a match with method 1:  grant.6233441
Returned Grants: 1 (total = 1)
Time: 0.55s
=== Found a match with method 2:  grant.6193400
Found a match with method 1:  grant.6171313
Found a match with method 1:  grant.6169577
Found a match with method 1:  grant.5896926
Found a match with method 1:  grant.5526642
Found a match with method 1:  grant.5502450
Found a match with method 1:  grant.5246711
Found a match with method 1:  grant.5246674
Found a match with method 1:  grant.5246626
Found a match with method 1:  grant.5070451
Returned Grants: 0
Time: 0.58s
Failed - skipping
Found a match with method 1:  grant.4641309
Found a match with method 1:  grant.4168271
Found a match with method 1:  grant.3739684
Found a match with method 1:  grant.3706272
Found a match with method 1:  grant.3702523
Found a match with method 1:  grant.3652600
Found a match with method 1:  grant.3309929
Found a match with method 1:  grant.2986898
Found a match with method 1:  grant.2985999
Found a match with method 1:  grant.2984549
Found a match with method 1:  grant.2974921
Found a match with method 1:  grant.2971636
Found a match with method 1:  grant.2963297
Found a match with method 1:  grant.2953859
Found a match with method 1:  grant.2951075
Found a match with method 1:  grant.2945193
Found a match with method 1:  grant.2937592
Found a match with method 1:  grant.2937042
Found a match with method 1:  grant.2935778
Found a match with method 1:  grant.2914065
Found a match with method 1:  grant.2910038
Found a match with method 1:  grant.2899455
Found a match with method 1:  grant.2898752
Found a match with method 1:  grant.2896132
Found a match with method 1:  grant.2869083
Found a match with method 1:  grant.2835164
Found a match with method 1:  grant.2824183
Found a match with method 1:  grant.2813726
Found a match with method 1:  grant.2694848
Found a match with method 1:  grant.2692184
Found a match with method 1:  grant.2687621
Found a match with method 1:  grant.2687368
Found a match with method 1:  grant.2687218
Found a match with method 1:  grant.2687093
Found a match with method 1:  grant.2666074
Found a match with method 1:  grant.2665915
Found a match with method 1:  grant.2664798
Found a match with method 1:  grant.2643578
Found a match with method 1:  grant.2643577
Found a match with method 1:  grant.2643549
Found a match with method 1:  grant.2640348
Found a match with method 1:  grant.2640344
Found a match with method 1:  grant.2640324
Found a match with method 1:  grant.2640316
Found a match with method 1:  grant.2640237
Found a match with method 1:  grant.2640236
Found a match with method 1:  grant.2639795
Found a match with method 1:  grant.2636315
Found a match with method 1:  grant.2636304
Found a match with method 1:  grant.2636298
Found a match with method 1:  grant.2625146
Found a match with method 1:  grant.2608574
Found a match with method 1:  grant.2602929
Found a match with method 1:  grant.2597635
Found a match with method 1:  grant.2572211
Found a match with method 1:  grant.2566750
Found a match with method 1:  grant.2566749
Found a match with method 1:  grant.2566740
Found a match with method 1:  grant.2566739
Found a match with method 1:  grant.2566738
Found a match with method 1:  grant.2489689
Found a match with method 1:  grant.2474868
Found a match with method 1:  grant.2471363
Found a match with method 1:  grant.2471277
Found a match with method 1:  grant.2471271
Found a match with method 1:  grant.2454716
Found a match with method 1:  grant.2453176
Found a match with method 1:  grant.2452868
Found a match with method 1:  grant.2452627
Found a match with method 1:  grant.2452157
Found a match with method 1:  grant.2450816
Found a match with method 1:  grant.2433676
Found a match with method 1:  grant.2433640
Found a match with method 1:  grant.2433628
Found a match with method 1:  grant.2428617
Found a match with method 1:  grant.2428003
Found a match with method 1:  grant.2425945
Found a match with method 1:  grant.2425777
Found a match with method 1:  grant.2425765
Found a match with method 1:  grant.2425738
Found a match with method 1:  grant.2424919
Found a match with method 1:  grant.2424708
Found a match with method 1:  grant.2424692
Found a match with method 1:  grant.2424627
Found a match with method 1:  grant.2424600
Found a match with method 1:  grant.2424554
Found a match with method 1:  grant.2424491
Found a match with method 1:  grant.2424469
Found a match with method 1:  grant.2424424
Found a match with method 1:  grant.2424340
Found a match with method 1:  grant.2406847
Found a match with method 1:  grant.2393916
Found a match with method 1:  grant.2393915
Found a match with method 1:  grant.2393914
Found a match with method 1:  grant.2393913
Found a match with method 1:  grant.2393912
Found a match with method 1:  grant.2393911
Found a match with method 1:  grant.2393910
Found a match with method 1:  grant.2393909
Found a match with method 1:  grant.2393908
Found a match with method 1:  grant.2393907
Found a match with method 1:  grant.2393906
Found a match with method 1:  grant.2393905
Found a match with method 1:  grant.2393904
Found a match with method 1:  grant.2393903
Found a match with method 1:  grant.2393902
Found a match with method 1:  grant.2393901
Found a match with method 1:  grant.2393900
Found a match with method 1:  grant.2393899
Found a match with method 1:  grant.2393898
Found a match with method 1:  grant.2393897
Found a match with method 1:  grant.2393896
Found a match with method 1:  grant.2393895
Found a match with method 1:  grant.2393893
Found a match with method 1:  grant.2393892
Found a match with method 1:  grant.2393891
Found a match with method 1:  grant.2393890
Found a match with method 1:  grant.2393889
Found a match with method 1:  grant.2393888
Found a match with method 1:  grant.2393887
Found a match with method 1:  grant.2393886
Found a match with method 1:  grant.2393885
Found a match with method 1:  grant.2393884
Found a match with method 1:  grant.2393883
Found a match with method 1:  grant.2393882
Found a match with method 1:  grant.2393881
Found a match with method 1:  grant.2393880
Found a match with method 1:  grant.2393879
Found a match with method 1:  grant.2393878
Found a match with method 1:  grant.2393877
Found a match with method 1:  grant.2393876
Found a match with method 1:  grant.2393875
Found a match with method 1:  grant.2393874
Found a match with method 1:  grant.2393873
Found a match with method 1:  grant.2393872
Found a match with method 1:  grant.2393871
Found a match with method 1:  grant.2393870
Found a match with method 1:  grant.2393869
Found a match with method 1:  grant.2393868
Found a match with method 1:  grant.2393867
Found a match with method 1:  grant.2393866
Found a match with method 1:  grant.2393865
Found a match with method 1:  grant.2393864
Found a match with method 1:  grant.2393863
Found a match with method 1:  grant.2393862
Found a match with method 1:  grant.2393861
Found a match with method 1:  grant.2393860
Found a match with method 1:  grant.2393859
Found a match with method 1:  grant.2393858
Found a match with method 1:  grant.2393857
Found a match with method 1:  grant.2393856
Found a match with method 1:  grant.2393855
Found a match with method 1:  grant.2393854
Found a match with method 1:  grant.2393853
Found a match with method 1:  grant.2393852
Found a match with method 1:  grant.2393844
Found a match with method 1:  grant.2393841
Found a match with method 1:  grant.2393821
Found a match with method 1:  grant.2393817
Found a match with method 1:  grant.2393814
Found a match with method 1:  grant.2393808
Found a match with method 1:  grant.2393804
Found a match with method 1:  grant.2393800
Found a match with method 1:  grant.2393799
Found a match with method 1:  grant.2393797
Found a match with method 1:  grant.2393795
Found a match with method 1:  grant.2393794
Found a match with method 1:  grant.2393790
Found a match with method 1:  grant.2393786
Found a match with method 1:  grant.2375051
Found a match with method 1:  grant.2369583
Found a match with method 1:  grant.2356619
Returned Grants: 0
Time: 1.09s
Failed - skipping
Found a match with method 1:  grant.8446709
Found a match with method 1:  grant.8033537
Found a match with method 1:  grant.7951286
Found a match with method 1:  grant.7942547
Found a match with method 1:  grant.7608089
Returned Grants: 0
Time: 0.62s
Failed - skipping
Returned Grants: 0
Time: 0.80s
Failed - skipping
Returned Grants: 0
Time: 0.56s
Failed - skipping
Returned Grants: 0
Time: 0.60s
Failed - skipping
Found a match with method 1:  grant.7167585
Found a match with method 1:  grant.7104247
Found a match with method 1:  grant.7062940
Found a match with method 1:  grant.6967906
Found a match with method 1:  grant.6728271
Returned Grants: 1 (total = 1)
Time: 0.58s
=== Found a match with method 2:  grant.6500725
Found a match with method 1:  grant.6259132
Found a match with method 1:  grant.5892064
Found a match with method 1:  grant.5761631
Found a match with method 1:  grant.5551429
Found a match with method 1:  grant.5246672
Found a match with method 1:  grant.5246671
Found a match with method 1:  grant.5246586
Found a match with method 1:  grant.5246584
Found a match with method 1:  grant.5246583
Found a match with method 1:  grant.5246582
Found a match with method 1:  grant.5246581
Found a match with method 1:  grant.4632144
Found a match with method 1:  grant.3802932
Found a match with method 1:  grant.2936797
Found a match with method 1:  grant.2424522
Found a match with method 1:  grant.6315092
Found a match with method 1:  grant.8505364
Found a match with method 1:  grant.8495954
Found a match with method 1:  grant.8489605
Found a match with method 1:  grant.8487606
Found a match with method 1:  grant.8352947
Found a match with method 1:  grant.8328815
Found a match with method 1:  grant.8290380
Found a match with method 1:  grant.8219416
Found a match with method 1:  grant.8219108
Found a match with method 1:  grant.8217961
Found a match with method 1:  grant.8216804
Found a match with method 1:  grant.8214678
Found a match with method 1:  grant.8209272
Found a match with method 1:  grant.8209093
Found a match with method 1:  grant.8205967
Found a match with method 1:  grant.8173982
Found a match with method 1:  grant.8173409
Found a match with method 1:  grant.8172930
Found a match with method 1:  grant.8169476
Found a match with method 1:  grant.8167666
Found a match with method 1:  grant.8034776
Found a match with method 1:  grant.8033536
Found a match with method 1:  grant.8019012
Found a match with method 1:  grant.8018668
Found a match with method 1:  grant.8005184
Found a match with method 1:  grant.8000977
Found a match with method 1:  grant.7993576
Found a match with method 1:  grant.7992850
Found a match with method 1:  grant.7989648
Found a match with method 1:  grant.7951296
Found a match with method 1:  grant.7851731
Found a match with method 1:  grant.7821052
Returned Errors: 1
Time: 0.51s
1 QuerySyntaxError found
1 ParserError found
  * [Line 1:31] ('09067052') no viable alternative at input 'CentreforNanovaccinessagsnr09067052'
Failed - skipping
Found a match with method 1:  grant.7721825
Found a match with method 1:  grant.7721778
Found a match with method 1:  grant.7721598
Found a match with method 1:  grant.7721597
Found a match with method 1:  grant.7715670
Found a match with method 1:  grant.7709652
Returned Grants: 1 (total = 1)
Time: 0.90s
=== Found a match with method 2:  grant.7695510
Returned Grants: 1 (total = 1)
Time: 0.81s
=== Found a match with method 2:  grant.7693092
Returned Grants: 2 (total = 2)
Time: 1.01s
=== Found a match with method 2:  grant.7685141
Returned Grants: 0
Time: 0.54s
Failed - skipping
Returned Grants: 2 (total = 2)
Time: 0.57s
=== Found a match with method 2:  grant.7685141
Returned Grants: 1 (total = 1)
Time: 0.91s
=== Found a match with method 2:  grant.7684827
Returned Grants: 1 (total = 1)
Time: 0.53s
=== Found a match with method 2:  grant.7683420
Found a match with method 1:  grant.7668688
Returned Grants: 1 (total = 1)
Time: 0.54s
=== Found a match with method 2:  grant.7666767
Returned Grants: 1 (total = 1)
Time: 0.54s
=== Found a match with method 2:  grant.7665207
Returned Grants: 0
Time: 0.52s
Failed - skipping
Returned Grants: 0
Time: 0.53s
Failed - skipping
Returned Grants: 0
Time: 0.53s
Failed - skipping
Returned Grants: 0
Time: 0.53s
Failed - skipping
Returned Grants: 1 (total = 1)
Time: 0.52s
=== Found a match with method 2:  grant.7658269
Returned Grants: 1 (total = 1)
Time: 0.53s
=== Found a match with method 2:  grant.7653038
Returned Grants: 1 (total = 1)
Time: 0.99s
=== Found a match with method 2:  grant.7648001
Returned Grants: 1 (total = 1)
Time: 0.63s
=== Found a match with method 2:  grant.7647714
Returned Grants: 0
Time: 0.55s
Failed - skipping
Returned Grants: 0
Time: 1.02s
Failed - skipping
Returned Grants: 3 (total = 3)
Time: 0.55s
=== Found a match with method 2:  grant.4035377
Returned Errors: 1
Time: 0.97s
1 QuerySyntaxError found
1 ParserError found
  * [Line 1:15] ('1') no viable alternative at input 'TowardsaType1'
Failed - skipping
Returned Grants: 1 (total = 1)
Time: 0.53s
=== Found a match with method 2:  grant.7628997
Returned Grants: 1 (total = 1)
Time: 0.58s
=== Found a match with method 2:  grant.7628517
Returned Grants: 1 (total = 1)
Time: 0.53s
=== Found a match with method 2:  grant.7624786
Returned Grants: 1 (total = 1)
Time: 0.53s
=== Found a match with method 2:  grant.7623304
Returned Grants: 1 (total = 1)
Time: 0.53s
=== Found a match with method 2:  grant.7622447
Returned Grants: 0
Time: 0.54s
Failed - skipping
Returned Grants: 1 (total = 1)
Time: 0.60s
=== Found a match with method 2:  grant.7618695
Found a match with method 1:  grant.7608908
Found a match with method 1:  grant.7576541
Found a match with method 1:  grant.7575474
Returned Grants: 1 (total = 1)
Time: 0.66s
=== Found a match with method 2:  grant.7550264
Returned Grants: 1 (total = 1)
Time: 0.95s
=== Found a match with method 2:  grant.7550133
Returned Grants: 0
Time: 0.56s
Failed - skipping
Returned Grants: 0
Time: 0.57s
Failed - skipping
Returned Grants: 0
Time: 1.18s
Failed - skipping
Returned Grants: 0
Time: 0.57s
Failed - skipping
Returned Grants: 0
Time: 0.68s
Failed - skipping
Returned Grants: 0
Time: 0.56s
Failed - skipping
Returned Grants: 0
Time: 0.60s
Failed - skipping
Returned Grants: 0
Time: 0.58s
Failed - skipping
Returned Grants: 0
Time: 0.56s
Failed - skipping
Returned Grants: 0
Time: 0.59s
Failed - skipping
Returned Grants: 0
Time: 0.54s
Failed - skipping
Returned Grants: 0
Time: 1.09s
Failed - skipping
Found a match with method 1:  grant.7172800
Found a match with method 1:  grant.7164693
Found a match with method 1:  grant.7162576
Returned Grants: 1 (total = 1)
Time: 0.55s
=== Found a match with method 2:  grant.7150415
Returned Grants: 1 (total = 1)
Time: 0.62s
=== Found a match with method 2:  grant.7148703
Returned Grants: 1 (total = 1)
Time: 1.00s
=== Found a match with method 2:  grant.7148315
Found a match with method 1:  grant.7043730
Found a match with method 1:  grant.7043113
Found a match with method 1:  grant.7042995
Found a match with method 1:  grant.7042984
Found a match with method 1:  grant.7042973
Found a match with method 1:  grant.7042972
Found a match with method 1:  grant.7040781
Found a match with method 1:  grant.7040770
Found a match with method 1:  grant.6973472
Found a match with method 1:  grant.6968429
Found a match with method 1:  grant.6964936
Found a match with method 1:  grant.6964935
Found a match with method 1:  grant.6964934
Found a match with method 1:  grant.6962076
Found a match with method 1:  grant.6860200
Found a match with method 1:  grant.6841646
Found a match with method 1:  grant.6733351
Found a match with method 1:  grant.6733063
Found a match with method 1:  grant.6732161
Found a match with method 1:  grant.6731087
Found a match with method 1:  grant.6730637
Found a match with method 1:  grant.6729362
Found a match with method 1:  grant.6728479
Returned Grants: 1 (total = 1)
Time: 0.55s
=== Found a match with method 2:  grant.6727741
Found a match with method 1:  grant.6727472
Found a match with method 1:  grant.6727351
Found a match with method 1:  grant.6727129
Found a match with method 1:  grant.6726943
Found a match with method 1:  grant.6726066
Found a match with method 1:  grant.6724082
Found a match with method 1:  grant.6724070
Found a match with method 1:  grant.6722617
Found a match with method 1:  grant.6722495
Found a match with method 1:  grant.6719794
Found a match with method 1:  grant.6717775
Found a match with method 1:  grant.6716449
Found a match with method 1:  grant.6715829
Found a match with method 1:  grant.6715708
Found a match with method 1:  grant.6584428
Found a match with method 1:  grant.6584014
Found a match with method 1:  grant.6583657
Found a match with method 1:  grant.6582621
Found a match with method 1:  grant.6582605
Found a match with method 1:  grant.6582373
Found a match with method 1:  grant.6581732
Found a match with method 1:  grant.6581497
Found a match with method 1:  grant.6581487
Found a match with method 1:  grant.6581045
Found a match with method 1:  grant.6580935
Found a match with method 1:  grant.6580931
Found a match with method 1:  grant.6580858
Found a match with method 1:  grant.6373203
Found a match with method 1:  grant.6371736
Found a match with method 1:  grant.6371621
Found a match with method 1:  grant.6354558
Found a match with method 1:  grant.6352300
Found a match with method 1:  grant.6326766
Found a match with method 1:  grant.6322556
Found a match with method 1:  grant.6320876
Found a match with method 1:  grant.6315181
Found a match with method 1:  grant.6312481
Found a match with method 1:  grant.6312424
Found a match with method 1:  grant.6309272
Found a match with method 1:  grant.6300254
Found a match with method 1:  grant.6269166
Found a match with method 1:  grant.6265050
Found a match with method 1:  grant.6199903
Found a match with method 1:  grant.6184528
Found a match with method 1:  grant.6172495
Found a match with method 1:  grant.6168194
Found a match with method 1:  grant.6053442
Found a match with method 1:  grant.6035398
Found a match with method 1:  grant.5988918
Returned Grants: 0
Time: 0.58s
Failed - skipping
Returned Grants: 0
Time: 0.90s
Failed - skipping
Returned Grants: 0
Time: 0.57s
Failed - skipping
Returned Errors: 1
Time: 0.52s
16 QuerySyntaxErrors found
15 LexerErrors found
  * [Line 1:32] ('"鶏コクシジウムのコンポーネント・ワクチンに関する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: '"鶏コクシジウムのコンポーネント・'
  * [Line 1:49] ('ワクチンに関する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: 'ワ'
  * [Line 1:50] ('クチンに関する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: 'ク'
  * [Line 1:51] ('チンに関する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: 'チ'
  * [Line 1:52] ('ンに関する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: 'ン'
  * [Line 1:53] ('に関する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: 'に'
  * [Line 1:54] ('関する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: '関'
  * [Line 1:55] ('する基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: 'す'
  * [Line 1:56] ('る基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: 'る'
  * [Line 1:57] ('基礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: '基'
  * [Line 1:58] ('礎的研究" where funder_countries.name="Japan" return grants') token recognition error at: '礎'
  * [Line 1:59] ('的研究" where funder_countries.name="Japan" return grants') token recognition error at: '的'
  * [Line 1:60] ('研究" where funder_countries.name="Japan" return grants') token recognition error at: '研'
  * [Line 1:61] ('究" where funder_countries.name="Japan" return grants') token recognition error at: '究'
  * [Line 1:98] ('" return grants') token recognition error at: '" return grants'
1 ParserError found
  * [Line 1:93] ('Japan') mismatched input 'Japan' expecting 'return'
Failed - skipping
Returned Grants: 0
Time: 0.56s
Failed - skipping
Found a match with method 1:  grant.5533552
Found a match with method 1:  grant.5531348
Found a match with method 1:  grant.5528462
Found a match with method 1:  grant.5527258
Found a match with method 1:  grant.5502385
Found a match with method 1:  grant.5502275
Found a match with method 1:  grant.5325527
Found a match with method 1:  grant.5246712
Found a match with method 1:  grant.5246675
Found a match with method 1:  grant.5246655
Found a match with method 1:  grant.5246654
Found a match with method 1:  grant.5246653
Found a match with method 1:  grant.5246652
Found a match with method 1:  grant.5246651
Found a match with method 1:  grant.5246650
Found a match with method 1:  grant.5246628
Found a match with method 1:  grant.5246627
Found a match with method 1:  grant.5246625
Found a match with method 1:  grant.5246587
Found a match with method 1:  grant.5246557
Found a match with method 1:  grant.5246556
Found a match with method 1:  grant.5246416
Found a match with method 1:  grant.5246378
Found a match with method 1:  grant.5246376
Found a match with method 1:  grant.5246333
Found a match with method 1:  grant.5246326
Found a match with method 1:  grant.5246292
Found a match with method 1:  grant.5246291
Found a match with method 1:  grant.5206028
Found a match with method 1:  grant.5202152
Found a match with method 1:  grant.5196804
Found a match with method 1:  grant.5195740
Found a match with method 1:  grant.5195025
Found a match with method 1:  grant.5138636
Found a match with method 1:  grant.5069446
Found a match with method 1:  grant.5068098
Found a match with method 1:  grant.5066344
Found a match with method 1:  grant.5064871
Returned Grants: 1 (total = 1)
Time: 0.55s
=== Found a match with method 2:  grant.5061881
Returned Grants: 1 (total = 1)
Time: 0.63s
=== Found a match with method 2:  grant.5061466
Returned Grants: 1 (total = 1)
Time: 0.55s
=== Found a match with method 2:  grant.5061185
Returned Grants: 1 (total = 1)
Time: 0.53s
=== Found a match with method 2:  grant.5060853
Returned Grants: 0
Time: 0.57s
Failed - skipping
Found a match with method 1:  grant.4695298
Found a match with method 1:  grant.4682414
Found a match with method 1:  grant.4661480
Found a match with method 1:  grant.4644142
Found a match with method 1:  grant.4641075
Found a match with method 1:  grant.4636462
Found a match with method 1:  grant.4562339
Found a match with method 1:  grant.4510775
Found a match with method 1:  grant.4453044
Returned Grants: 1 (total = 1)
Time: 0.54s
=== Found a match with method 2:  grant.4362089
Found a match with method 1:  grant.4192377
Found a match with method 1:  grant.4171416
Found a match with method 1:  grant.4167878
Found a match with method 1:  grant.4167438
Found a match with method 1:  grant.4106519
Returned Grants: 0
Time: 0.53s
Failed - skipping
Returned Grants: 3 (total = 3)
Time: 0.54s
=== Found a match with method 2:  grant.4035377
Returned Grants: 3 (total = 3)
Time: 0.56s
=== Found a match with method 2:  grant.4035377
Found a match with method 1:  grant.3749684
Found a match with method 1:  grant.3733024
Found a match with method 1:  grant.3731136
Found a match with method 1:  grant.3729873
Found a match with method 1:  grant.3728490
Found a match with method 1:  grant.3726127
Found a match with method 1:  grant.3708086
Found a match with method 1:  grant.3706490
Found a match with method 1:  grant.3702872
Found a match with method 1:  grant.3700936
Found a match with method 1:  grant.3535230
Found a match with method 1:  grant.3532347
Found a match with method 1:  grant.3529500
Found a match with method 1:  grant.3528280
Found a match with method 1:  grant.3528140
Found a match with method 1:  grant.3527854
Found a match with method 1:  grant.3527599
Found a match with method 1:  grant.3526938
Found a match with method 1:  grant.3526242
Found a match with method 1:  grant.3524632
Found a match with method 1:  grant.2987656
Found a match with method 1:  grant.2985050
Found a match with method 1:  grant.2984254
Found a match with method 1:  grant.2982723
Found a match with method 1:  grant.2978220
Found a match with method 1:  grant.2971136
Found a match with method 1:  grant.2968761
Found a match with method 1:  grant.2968075
Found a match with method 1:  grant.2967309
Found a match with method 1:  grant.2960882
Found a match with method 1:  grant.2958728
Found a match with method 1:  grant.2957327
Returned Grants: 1 (total = 1)
Time: 1.04s
=== Found a match with method 2:  grant.2942407
Found a match with method 1:  grant.2939650
Found a match with method 1:  grant.2937046
Found a match with method 1:  grant.2936941
Found a match with method 1:  grant.2932210
Found a match with method 1:  grant.2928975
Found a match with method 1:  grant.2923314
Found a match with method 1:  grant.2921906
Found a match with method 1:  grant.2912514
Found a match with method 1:  grant.2911669
Found a match with method 1:  grant.2901085
Found a match with method 1:  grant.2899804
Found a match with method 1:  grant.2892553
Found a match with method 1:  grant.2875627
Found a match with method 1:  grant.2874597
Found a match with method 1:  grant.2874082
Found a match with method 1:  grant.2857726
Found a match with method 1:  grant.2853909
Returned Grants: 1 (total = 1)
Time: 0.55s
=== Found a match with method 2:  grant.2846899
Found a match with method 1:  grant.2845378
Found a match with method 1:  grant.2835397
Found a match with method 1:  grant.2834880
Found a match with method 1:  grant.2821820
Found a match with method 1:  grant.2817654
Found a match with method 1:  grant.2807465
Found a match with method 1:  grant.2798941
Found a match with method 1:  grant.2795749
Found a match with method 1:  grant.2791038
Found a match with method 1:  grant.2789593
Found a match with method 1:  grant.2722085
Found a match with method 1:  grant.2706159
Found a match with method 1:  grant.2698714
Found a match with method 1:  grant.2697537
Found a match with method 1:  grant.2695257
Found a match with method 1:  grant.2693731
Found a match with method 1:  grant.2690783
Found a match with method 1:  grant.2690760
Found a match with method 1:  grant.2687365
Found a match with method 1:  grant.2687364
Found a match with method 1:  grant.2687357
Found a match with method 1:  grant.2687347
Found a match with method 1:  grant.2687156
Found a match with method 1:  grant.2687154
Found a match with method 1:  grant.2666046
Found a match with method 1:  grant.2664366
Found a match with method 1:  grant.2664365
Found a match with method 1:  grant.2657660
Found a match with method 1:  grant.2657656
Found a match with method 1:  grant.2657579
Found a match with method 1:  grant.2647175
Found a match with method 1:  grant.2643697
Found a match with method 1:  grant.2643565
Found a match with method 1:  grant.2641009
Found a match with method 1:  grant.2640640
Found a match with method 1:  grant.2640550
Found a match with method 1:  grant.2640356
Found a match with method 1:  grant.2640346
Found a match with method 1:  grant.2640336
Found a match with method 1:  grant.2640319
Found a match with method 1:  grant.2640315
Found a match with method 1:  grant.2640305
Found a match with method 1:  grant.2640255
Found a match with method 1:  grant.2640187
Found a match with method 1:  grant.2639832
Found a match with method 1:  grant.2624939
Found a match with method 1:  grant.2608583
Found a match with method 1:  grant.2608571
Found a match with method 1:  grant.2597656
Found a match with method 1:  grant.2597626
Found a match with method 1:  grant.2597599
Found a match with method 1:  grant.2597536
Found a match with method 1:  grant.2597279
Found a match with method 1:  grant.2597266
Found a match with method 1:  grant.2597222
Found a match with method 1:  grant.2590181
Found a match with method 1:  grant.2583049
Found a match with method 1:  grant.2579292
Found a match with method 1:  grant.2567035
Found a match with method 1:  grant.2566836
Found a match with method 1:  grant.2566752
Found a match with method 1:  grant.2564456
Found a match with method 1:  grant.2508306
Found a match with method 1:  grant.2454434
Found a match with method 1:  grant.2453161
Found a match with method 1:  grant.2452894
Found a match with method 1:  grant.2452879
Found a match with method 1:  grant.2452193
Found a match with method 1:  grant.2450320
Found a match with method 1:  grant.2435123
Found a match with method 1:  grant.2435096
Found a match with method 1:  grant.2434876
Found a match with method 1:  grant.2433623
Found a match with method 1:  grant.2430978
Found a match with method 1:  grant.2430831
Found a match with method 1:  grant.2430826
Found a match with method 1:  grant.2430821
Found a match with method 1:  grant.2430718
Found a match with method 1:  grant.2430614
Found a match with method 1:  grant.2430613
Found a match with method 1:  grant.2430542
Found a match with method 1:  grant.2425744
Found a match with method 1:  grant.2424990
Found a match with method 1:  grant.2424954
Found a match with method 1:  grant.2424953
Found a match with method 1:  grant.2424952
Found a match with method 1:  grant.2424951
Found a match with method 1:  grant.2424889
Found a match with method 1:  grant.2424801
Found a match with method 1:  grant.2424782
Found a match with method 1:  grant.2424743
Found a match with method 1:  grant.2424740
Found a match with method 1:  grant.2424712
Found a match with method 1:  grant.2424651
Found a match with method 1:  grant.2424636
Found a match with method 1:  grant.2424626
Found a match with method 1:  grant.2424597
Found a match with method 1:  grant.2424596
Found a match with method 1:  grant.2424595
Found a match with method 1:  grant.2424594
Found a match with method 1:  grant.2424592
Found a match with method 1:  grant.2424552
Found a match with method 1:  grant.2424540
Found a match with method 1:  grant.2424537
Found a match with method 1:  grant.2424536
Found a match with method 1:  grant.2424527
Found a match with method 1:  grant.2424526
Found a match with method 1:  grant.2424512
Found a match with method 1:  grant.2424487
Found a match with method 1:  grant.2424463
Found a match with method 1:  grant.2424448
Found a match with method 1:  grant.2424437
Found a match with method 1:  grant.2424431
Found a match with method 1:  grant.2424428
Found a match with method 1:  grant.2424403
Found a match with method 1:  grant.2424402
Found a match with method 1:  grant.2424401
Found a match with method 1:  grant.2424400
Found a match with method 1:  grant.2424360
Found a match with method 1:  grant.2424343
Found a match with method 1:  grant.2424333
Found a match with method 1:  grant.2424332
Found a match with method 1:  grant.2424330
Found a match with method 1:  grant.2424329
Found a match with method 1:  grant.2415704
Found a match with method 1:  grant.2409426
Found a match with method 1:  grant.2405500
Found a match with method 1:  grant.2393833
Found a match with method 1:  grant.2393831
Found a match with method 1:  grant.2393828
Found a match with method 1:  grant.2393822
Found a match with method 1:  grant.2393812
Found a match with method 1:  grant.2393810
Found a match with method 1:  grant.2393809
Found a match with method 1:  grant.2393798
Found a match with method 1:  grant.2393792
Found a match with method 1:  grant.2393788
Found a match with method 1:  grant.2393775
Found a match with method 1:  grant.2390878
Found a match with method 1:  grant.2375603
Found a match with method 1:  grant.2369988
Found a match with method 1:  grant.2369821
Found a match with method 1:  grant.2369813
Found a match with method 1:  grant.2359845
Found a match with method 1:  grant.2356296
Found a match with method 1:  grant.2355713
Found a match with method 1:  grant.2346752
Found a match with method 1:  grant.2346751
Found a match with method 1:  grant.2346748
Found a match with method 1:  grant.2346743
Found a match with method 1:  grant.2346629
Found a match with method 1:  grant.2346628
Found a match with method 1:  grant.2346595
Found a match with method 1:  grant.2346594
Found a match with method 1:  grant.2346582
Found a match with method 1:  grant.2346581
Found a match with method 1:  grant.2346548
Found a match with method 1:  grant.2346547
Found a match with method 1:  grant.2346527
Found a match with method 1:  grant.2346526
Found a match with method 1:  grant.2346510
Found a match with method 1:  grant.2346485
Found a match with method 1:  grant.2346484
Found a match with method 1:  grant.2346449
Found a match with method 1:  grant.2346448
Found a match with method 1:  grant.100070653
Found a match with method 1:  grant.100069317
Found a match with method 1:  grant.7992220
Found a match with method 1:  grant.7951289
Found a match with method 1:  grant.7951265
Returned Grants: 0
Time: 0.58s
Failed - skipping
Returned Grants: 0
Time: 1.07s
Failed - skipping
Returned Grants: 0
Time: 1.00s
Failed - skipping
Returned Grants: 0
Time: 0.98s
Failed - skipping
Found a match with method 1:  grant.6723340
Found a match with method 1:  grant.6584684
Found a match with method 1:  grant.6584355
Found a match with method 1:  grant.6582323
Found a match with method 1:  grant.6581899
Found a match with method 1:  grant.6580202
Returned Grants: 1 (total = 1)
Time: 0.58s
=== Found a match with method 2:  grant.6499488
Returned Grants: 0
Time: 0.58s
Failed - skipping
Found a match with method 1:  grant.5502095
Found a match with method 1:  grant.5246360
Found a match with method 1:  grant.5141545
Found a match with method 1:  grant.4486180
Found a match with method 1:  grant.3984586
Found a match with method 1:  grant.3983756
Found a match with method 1:  grant.3899759
Found a match with method 1:  grant.3858644
Found a match with method 1:  grant.3856963
Found a match with method 1:  grant.3529314
Found a match with method 1:  grant.2972456
Found a match with method 1:  grant.2424690
Found a match with method 1:  grant.100069716
Found a match with method 1:  grant.2424837
Found a match with method 1:  grant.8169343
Found a match with method 1:  grant.6783638
Found a match with method 1:  grant.6127074
Found a match with method 1:  grant.2708529
Found a match with method 1:  grant.8248988
Found a match with method 1:  grant.6734414
Found a match with method 1:  grant.4640689
Found a match with method 1:  grant.5356862
Found a match with method 1:  grant.6586399
Found a match with method 1:  grant.6585096
Found a match with method 1:  grant.6583693
Found a match with method 1:  grant.6582991
Found a match with method 1:  grant.6582151
Found a match with method 1:  grant.6581800
Found a match with method 1:  grant.3869376
Found a match with method 1:  grant.3765762
Found a match with method 1:  grant.2425528
Found a match with method 1:  grant.6784476

Enriching the original list

Finally, we can take the Dimensions ID data we extracted and add it to the original grants table as an extra column.

[19]:
grants["Dimensions ID"] = output
[20]:
grants.head(10)
[20]:
Grant Number Title Funding Amount in USD Start Year End Year Funder Funder Country Dimensions ID
0 30410203277 疫苗-整体方案 1208.0 2004 2004 National Natural Science Foundation of China China grant.8172033
1 620792 Engineering Inhalable Vaccines 26956.0 2017 2018 Natural Sciences and Engineering Research Council Canada grant.7715379
2 599115 Engineering Inhalable Vaccines 26403.0 2016 2017 Natural Sciences and Engineering Research Council Canada grant.6962629
3 251564 HIV Vaccine research 442366.0 2003 2007 National Health and Medical Research Council Australia grant.6723913
4 334174 HIV Vaccine Development 236067.0 2005 2009 National Health and Medical Research Council Australia grant.6722306
5 910292 Dengue virus vaccine. 130890.0 1991 1993 National Health and Medical Research Council Australia grant.6716312
6 578221 Engineering Inhalable Vaccines 27386.0 2015 2016 Natural Sciences and Engineering Research Council Canada grant.5526688
7 IC18980360 Schistosomiasis Vaccine Network. 0.0 1998 2000 European Commission Belgium grant.3733803
8 7621798 Pneumococcal Ribosomal Vaccines 46000.0 1977 1980 Directorate for Biological Sciences United States grant.3274273
9 255890 Rational vaccine design 7138.0 2003 2004 Natural Sciences and Engineering Research Council Canada grant.2936015

Save the data

[21]:
grants.to_csv("vaccines-grants-sample-part-1.csv", index=False)


Note

The Dimensions Analytics API allows to carry out sophisticated research data analytics tasks like the ones described on this website. Check out also the associated Github repository for examples, the source code of these tutorials and much more.

../../_images/badge-dimensions-api.svg