names

89 rows where place_id = 594963

✎ 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
3618283 1873346 1873346 defendant Scotyr William miller 594963 594963 Scotyr, William, of Est Rasyn, miller 1
3655549 1911995 1911995 defendant Rawlenson William yeoman 594963 594963 Rawlenson, William, of Est Rasyn, yeoman 0
3702231 1926954 1926954 plaintiff Cater John   594963 594963 Cater, John, of Est Rasyn 0
3728974 1935308 1935308 defendant Rawlynson William glover 594963 594963 Rawlynson, William, of Est Rasyn, glover 0
3789495 1954539 1954539 defendant Mosy John tailor 594963 594963 Mosy, John, of Est Rasyn, tailor 0
3922822 1997936 1997936 defendant Rowlet Lawrence yeoman 594963 594963 Rowlet, Lawrence, of Est Rasyn, yeoman 0
4446260 2183743 2183743 defendant Fole Hugh   594963 594963 Fole, Hugh, of East Rasyn 0
4547435 2215126 2215126 defendant Riby_ Alice   594963 594963 Riby_, Alice, of East Rasyn 1
4652379 2246693 2246693 defendant Scayll John merchant 594963 594963 Scayll, John, of Est Rasyn, merchant 0
4746324 2279421 2279421 defendant Chapman Thomas chapman 594963 594963 Chapman, Thomas, of East Rasyn, chapman 0
4756146 2282296 2282296 defendant Barleburgh Robert tailor 594963 594963 Barleburgh, Robert, of East Rasyn, tailor 0
4758936 2283149 2283149 defendant Barleburgh Robert draper 594963 594963 Barleburgh, Robert, of East Rasyn, draper 0
4782459 2290522 2290522 defendant Walys John chapman 594963 594963 Walys, John, of Est Rasyn, chapman 2
4789323 2292724 2292724 defendant Welton John glover 594963 594963 Welton, John, of Est Rasyn, glover 0
4809587 2299164 2299164 defendant Scayle John merchant 594963 594963 Scayle, John, of East Rasyn, merchant 0
4813619 2300364 2300364 defendant Jamesson William chapman 594963 594963 Jamesson, William, of East Rasyn, chapman 0
4822640 2303159 2303159 defendant Skayle John merchant 594963 594963 Skayle, John, of East Rasyn, merchant 0
4825647 2304059 2304059 defendant Skayles John merchant 594963 594963 Skayles, John, of East Rasyn, merchant 0
4833190 2306393 2306393 defendant Belle Henry   594963 594963 Belle, Henry, of East Rasyn, vicar 0
4834679 2306848 2306848 defendant Snayth John spicer 594963 594963 Snayth, John, of East Rasyn, spicer 1
4837283 2307605 2307605 defendant Jamesson William husbandman 594963 594963 Jamesson, William, of East Rasyn, husbandman 4
4838686 2308024 2308024 defendant Kelsey John merchant 594963 594963 Kelsey, John, of East Rasyn, merchant 0
4859599 2314372 2314372 defendant Jamesson William chapman 594963 594963 Jamesson, William, of Est Rasyn, chapman 0
4860056 2314516 2314516 plaintiff Chesterfeld Robert (legal representative) 594963 594963 Chesterfeld, Robert, of Est Rasyn, merchant, executors of 0
4864524 2315877 2315877 defendant Hedon William glover 594963 594963 Hedon, William, of Est Rasyn, glover 3
4864526 2315877 2315877 defendant Jamesson William husbandman 594963 594963 Jamesson, William, of Est Rasyn, husbandman 5
4865860 2316292 2316292 defendant Jamesson William merchant 594963 594963 Jamesson, William, of Est Rasyn, merchant 0
4866556 2316501 2316501 defendant Lyvyesby or Lynyesby William draper 594963 594963 (Lyvyesby or Lynyesby, William, of Est Rasyn, draper 4
4866851 2316596 2316596 defendant Jamesson William husbandman 594963 594963 Jamesson, William, of Est Rasyn, husbandman 2
4869096 2317307 2317307 defendant Broune William yeoman 594963 594963 Broune, William, of Est Rasyn, yeoman 0
4876700 2319684 2319684 defendant Plummer Thomas fisher 594963 594963 Plummer, Thomas, of Est Rasyn, fisher 1
4876701 2319684 2319684 defendant Gayte Alice widow 594963 594963 Gayte, Alice, of Est Rasyn, widow 2
4876703 2319684 2319684 defendant Barbour John barber 594963 594963 Barbour, John, of Est Rasyn, barber 4
4897501 2325878 2325878 defendant Jamesson William husbandman 594963 594963 Jamesson, William, of Est Rasyn, husbandman 3
4905656 2328370 2328370 defendant Benett John skinner 594963 594963 Benett, John, of Est Rasyn, skinner 4
4911563 2330118 2330118 defendant Plommer Thomas fisher 594963 594963 Plommer, Thomas, of East Rasyn, fisher 3
4916064 2331524 2331524 defendant Caynby William shoemaker 594963 594963 Caynby, William, of East Rasyn, shoemaker 1
4916065 2331524 2331524 defendant Warde Thomas chapman 594963 594963 Warde, Thomas, of East Rasyn, chapman 2
4916836 2331769 2331769 defendant Southern William butcher 594963 594963 Southern, William, of East Rasyn, butcher 0
4916837 2331769 2331769 defendant Jamesson William husbandman 594963 594963 Jamesson, William, of East Rasyn, husbandman 1
4930384 2335902 2335902 defendant Bell Henry clerk 594963 594963 Bell, Henry, of East Rasyn, clerk 0
4942313 2339585 2339585 defendant Jamesson William husbandman 594963 594963 Jamesson, William, of Est Rasyn, husbandman 0
4946697 2340967 2340967 defendant Curtays Peter husbandman 594963 594963 Curtays, Peter, of Est Rasyn, husbandman 1
4967967 2347360 2347360 plaintiff Mundson John merchant 594963 594963 Mundson, John, of East Rasyn, merchant 1
4967971 2347361 2347361 plaintiff Mundson John merchant 594963 594963 Mundson, John, of Est Rasyn, merchant 1
4990487 2354062 2354062 defendant Osteler John ostler 594963 594963 Osteler, John, of East Rasyn, ostler 1
4992948 2354774 2354774 defendant Monson John yeoman 594963 594963 Monson, John, of East Rasyn, yeoman 0
4992949 2354774 2354774 defendant Hedon Richard   594963 594963 Hedon, Richard, of East Rasyn, glove maker 1
4995730 2355563 2355563 defendant Warde Thomas husbandman 594963 594963 Warde, Thomas, of East Rasyn, husbandman 0
5007527 2359098 2359098 defendant Webster William weaver 594963 594963 Webster, William, of East Rasyn, weaver 0
5027747 2364993 2364993 defendant Webster William weaver 594963 594963 Webster, William, of Est Rasyn, weaver 0
5028667 2365261 2365261 defendant Aweneby William yeoman 594963 594963 Aweneby, William, of Est Rasyn, yeoman 1
5028668 2365261 2365261 defendant Milner Alexander miller 594963 594963 Milner, Alexander, of Est Rasyn, miller 2
5028671 2365262 2365262 plaintiff Mundson John merchant 594963 594963 Mundson, John, of Est Rasyn, merchant 0
5039719 2368521 2368521 defendant Warde Thomas yeoman 594963 594963 Warde, Thomas, of East Rasyn, yeoman 1
5042538 2369373 2369373 defendant Bell Henry clerk 594963 594963 Bell, Henry, of East Rasyn, clerk 0
5042539 2369373 2369373 defendant Dawkyn William shoemaker 594963 594963 Dawkyn, William, of East Rasyn, shoemaker 1
5042540 2369373 2369373 defendant Derby Thomas tailor 594963 594963 Derby, Thomas, of East Rasyn, tailor 2
5046826 2370673 2370673 plaintiff Mundson John merchant 594963 594963 Mundson, John, of East Rasyn, merchant 0
5050114 2371658 2371658 defendant Cade John butcher 594963 594963 Cade, John, of East Rasyn, butcher 0
5054625 2372959 2372959 defendant Warde Thomas yeoman 594963 594963 Warde, Thomas, of Est Rasyn, yeoman 1
5056620 2373551 2373551 defendant Broun William husbandman 594963 594963 Broun, William, of Est Rasyn, husbandman 3
5066602 2376536 2376536 defendant Ouneby William butcher 594963 594963 Ouneby, William, of Est Rasyn, butcher 0
5066604 2376537 2376537 plaintiff Mundson John merchant 594963 594963 Mundson, John, of Est Rasyn, merchant 0
5067058 2376671 2376671 defendant Chapman William mercer 594963 594963 Chapman, William, of Est Rasyn, mercer 2
5077666 2379816 2379816 defendant Warde Thomas yeoman 594963 594963 Warde, Thomas, of Est Rasyn, yeoman 1
5077668 2379817 2379817 defendant Couper Ralph cooper 594963 594963 Couper, Ralph, of Est Rasyn, cooper 0
5077671 2379818 2379818 defendant Warde Thomas yeoman 594963 594963 Warde, Thomas, of Est Rasyn, yeoman 1
5101688 2386913 2386913 defendant Shortsorowe William smith 594963 594963 Shortsorowe, William, of Est Rasyn, smith 0
5102124 2387048 2387048 plaintiff Beell William (legal representative) 594963 594963 Beell, William, of Est Rasyn, yeoman, executors of 0
5115532 2390969 2390969 defendant Kirke Edmund husbandman 594963 594963 Kirke, Edmund, of Est Rasyn, husbandman 2
5129017 2394971 2394971 defendant Jamesson William, senior   594963 594963 Jamesson, William, senior, of East Rasyn 0
5148240 2400625 2400625 defendant Jamesson William, sen merchant 594963 594963 Jamesson, William, sen, of East Rasyn, merchant 0
5176391 2408781 2408781 defendant Cade John husbandman 594963 594963 Cade, John, of East Rasyn, husbandman 3
5176392 2408781 2408781 defendant Cade Thomas butcher 594963 594963 Cade, Thomas, of East Rasyn, butcher 4
5211801 2419193 2419193 defendant Warde Thomas chapman 594963 594963 Warde, Thomas, of Est Rasyn, chapman 2
5219272 2421361 2421361 defendant Bele Thomas yeoman 594963 594963 Bele, Thomas, of Est Rasyn, yeoman 3
5240788 2427517 2427517 defendant Cade Thomas butcher 594963 594963 Cade, Thomas, of Est Rasyn, butcher 0
5277632 2438537 2438537 defendant Jameson William, junior merchant 594963 594963 Jameson, William, junior, of Est Rasyn, merchant 1
5329771 2453978 2453978 defendant Mylnar William yeoman 594963 594963 Mylnar, William, of Est Rasyn, yeoman 2
5345936 2458861 2458861 defendant Scoter William miller 594963 594963 Scoter, William, of Est Rasyn, miller 1
5362071 2463802 2463802 defendant Bysshop John mercer 594963 594963 Bysshop, John, of Est Rasyn, mercer 0
5362881 2464036 2464036 defendant Boner William chaplain 594963 594963 Boner, William, of Est Rasyn, chaplain 1
5440958 2487202 2487202 defendant Milner William mercer 594963 594963 Milner, William, of East Rasyn, mercer 1
5468406 2495491 2495491 defendant Pye Henry tanner 594963 594963 Pye, Henry, of East Rasyn, tanner 3
5468424 2495496 2495496 defendant Pye Henry tanner 594963 594963 Pye, Henry, of East Rasyn, tanner 3
5506603 2506977 2506977 defendant Welton William chaplain 594963 594963 Welton, William, of Est Rasyn, chaplain 0
5506604 2506977 2506977 defendant Milner William mercer 594963 594963 Milner, William, of Est Rasyn, mercer 1
5557166 2522057 2522057 defendant Martyn John husbandman 594963 594963 Martyn, John, of Est Rasyn, 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);