names

100 rows where place_id = 586145

✎ 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
3588029 1863909 1863909 defendant Lane Thomas tanner of barker 586145 586145 Lane, Thomas, of Crayford, tanner of barker 1
3600254 1867726 1867726 defendant Lane Thomas tanner 586145 586145 Lane, Thomas, of Crayford, tanner 2
3617460 1873081 1873081 defendant Harry John yeoman 586145 586145 Harry, John, of Crayford, yeoman 1
3631691 1904725 1904725 defendant Lane Thomas tanner 586145 586145 Lane, Thomas, of Crayford, tanner 0
3644951 1908830 1908830 defendant Force Giles husbandman 586145 586145 Force, Giles, of Crayford, husbandman 0
3647757 1909691 1909691 defendant Lane Thomas husbandman 586145 586145 Lane, Thomas, of Crayford, husbandman 0
3647848 1909723 1909723 defendant Kyng Richard husbandman 586145 586145 Kyng, Richard, of Crayford, husbandman 0
3647849 1909723 1909723 defendant Elys Richard laborer 586145 586145 Elys, Richard, of Crayford, laborer 1
3662199 1914093 1914093 defendant Pockwell John husbandman 586145 586145 Pockwell, John, of Crayford, husbandman 0
3666092 1915338 1915338 defendant Pookwell John husbandman 586145 586145 Pookwell, John, of Crayford, husbandman 0
3684362 1921240 1921240 defendant Potman Lawrence husbandman 586145 586145 Potman, Lawrence, of Crayford, husbandman 3
3685318 1921560 1921560 defendant Potman Nicholas tailor 586145 586145 Potman, Nicholas, of Crayford, tailor 1
3685322 1921561 1921561 defendant Potman Nicholas tailor 586145 586145 Potman, Nicholas, of Crayford, tailor 0
3699550 1926091 1926091 defendant Forest Richard yeoman 586145 586145 Forest, Richard, of Crayford, yeoman 1
3725003 1934105 1934105 defendant Bulbek Henry husbandman 586145 586145 Bulbek, Henry, of Crayford, husbandman 2
3745499 1940499 1940499 plaintiff Bull Henry yeoman 586145 586145 Bull, Henry, of Crayford, yeoman 0
3765504 1946876 1946876 defendant Pynden Agnes widow 586145 586145 Pynden, Agnes, of Crayford, widow 1
3772357 1949040 1949040 defendant Forest Richard yeoman 586145 586145 Forest, Richard, of Crayford, yeoman 2
3792188 1955408 1955408 defendant Hobson Denise widow 586145 586145 Hobson, Denise, of Crayford, widow 1
3910014 1993656 1993656 defendant Hastelyn Robert butcher 586145 586145 Hastelyn, Robert, of Crayford, butcher 0
3910061 1993669 1993669 defendant Hastlyn Robert husbandman 586145 586145 Hastlyn, Robert, of Crayford, husbandman 0
3912720 1994588 1994588 defendant Bevyngton or Bebyngton John tanner 586145 586145 Bevyngton or Bebyngton, John, of Crayford, tanner 0
3926529 1999206 1999206 defendant Lamport Robert yeoman 586145 586145 Lamport, Robert, of Crayford, yeoman 0
3926531 1999207 1999207 defendant Thomson William yeoman 586145 586145 Thomson, William, of Crayford, yeoman 0
4020166 2031934 2031934 defendant Rawlyns William yeoman 586145 586145 Rawlyns, William, of Crayford, or of Dartford, Kent, yeoman 2
4062635 2046934 2046934 defendant Mentecote Joan widow 586145 586145 Mentecote, Joan, of Crayford, widow 0
4156523 2080357 2080357 defendant Hunte William gent 586145 586145 Hunte, William, of Crayford, gent 0
4236493 2108337 2108337 defendant Taylor Richard yeoman 586145 586145 Taylor, Richard, of Crayford, yeoman 0
4236494 2108337 2108337 defendant Kettle Richard yeoman 586145 586145 Kettle, Richard, of Crayford, yeoman 1
4236495 2108337 2108337 defendant Adgar John, junior yeoman 586145 586145 Adgar, John, junior, of Crayford, yeoman 2
4320084 2137132 2137132 defendant Browne Thomas gent 586145 586145 Browne, Thomas, of Crayford, gent 0
4320085 2137132 2137132 defendant Harman Nicholas gent 586145 586145 Harman, Nicholas, of Crayford, gent 1
4647606 2245354 2245354 defendant Bonale John   586145 586145 Bonale, John, of Crayford 0
4760343 2283587 2283587 defendant Palmer John farmer 586145 586145 Palmer, John, of Crayford, farmer 0
4774500 2288009 2288009 defendant Tichoud John laborer 586145 586145 Tichoud, John, of Crayford, laborer 0
4790151 2293001 2293001 defendant Chaukyn Robert laborer 586145 586145 Chaukyn, Robert, of Crayford, laborer 0
4790153 2293002 2293002 defendant Lovell William farmer 586145 586145 Lovell, William, of Crayford, farmer 0
4800194 2296235 2296235 defendant Tichond John laborer 586145 586145 Tichond, John, of Crayford, laborer 0
4911126 2329991 2329991 defendant Benne alias Webbe Henry weaver 586145 586145 Benne alias Webbe, Henry, of Crayford, weaver 0
4943449 2339919 2339919 defendant Skynnere Thomas tanner 586145 586145 Skynnere, Thomas, of Crayford, tanner 0
5111151 2389650 2389650 defendant Moleman Thomas husbandman 586145 586145 Moleman, Thomas, of Crayford, husbandman 1
5118625 2391877 2391877 defendant Ponynges Edward clerk 586145 586145 Ponynges, Edward, of Crayford, clerk 0
5119514 2392138 2392138 defendant Whitland alias Taillour John tailor 586145 586145 (Whitland alias Taillour, John, of Crayford, tailor 1
5119515 2392138 2392138 defendant Wattys Margaret widow 586145 586145 Wattys, Margaret, of Crayford, widow 2
5141438 2398610 2398610 defendant Howe John husbandman 586145 586145 Howe, John, of Crayford, husbandman 2
5159331 2403845 2403845 defendant Ponyngys Edward clerk 586145 586145 Ponyngys, Edward, of Crayford, clerk 0
5195246 2414356 2414356 defendant Ponyngys Edward clerk 586145 586145 Ponyngys, Edward, of Crayford, clerk 0
5209182 2418414 2418414 defendant Ponyngys Edward clerk 586145 586145 Ponyngys, Edward, of Crayford, clerk 0
5222794 2422381 2422381 defendant Bigge Thomas yeoman 586145 586145 Bigge, Thomas, of Crayford, yeoman 2
5222799 2422382 2422382 defendant Bigge Thomas yeoman 586145 586145 Bigge, Thomas, of Crayford, yeoman 3
5224255 2422765 2422765 defendant Martyn Robert yeoman 586145 586145 Martyn, Robert, of Crayford, yeoman 3
5224259 2422766 2422766 defendant Martyn Robert yeoman 586145 586145 Martyn, Robert, of Crayford, yeoman 2
5225135 2423023 2423023 defendant Ponyngys Edward clerk 586145 586145 Ponyngys, Edward, of Crayford, clerk 0
5233169 2425288 2425288 defendant Russell Simon husbandman 586145 586145 Russell, Simon, of Crayford, husbandman 1
5240669 2427483 2427483 defendant Russell Simon husbandman 586145 586145 Russell, Simon, of Crayford, husbandman 0
5240672 2427484 2427484 defendant Russe Henry husbandman 586145 586145 Russe, Henry, of Crayford, husbandman 1
5240674 2427485 2427485 defendant Russe Henry husbandman 586145 586145 Russe, Henry, of Crayford, husbandman 0
5242994 2428153 2428153 defendant Wattys John husbandman 586145 586145 Wattys, John, of Crayford, husbandman 0
5244774 2428641 2428641 defendant Martyn Robert yeoman 586145 586145 Martyn, Robert, of Crayford, yeoman 2
5307354 2447203 2447203 defendant Walsh Roger husbandman 586145 586145 Walsh, Roger, of Crayford, husbandman 1
5307355 2447203 2447203 defendant Bygge John husbandman 586145 586145 Bygge, John, of Crayford, husbandman 2
5307360 2447204 2447204 defendant Hostlyn Richard husbandman 586145 586145 Hostlyn, Richard, of Crayford, husbandman 3
5322867 2451919 2451919 defendant Lane John yeoman 586145 586145 Lane, John, of Crayford, yeoman 0
5323119 2451998 2451998 defendant Bulbek Thomas yeoman 586145 586145 Bulbek, Thomas, of Crayford, yeoman 3
5356868 2462207 2462207 defendant Moger Robert laborer 586145 586145 Moger, Robert, of Crayford, laborer 1
5360626 2463356 2463356 defendant Gildewyn Richard husbandman 586145 586145 Gildewyn, Richard, of Crayford, husbandman 1
5450500 2490033 2490033 defendant Brokhole (illegible) laborer 586145 586145 Brokhole, _, of Crayford, laborer 1
5471712 2496489 2496489 defendant Russell William husbandman 586145 586145 Russell, William, of Crayford, husbandman 1
5471713 2496489 2496489 defendant Bymewyll John yeoman 586145 586145 Bymewyll, John, of Crayford, yeoman 2
5471714 2496489 2496489 defendant Ereke Katherine widow 586145 586145 Ereke, Katherine, of Crayford, widow 3
5497571 2504215 2504215 defendant Lane Geoffrey husbandman 586145 586145 Lane, Geoffrey, of Crayford, husbandman 1
5497572 2504215 2504215 defendant Mayhowe John husbandman 586145 586145 Mayhowe, John, of Crayford, husbandman 2
5503142 2505894 2505894 defendant Raweley Thomas yeoman 586145 586145 Raweley, Thomas, of Crayford, yeoman 2
5523026 2512029 2512029 defendant Hunte John yeoman 586145 586145 Hunte, John, of Crayford, yeoman 0
5523027 2512029 2512029 defendant Richewode Christopher carpenter 586145 586145 Richewode, Christopher, of Crayford, carpenter 1
5523029 2512029 2512029 defendant Bilane John husbandman 586145 586145 Bilane, John, of Crayford, husbandman 3
5525461 2512554 2512554 defendant Hewet John yeoman 586145 586145 Hewet, John, of Crayford, yeoman 1
5527214 2513089 2513089 defendant Harres John yeoman 586145 586145 Harres, John, of Crayford, yeoman 2
5527731 2513253 2513253 defendant Morton Henry chaplain 586145 586145 Morton, Henry, of Crayford, chaplain 1
5527732 2513253 2513253 defendant Oatrede Robert husbandman 586145 586145 Oatrede, Robert, of Crayford, husbandman 2
5527737 2513254 2513254 defendant Darker John yeoman 586145 586145 Darker, John, of Crayford, yeoman 1
5527742 2513255 2513255 defendant Darker John yeoman 586145 586145 Darker, John, of Crayford, yeoman 1
5527758 2513258 2513258 defendant Quyntyne Thomas baker 586145 586145 Quyntyne, Thomas, of Crayford, baker 2
5527769 2513260 2513260 defendant Ketylwell William husbandman 586145 586145 Ketylwell, William, of Crayford, husbandman 3
5527770 2513260 2513260 defendant Fanyntyne Thomas baker 586145 586145 Fanyntyne, Thomas, of Crayford, baker 4
5527782 2513262 2513262 defendant Morton John yeoman 586145 586145 Morton, John, of Crayford, yeoman 2
5527787 2513263 2513263 defendant Belamy John husbandman 586145 586145 Belamy, John, of Crayford, husbandman 1
5527794 2513264 2513264 defendant Whytechurch Thomas yeoman 586145 586145 Whytechurch, Thomas, of Crayford, yeoman 0
5527799 2513265 2513265 defendant Morton Henry chaplain 586145 586145 Morton, Henry, of Crayford, chaplain 1
5527800 2513265 2513265 defendant Outrede Robert husbandman 586145 586145 Outrede, Robert, of Crayford, husbandman 2
5527809 2513267 2513267 defendant Bylane John husbandman 586145 586145 Bylane, John, of Crayford, husbandman 1
5527815 2513268 2513268 defendant Whitechurch Thomas yeoman 586145 586145 Whitechurch, Thomas, of Crayford, yeoman 0
5536833 2516007 2516007 defendant Hunt John husbandman 586145 586145 Hunt, John, of Crayford, husbandman 0
5537581 2516243 2516243 defendant Gowge Nicholas husbandman 586145 586145 Gowge, Nicholas, of Crayford, husbandman 1
5560499 2523030 2523030 defendant Brok Thomas husbandman 586145 586145 Brok, Thomas, of Crayford, husbandman 1
5566867 2524906 2524906 defendant Marshall John gent 586145 586145 Marshall, John, of Crayford, gent 0
5574365 2527067 2527067 defendant Lane Thomas tanner 586145 586145 Lane, Thomas, of Crayford, tanner 1
5577014 2527854 2527854 defendant Vesse Thomas yeoman 586145 586145 Vesse, Thomas, of Crayford, yeoman 1
5589456 2531704 2531704 defendant Lane Thomas yeoman 586145 586145 Lane, Thomas, of Crayford, yeoman 0
5602288 2535609 2535609 defendant Thomson Thomas husbandman 586145 586145 Thomson, Thomas, of Crayford, husbandman 0

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);