names

207 rows where place_id = 586314

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588414 1864025 1864025 defendant Wykker Robert husbandman 586314 586314 Wykker, Robert, of Bromley, husbandman 0
3588462 1864038 1864038 defendant Symson William husbandman 586314 586314 Symson, William, of Bromley, husbandman 1
3588463 1864038 1864038 defendant Elys William yeoman 586314 586314 Elys, William, of Bromley, yeoman 2
3588464 1864038 1864038 defendant Lotelwerk Ingelram yeoman 586314 586314 Lotelwerk, Ingelram, of Bromley, yeoman 3
3592837 1865375 1865375 defendant Baker Richard yeoman 586314 586314 Baker, Richard, of Bromley, yeoman 0
3597782 1866923 1866923 defendant Rodley William yeoman 586314 586314 Rodley, William, of Bromley, yeoman 3
3603309 1868708 1868708 defendant Rotheley William yeoman 586314 586314 Rotheley, William, of Bromley, yeoman 0
3621044 1874138 1874138 defendant Budde Thomas butcher 586314 586314 Budde, Thomas, of Bromley, butcher 5
3627442 1903438 1903438 defendant Wyndore Thomas tailor 586314 586314 Wyndore, Thomas, of Bromley, tailor 3
3657032 1912461 1912461 defendant Bedell Thomas yoeman 586314 586314 Bedell, Thomas, of Bromley, yoeman 0
3662492 1914183 1914183 defendant Crocher Henry husbandman 586314 586314 Crocher, Henry, of Bromley, husbandman 0
3664719 1914917 1914917 defendant Bedyll John yeoman 586314 586314 Bedyll, John, of Bromley, yeoman 2
3666199 1915376 1915376 defendant Brisley John rypyer 586314 586314 Brisley, John, of Bromley, rypyer 0
3672995 1917562 1917562 defendant Stanlowe Richard yeoman 586314 586314 Stanlowe, Richard, of Bromley Abbot, yeoman 1
3674864 1918166 1918166 defendant Bresley Thomas   586314 586314 Bresley, Thomas, of Bromley, "rypyer" 1
3681000 1920135 1920135 defendant Bedyll John yeoman 586314 586314 Bedyll, John, of Bromley, yeoman 3
3681980 1920470 1920470 defendant Dune John cooper 586314 586314 Dune, John, of Bromley Abbot, cooper 0
3684530 1921295 1921295 defendant Baron John weaver 586314 586314 Baron, John, of Bromley, weaver 0
3684531 1921295 1921295 defendant Seneyours Anthony barber 586314 586314 Seneyours, Anthony, of Bromley, barber 1
3696340 1925076 1925076 defendant Bedyll John yeoman 586314 586314 Bedyll, John, of Bromley, yeoman 2
3699662 1926121 1926121 defendant Taylour Thomas yeoman 586314 586314 Taylour, Thomas, of Bromley, yeoman 0
3739682 1938624 1938624 defendant Thorpe James yeoman 586314 586314 Thorpe, James, of Bromley, yeoman 0
3739683 1938624 1938624 defendant Vyolet William yeoman 586314 586314 Vyolet, William, of Bromley, yeoman 1
3744404 1940151 1940151 defendant Alsopp Thomas husbandman 586314 586314 Alsopp, Thomas, of Bromley Abbot, husbandman 0
3744406 1940152 1940152 defendant Kent John laborer 586314 586314 Kent, John, of Bromley, laborer 0
3751272 1942322 1942322 plaintiff Myller William (legal representative) 586314 586314 Myller, William, of Bromley, executors of 0
3753755 1943116 1943116 defendant Bowde John glazier 586314 586314 Bowde, John, of Bromley Abbot, glazier 1
3763284 1946149 1946149 defendant Rugge John shoemaker 586314 586314 Rugge, John, of Bromley, shoemaker 1
3767420 1947455 1947455 plaintiff Myller William (legal representative) 586314 586314 Myller, William, of Bromley, executors of 0
3789095 1954399 1954399 plaintiff Dreycot Philip esq 586314 586314 (Dreycot, Philip, of Bromley, esq 1
3789104 1954401 1954401 plaintiff Dreycot Philip   586314 586314 (Dreycot, Philip, of Bromley 1
3798561 1957454 1957454 defendant Corbett Thomas gent 586314 586314 Corbett, Thomas, of Bromley, gent 1
3805297 1959602 1959602 plaintiff Draycote John esq 586314 586314 (Draycote, John, of Bromley, esq 1
3820723 1964371 1964371 defendant Batys Thomas yeoman 586314 586314 Batys, Thomas, of Bromley, yeoman 1
3822801 1965037 1965037 plaintiff Draycote Philip   586314 586314 (Draycote, Philip, of Bromley 1
3867508 1979368 1979368 defendant Obbard Thomas butcher 586314 586314 Obbard, Thomas, of Bromley, butcher 0
3868463 1979689 1979689 plaintiff Draycoyte Philip   586314 586314 (Draycoyte, Philip, of Bromley, knight 1
3869434 1980018 1980018 defendant See William gent 586314 586314 See, William, of Bromley, gent 0
3882336 1984350 1984350 defendant Bresle Thomas collier 586314 586314 Bresle, Thomas, of Bromley, collier 0
3983087 2018725 2018725 defendant Wall John butcher 586314 586314 Wall, John, of Bromley, butcher 0
3983092 2018725 2018725 defendant Crosse Thomas yeoman 586314 586314 Crosse, Thomas, of Bromley, yeoman 5
4099936 2060303 2060303 defendant Tatton William clerk 586314 586314 Tatton, William, of Bromley, clerk 3
4125460 2069387 2069387 defendant Mathew Thomas collier 586314 586314 Mathew, Thomas, of Bromley, collier 1
4162355 2082390 2082390 defendant Gybson William miller 586314 586314 Gybson, William, of Bromley, miller 2
4164191 2083004 2083004 defendant Rogers Robert carpenter 586314 586314 Rogers, Robert, of Bromley, carpenter 0
4172609 2085877 2085877 defendant Barbour John yeoman 586314 586314 Barbour, John, of Bromley, yeoman 3
4218521 2101976 2101976 defendant Smythe Robert gent 586314 586314 Smythe, Robert, of Bromley, gent 0
4218854 2102089 2102089 defendant Hearon Francis gent 586314 586314 Hearon, Francis, of Bromley, gent 1
4250210 2113051 2113051 defendant Samme Joan miller 586314 586314 Joan his wife, formerly Joan Jackson, of Bromley, widow of Roger Jackson, miller 1
4320016 2137106 2137106 defendant Crofte Christopher gent 586314 586314 Crofte, Christopher, of Bromley, gent 0
4338730 2143298 2143298 defendant Goslyn William gent 586314 586314 Goslyn, William, of Bromley, gent 0
4343947 2145160 2145160 defendant Litton John laborer 586314 586314 Litton, John, of Bromley, laborer 2
4496003 2199426 2199426 defendant Walker John   586314 586314 Walker, John, of Bromley 4
4513354 2204591 2204591 plaintiff Broke Robert   586314 586314 Broke, Robert, of Bromley 0
4516209 2205479 2205479 defendant Fyge William   586314 586314 Fyge, William, of Bromley 0
4517870 2205974 2205974 defendant Henden John   586314 586314 Henden, John, of Bromley 1
4594694 2229595 2229595 plaintiff Prat William   586314 586314 Prat, William, of Bromley 0
4594695 2229595 2229595 defendant Person Thomas   586314 586314 Person, Thomas, of Bromley 0
4595283 2229777 2229777 defendant Colette John   586314 586314 Colette, John, of Bromley, vicar 0
4605477 2232842 2232842 defendant del Botelry Henry   586314 586314 del Botelry, Henry, of Bromley Abbot 1
4627655 2239580 2239580 plaintiff Rose John   586314 586314 Rose, John, of Bromley 0
4693356 2263425 2263425 defendant Cola Hugh husbandman 586314 586314 Cola, Hugh, of Bromley, husbandman 0
4695851 2264186 2264186 defendant Orgrave John husbandman 586314 586314 Orgrave, John, of Bromley Abbot, husbandman 0
4695852 2264186 2264186 defendant Don William husbandman 586314 586314 Don, William, of Bromley Abbot, husbandman 1
4722597 2272382 2272382 defendant Jeweler Richard husbandman 586314 586314 Jeweler, Richard, of Bromley, husbandman 0
4722598 2272382 2272382 defendant Jeweler John laborer 586314 586314 Jeweler, John, of Bromley, laborer 1
4722600 2272383 2272383 defendant Jeweler Richard husbandman 586314 586314 Jeweler, Richard, of Bromley, husbandman 0
4722601 2272383 2272383 defendant Jeweler John laborer 586314 586314 Jeweler, John, of Bromley, laborer 1
4722785 2272441 2272441 defendant Porter John husbandman 586314 586314 Porter, John, of Bromley, husbandman 4
4754919 2281919 2281919 defendant Broker Nicholas fuller 586314 586314 Broker, Nicholas, of Bromley, fuller 0
4755600 2282133 2282133 defendant Brokere Nicholas fuller 586314 586314 Brokere, Nicholas, of Bromley, fuller 0
4775341 2288281 2288281 defendant Dey John smith 586314 586314 Dey, John, of Bromley, smith 0
4775343 2288282 2288282 defendant Dey John smith 586314 586314 Dey, John, of Bromley, smith 0
4791240 2293357 2293357 defendant atte Chaumber John laborer 586314 586314 atte Chaumber, John, of Bromley, laborer 2
4795904 2294869 2294869 defendant Shotte Henry husbandman 586314 586314 Shotte, Henry, of Bromley, husbandman 0
4802792 2297061 2297061 defendant Parker Roger husbandman 586314 586314 Parker, Roger, of Bromley, husbandman 0
4849274 2311250 2311250 defendant Swynton William   586314 586314 Swynton, William, of Bromley, vicar 0
4849276 2311251 2311251 defendant Swynton William   586314 586314 Swynton, William, of Bromley, vicar 0
4932622 2336595 2336595 defendant Juerler or Ineler Richard husbandman 586314 586314 Juerler or Ineler, Richard, of Bromley, husbandman 0
4935445 2337480 2337480 defendant Abey John yeoman 586314 586314 Abey, John, of Bromley, yeoman 0
4954663 2343350 2343350 defendant Hawekyn John husbandman 586314 586314 Hawekyn, John, of Bromley, husbandman 0
4954664 2343350 2343350 defendant Stake John husbandman 586314 586314 Stake, John, of Bromley, husbandman 1
4954667 2343350 2343350 defendant Raynwell John husbandman 586314 586314 Raynwell, John, of Bromley, husbandman 4
4954668 2343350 2343350 defendant Raynwell Philip husbandman 586314 586314 Raynwell, Philip, of Bromley, husbandman 5
4954669 2343350 2343350 defendant Raynwell Henry husbandman 586314 586314 Raynwell, Henry, of Bromley, husbandman 6
4954670 2343350 2343350 defendant Raynwell William husbandman 586314 586314 Raynwell, William, of Bromley, husbandman 7
4996510 2355812 2355812 defendant Renny Thomas husbandman 586314 586314 Renny, Thomas, of Bromley, husbandman 4
4996521 2355813 2355813 defendant Romy Thomas husbandman 586314 586314 Romy, Thomas, of Bromley, husbandman 5
5003899 2358028 2358028 plaintiff Perys Patrick clerk & chaplain 586314 586314 Perys, Patrick, of Bromley, clerk & chaplain 0
5003900 2358028 2358028 defendant Wythemer William yeoman 586314 586314 Wythemer, William, of Bromley, yeoman 0
5015396 2361382 2361382 defendant Wilkyn Roger husbandman 586314 586314 Wilkyn, Roger, of Bromley, husbandman 0
5056861 2373627 2373627 defendant Poynt Peter soldier 586314 586314 Poynt, Peter, of Bromley, soldier 1
5056862 2373627 2373627 defendant Okle John soldier 586314 586314 Okle, John, of Bromley, soldier 2
5063627 2375654 2375654 defendant Hert Robert   586314 586314 Hert, Robert, of Bromley 0
5110361 2389434 2389434 defendant Bevell Thomas husbandman 586314 586314 Bevell, Thomas, of Bromley, husbandman 2
5110678 2389527 2389527 defendant Payn Robert husbandman 586314 586314 Payn, Robert, of Bromley, husbandman 0
5110679 2389527 2389527 defendant Payn Henry husbandman 586314 586314 Payn, Henry, of Bromley, husbandman 1
5110683 2389528 2389528 defendant Payn Robert husbandman 586314 586314 Payn, Robert, of Bromley, husbandman 0
5110684 2389528 2389528 defendant Payn Henry husbandman 586314 586314 Payn, Henry, of Bromley, husbandman 1
5122880 2393125 2393125 defendant Fox Richard carpenter 586314 586314 Fox, Richard, of Bromley, carpenter 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);