names

65 rows where place_id = 606659

✎ 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
3666065 1915326 1915326 defendant Payne John husbandman 606659 606659 Payne, John, of Mellys, husbandman 0
3673152 1917613 1917613 defendant Cryse Joan widow 606659 606659 Cryse, Joan, of Mellys, widow 2
3685646 1921666 1921666 defendant Arnold William innholder 606659 606659 Arnold, William, of Mellys, innholder 0
3689028 1922730 1922730 defendant Hyll Thomas tucker 606659 606659 Hyll, Thomas, of Mellys, tucker 0
3711436 1929882 1929882 defendant Slege John tucker 606659 606659 Slege, John, of Mellys, clothier, or of Elme, tucker 0
3713249 1930451 1930451 defendant Kene Thomas yeoman 606659 606659 Kene, Thomas, of Mellys, yeoman 0
3723596 1933653 1933653 defendant Reynberd John butcher 606659 606659 Reynberd, John, of Mellys, butcher 1
3735990 1937494 1937494 defendant Sheperd John butcher 606659 606659 Sheperd, John, of Mellys, butcher 1
3735991 1937494 1937494 defendant Edward John tucker 606659 606659 Edward, John, of Mellys, tucker 2
3739422 1938539 1938539 defendant Reynberd John butcher 606659 606659 Reynberd, John, of Mellys, butcher 0
3787357 1953839 1953839 plaintiff Robyns John (legal representative) 606659 606659 Robyns, John, of Mellys, clothier, executrix of 0
3794379 1956121 1956121 defendant Palmer William Soms, weaver 606659 606659 Palmer William, of Mellys, Soms, weaver 1
3824775 1965622 1965622 defendant Cabegge John yeoman 606659 606659 Cabegge, John, of Mellys, yeoman 0
3897392 1989342 1989342 defendant Style William clothier 606659 606659 Style, William, of Mellys, clothier 4
3970130 2014153 2014153 defendant Browne John husbandman 606659 606659 Browne, John, of Mellys, husbandman 1
3982046 2018338 2018338 defendant Parsley John yeoman 606659 606659 Parsley, John, of Mellys, yeoman 0
4068090 2048893 2048893 defendant Wace Thomas yeoman 606659 606659 Wace, Thomas, of Mellys, yeoman 0
4068091 2048893 2048893 defendant Burrowe Robert sawyer 606659 606659 Burrowe, Robert, of Mellys, sawyer 1
4105675 2062319 2062319 defendant Browne Stephen husbandman 606659 606659 Browne, Stephen, of Mellys, husbandman 1
4131057 2071424 2071424 defendant Reade John laborer 606659 606659 Reade, John, of Mellys, laborer 0
4140152 2074723 2074723 defendant Runketle Robert (legal representative) 606659 606659 Runketle, Robert, of Mellys, executors of 0
4140153 2074723 2074723 defendant Tostewood Christopher yeoman 606659 606659 (Tostewood, Christopher, of Mellys, yeoman 1
4211403 2099542 2099542 defendant Tyler Thomas husbandman 606659 606659 Tyler, Thomas, of Mellys, husbandman 2
4240547 2109821 2109821 defendant Fowler Humphrey clerk 606659 606659 Fowler, Humphrey, of mellys, clerk 1
4327725 2139597 2139597 defendant Toftwood Thomas gent 606659 606659 Toftwood, Thomas, of Mellys, gent 0
4327726 2139597 2139597 defendant Toftwood Christopher gent 606659 606659 Toftwood, Christopher, of Mellys, gent 1
4411277 2168357 2168357 defendant Howlett John laborer 606659 606659 Howlett, John, of Mellys, laborer 2
4474531 2192695 2192695 defendant Ledecombe John   606659 606659 Ledecombe, John, of Mellys, parson 0
4482085 2195108 2195108 defendant Clyve of Clyne John, junior   606659 606659 Clyve of Clyne, John, junior, of Mellys 0
4611186 2234561 2234561 defendant Pylton William   606659 606659 Pylton, William, of Mellys 0
4611188 2234562 2234562 defendant Pylton William   606659 606659 Pylton, William, of Mellys 0
4624260 2238575 2238575 defendant Towker John   606659 606659 Towker, John, of Mellys 0
4624262 2238576 2238576 defendant Towker John   606659 606659 Towker, John, of Mellys 0
4647256 2245252 2245252 plaintiff Sammuell John   606659 606659 Sammuell, John, of Mellys 0
4657061 2248102 2248102 defendant Pilton William   606659 606659 Pilton, William, of Mellys 0
4688765 2262043 2262043 defendant Nywebury Nicholas weaver 606659 606659 Nywebury, Nicholas, of Mellys, weaver 2
4688766 2262043 2262043 defendant Nywebury John husbandman 606659 606659 Nywebury, John, of Mellys, husbandman 3
4688767 2262043 2262043 defendant Nywebury William yeoman 606659 606659 Nywebury, William, of Mellys, yeoman 4
4762898 2284377 2284377 defendant Pilton (illegible) husbandman 606659 606659 Pilton, _, of Mellys, husbandman 0
4763132 2284451 2284451 defendant Pylton William husbandman 606659 606659 Pylton, William, of Mellys, husbandman 0
4932433 2336538 2336538 defendant Wyneld John husbandman 606659 606659 Wyneld, John, of Mellys, husbandman 1
4974864 2349452 2349452 defendant Broun Geoffrey dyer 606659 606659 Broun, Geoffrey, of Mellys, dyer 0
5055055 2373080 2373080 defendant Sammell John, junior gent 606659 606659 Sammell, John, junior, of Mellys, gent 0
5078175 2379959 2379959 defendant Sammell John gent 606659 606659 Sammell, John, of Mellys, gent 0
5086559 2382459 2382459 defendant Horner Thomas gent 606659 606659 Horner, Thomas, of Mellys, gent 0
5209848 2418614 2418614 defendant Frencheman William   606659 606659 Frencheman, William, of Mellys, servant 6
5269299 2436121 2436121 defendant Caas Robert yeoman 606659 606659 Caas, Robert, of Mellys, yeoman 2
5320041 2451083 2451083 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, yeoman 0
5329788 2453984 2453984 defendant Purs John clerk 606659 606659 Purs, John, of Mellys, clerk 0
5337261 2456216 2456216 defendant Jonys John yeoman 606659 606659 Jonys, John, of Mellys, yeoman 0
5349497 2459974 2459974 defendant Horner Robert clothier 606659 606659 Horner, Robert, of Mellys, clothier 0
5378051 2468713 2468713 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, yeoman 1
5423291 2481927 2481927 defendant Horner Robert clothier 606659 606659 Horner, Robert, of Mellys, clothier 2
5437896 2486268 2486268 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, yeoman 0
5437898 2486269 2486269 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, yeoman 0
5437900 2486270 2486270 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, yeoman 0
5452051 2490493 2490493 defendant Horner Robert   606659 606659 Horner, Robert, of Mellys 0
5487096 2501036 2501036 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, or of Dunhed, yeoman 0
5487098 2501037 2501037 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, or of Dunhed, yeoman 0
5501434 2505381 2505381 defendant Horner Robert yeoman 606659 606659 Horner, Robert, of Mellys, yeoman 0
5501435 2505381 2505381 defendant Amys John yeoman 606659 606659 Amys, John, of Mellys, yeoman 1
5556732 2521928 2521928 defendant Pynnock John   606659 606659 Pynnock, John, of Mellys, weaver, administrators of 0
5573240 2526726 2526726 defendant Sheperd John butcher 606659 606659 Sheperd, John, of Mellys, butcher 0
5588269 2531334 2531334 defendant Shepard John butcher 606659 606659 Shepard, John, of Mellys, butcher 0
5589386 2531679 2531679 defendant Tryppe John yeoman 606659 606659 Tryppe, John, of Mellys, yeoman 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);