names

73 rows where place_id = 592119

✎ 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
3606629 1869747 1869747 defendant Bocher William butcher 592119 592119 Bocher, William, of Magna Marlowe, butcher 1
3681559 1920320 1920320 defendant Whalley William yeoman 592119 592119 Whalley, William, of Magna Marlowe, yeoman 1
3704948 1927840 1927840 defendant Shyrwoode David yeoman 592119 592119 Shyrwoode, David, of Magna Marlowe, yeoman 0
3708529 1928965 1928965 plaintiff Oderyngton Thomas   592119 592119 Oderyngton, Thomas, of Magna Marlowe 0
3728439 1935143 1935143 defendant Grey Thomas, senior gent 592119 592119 Grey, Thomas, senior, of Magna Marlowe, gent 0
3728470 1935154 1935154 defendant Grey Thomas, senior gent 592119 592119 Grey, Thomas, senior, of Magna Marlowe, gent 0
3733209 1936619 1936619 defendant Fetyng Thomas tanner 592119 592119 Fetyng, Thomas, of Magna Marlowe, tanner 0
3749936 1941896 1941896 defendant Jenyn John wheeler 592119 592119 Jenyn, John, of Magna Marlowe, wheeler 1
3751028 1942254 1942254 defendant Fetyng Thomas tanner 592119 592119 Fetyng, Thomas, of Magna Marlowe, tanner 0
3765178 1946772 1946772 defendant Jenyn John wheeler 592119 592119 Jenyn, John, of Magna Marlowe, wheeler 0
3769410 1948090 1948090 defendant Claydon John clerk 592119 592119 Claydon, John, of Magna Marlowe, clerk 1
3776349 1950352 1950352 defendant Colard Thomas yeoman 592119 592119 Colard, Thomas, of Magna Marlowe, yeoman 0
3777706 1950777 1950777 defendant Burges John draper 592119 592119 Burges, John, of Magna Marlowe, draper 0
3781355 1951911 1951911 defendant Ferne John carpenter 592119 592119 Ferne, John, of Magna Marlowe, carpenter 1
3795077 1956326 1956326 defendant Burges John draper 592119 592119 Burges, John, of Magna Marlowe, draper 0
3827668 1966514 1966514 defendant Ravenyng Thomas husbandman 592119 592119 Ravenyng, Thomas, of Magna Marlowe, husbandman 1
3828841 1966900 1966900 defendant Ravenyng John husbandman 592119 592119 Ravenyng, John, of Magna Marlowe, husbandman 0
3828842 1966900 1966900 defendant Dary Walter laborer 592119 592119 Dary, Walter, of Magna Marlowe, laborer 1
3830466 1967406 1967406 defendant Haltman Edward clerk 592119 592119 Haltman, Edward, of Magna Marlowe, clerk 2
3848488 1973108 1973108 defendant Rowland Robert husbandman 592119 592119 Rowland, Robert, of Magna Marlowe, husbandman 0
3858469 1976309 1976309 defendant Ravenyng Thomas husbandman 592119 592119 Ravenyng, Thomas, of Magna Marlowe, husbandman 0
3859903 1976817 1976817 defendant Burges John tailor 592119 592119 Burges, John, of Magna Marlowe, tailor 1
3860733 1977081 1977081 defendant Burges John draper 592119 592119 Burges, John, of Magna Marlowe, draper 0
3887920 1986209 1986209 defendant Darrell John laborer 592119 592119 Darrell, John, of Magna Marlowe, laborer 0
3887922 1986210 1986210 defendant Darrell John laborer 592119 592119 Darrell, John, of Magna Marlowe, laborer 0
3889207 1986627 1986627 defendant Ravenyng alias Carter Thomas husbandman 592119 592119 Ravenyng alias Carter, Thomas, of Magna Marlowe, husbandman 1
3896856 1989160 1989160 defendant Smyth Robert butcher 592119 592119 Smyth, Robert, of Magna Marlowe, butcher 0
3913623 1994894 1994894 defendant Oderyngton alias Pryst William yeoman 592119 592119 Oderyngton alias Pryst, William, of Magna Marlowe, yeoman 0
3914611 1995229 1995229 defendant Prist alias Odyngton William yeoman 592119 592119 Prist alias Odyngton, William, of Magna Marlowe, yeoman 0
3914612 1995229 1995229 defendant Bold John butcher 592119 592119 Bold, John, of Magna Marlowe, butcher 1
3919309 1996787 1996787 defendant Bolde John butcher 592119 592119 Bolde, John, of Magna Marlowe, butcher 0
3923002 1998000 1998000 defendant Preste William yeoman 592119 592119 Preste, William, of Magna Marlowe, yeoman 0
3962747 2011557 2011557 defendant Norton John   592119 592119 Norton, John, of Magna Marlowe, wool winder 0
3962748 2011557 2011557 defendant Brynkhirst John yeoman 592119 592119 Brynkhirst, John, of Magna Marlowe, or of Bysham, Berks, yeoman 1
3963997 2012018 2012018 defendant French Thomas   592119 592119 French, Thomas, of Magna Marlowe, wright 0
4070607 2049782 2049782 defendant Harrys Robert butcher 592119 592119 Harrys, Robert, of Magna Marlowe, butcher 0
4074065 2051017 2051017 defendant Prieste William yeoman 592119 592119 Prieste, William, of Magna Marlowe, yeoman 1
4074068 2051018 2051018 defendant Prieste William yeoman 592119 592119 Prieste, William, of Magna Marlowe, yeoman 1
4076600 2051930 2051930 defendant Webbe Richard bargeman 592119 592119 Webbe, Richard, of Magna Marlowe, bargeman 1
4131336 2071527 2071527 defendant Seymar John yeoman 592119 592119 Seymar, John, of Magna Marlowe, yeoman 1
4133668 2072375 2072375 defendant Spereman John yeoman 592119 592119 Spereman, John, of Magna Marlowe, yeoman 0
4199418 2095344 2095344 defendant Moore Ralph butcher 592119 592119 Moore, Ralph, of Magna Marlowe, butcher 0
4199419 2095344 2095344 defendant Moore John, junior butcher 592119 592119 Moore, John, junior, of Magna Marlowe, butcher 1
4213996 2100417 2100417 defendant Lamden or Lambden William yeoman 592119 592119 Lamden or Lambden, William, of Magna Marlowe, yeoman 0
4218010 2101794 2101794 defendant Collyns alias A Deane Julia widow 592119 592119 Collyns alias A Deane, Julia, of Magna Marlowe, widow 1
4218012 2101795 2101795 defendant Frenche David husbandman 592119 592119 Frenche, David, of Magna Marlowe, husbandman 0
4302590 2131023 2131023 defendant Bennett John yeoman 592119 592119 Bennett, John, of Magna Marlowe, yeoman 0
4338875 2143351 2143351 defendant Draper alias Farmer Thomas gent 592119 592119 Draper alias Farmer, Thomas, of Magna Marlowe, gent 0
4342510 2144653 2144653 defendant Symondes John gardener 592119 592119 Symondes, John, of Magna Marlowe, yeoman, or of Ratcliff, Middx, gardener 0
4347849 2146498 2146498 defendant Austen Richard fisher 592119 592119 Austen, Richard, of Magna Marlowe, fisher 1
4347850 2146498 2146498 defendant Frenche David husbandman 592119 592119 Frenche, David, of Magna Marlowe, husbandman 2
4392670 2162167 2162167 defendant Bennett John yeoman 592119 592119 Bennett, John, of Magna Marlowe, yeoman 1
4961665 2345454 2345454 defendant Semar Thomas gent 592119 592119 Semar, Thomas, of Magna Marlowe, gent 0
4961666 2345454 2345454 defendant Kyghton John yeoman 592119 592119 Kyghton, John, of Magna Marlowe, yeoman 1
4961667 2345454 2345454 defendant Wolton Thomas carpenter 592119 592119 Wolton, Thomas, of Magna Marlowe, carpenter 2
4961668 2345454 2345454 defendant Tony Nicholas weaver 592119 592119 Tony, Nicholas, of Magna Marlowe, weaver 3
4961669 2345454 2345454 defendant Clyve John yeoman 592119 592119 Clyve, John, of Magna Marlowe, yeoman 4
5018526 2362299 2362299 defendant Pole Thomas glover 592119 592119 Pole, Thomas, of Magna Marlowe, glover 0
5216088 2420434 2420434 defendant Laton Philip husbandman 592119 592119 Laton, Philip, of Magna Marlowe, husbandman 0
5216089 2420434 2420434 defendant Brene or Breve John miller 592119 592119 Brene or Breve, John, of Magna Marlowe, miller 1
5225641 2423171 2423171 defendant Hibbert Richard carpenter 592119 592119 Hibbert, Richard, of Magna Marlowe, carpenter 0
5225642 2423171 2423171 defendant Brian Thomas barber 592119 592119 Brian, Thomas, of Magna Marlowe, barber 1
5234108 2425569 2425569 defendant Longe John husbandman 592119 592119 Longe, John, of Magna Marlowe, husbandman 1
5277062 2438375 2438375 defendant Burley John, junior   592119 592119 Burley, John, junior, of Magna Marlowe, yeoman, bailiff of Magna Marlowe 0
5350388 2460244 2460244 defendant Dycunson Richard husbandman 592119 592119 Dycunson, Richard, of Magna Marlowe, husbandman 0
5350391 2460244 2460244 defendant Parker John husbandman 592119 592119 Parker, John, of Magna Marlowe, husbandman 3
5350392 2460244 2460244 defendant Hampshire John husbandman 592119 592119 Hampshire, John, of Magna Marlowe, husbandman 4
5478367 2498558 2498558 defendant Bernard John husbandman 592119 592119 Bernard, John, of Magna Marlowe, husbandman 0
5478459 2498583 2498583 defendant Blewet Thomas yeoman 592119 592119 Blewet, Thomas, of Magna Marlowe, yeoman 0
5576353 2527658 2527658 defendant Sternethwayte Leonard yeoman 592119 592119 Sternethwayte, Leonard, of Magna Marlowe, yeoman 7
5592072 2532513 2532513 defendant Cutler Thomas   592119 592119 Cutler, Thomas, of Magna Marlowe, tile maker 0
5592073 2532513 2532513 defendant West Richard   592119 592119 West, Richard, of Magna Marlowe, tile maker 1
5592075 2532513 2532513 defendant Tyler Richard   592119 592119 Tyler, Richard, of Magna Marlowe, tile maker 3

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