names

71 rows where place_id = 630157

✎ 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
3703431 1927347 1927347 defendant Morten Thomas (legal representative) 630157 630157 Morten, Thomas, of Oundell, Nhants, chapman, executors of 1
3792791 1955596 1955596 defendant Clerk homas yeoman 630157 630157 Clerk, homas, of Oundell, Nhants, yeoman 0
3815274 1962693 1962693 defendant Prestgrave Richard chapman 630157 630157 Prestgrave, Richard, of Oundell, Nhants, chapman 0
3868449 1979686 1979686 defendant Rushton John butcher 630157 630157 Rushton, John, of Oundell, Nhants, butcher 3
3889795 1986826 1986826 defendant Coke Richard gent 630157 630157 Coke, Richard, of Oundell, Nhants, gent 0
3891242 1987336 1987336 defendant Mylner Henry butcher 630157 630157 Mylner, Henry, of Oundell, Nhants, butcher 0
3916553 1995912 1995912 defendant Coke Richard gent 630157 630157 Coke, Richard, of Oundell, Nhants, gent 0
3922704 1997906 1997906 defendant Cooke Richard gent 630157 630157 Cooke, Richard, of Oundell, Nhants, gent 0
3929446 2000193 2000193 defendant Loftes William chandler 630157 630157 Loftes, William, of Oundell, Nhants, chandler 0
3933787 2001595 2001595 defendant Abell Edmund chapman 630157 630157 Abell, Edmund, of Oundell, Nhants, chapman 0
3943844 2004958 2004958 plaintiff Everell William   630157 630157 (Everell, William, of Oundell, Nhants, tallow chandler, son of William 1
3975749 2016079 2016079 defendant Dey Thomas husbandman 630157 630157 Dey, Thomas, of Oundell, Nhants, husbandman 1
3990386 2021315 2021315 defendant Ive John yeoman 630157 630157 Ive, John, of Oundell, Nhants, yeoman 0
4072861 2050589 2050589 defendant Abell Thomas chapman 630157 630157 Abell, Thomas, of Oundell, Nhants, chapman 1
4270826 2119817 2119817 defendant Pundell Robert chapman 630157 630157 Pundell, Robert, of Oundell, Nhants, chapman 0
4341766 2144394 2144394 defendant Warriner Thomas yeoman 630157 630157 Warriner, Thomas, of Oundell, Nhants, yeoman 0
4393341 2162375 2162375 defendant Mehewe John shoemaker 630157 630157 Mehewe, John, of Oundell, Nhants, shoemaker 0
4397798 2163840 2163840 defendant Abell John mercer 630157 630157 Abell, John, of Oundell, Nhants, mercer 0
4399154 2164301 2164301 defendant Denys Henry vintner 630157 630157 Denys, Henry, of Oundell, Nhants, vintner 0
4482594 2195258 2195258 defendant Fenel John butcher 630157 630157 Fenel, John, of Oundell, Nhants, butcher 0
4672442 2257033 2257033 defendant Draper William chapman 630157 630157 Draper, William, of Oundell, Nhants, chapman 2
4672814 2257138 2257138 defendant Draper William chapman 630157 630157 Draper, William, of Oundell, Nhants, chapman 2
4676768 2258356 2258356 defendant Catour Walter butcher 630157 630157 Catour, Walter, of Oundell, Nhants, butcher 0
4702023 2266044 2266044 defendant Barbour John   630157 630157 Barbour, John, of Oundell, Nhants, leach 1
4718668 2271177 2271177 defendant Abbot Simon chapman 630157 630157 Abbot, Simon, of Oundell, Nhants, chapman 4
4729218 2274358 2274358 defendant Lone or Love William dyer 630157 630157 Lone or Love, William, of Oundell, Nhants, dyer 0
4762648 2284298 2284298 defendant Sponere William   630157 630157 Sponere, William, of Oundell, Nhants, glove maker 0
4803427 2297260 2297260 defendant Draper Henry   630157 630157 Draper, Henry, of Oundell, Nhants, husbandman, who died intestate 2
4806296 2298178 2298178 defendant Knyght Richard chapman 630157 630157 Knyght, Richard, of Oundell, Nhants, chapman 1
4845713 2310170 2310170 defendant Gremston Henry   630157 630157 Gremston, Henry, of Oundell, Nhants, spice seller 1
4861738 2315043 2315043 defendant Knyght Richard merchant 630157 630157 Knyght, Richard, of Oundell, Nhants, merchant 1
4861741 2315044 2315044 defendant Knyght Richard husbandman 630157 630157 Knyght, Richard, of Oundell, Nhants, husbandman 1
4879275 2320454 2320454 defendant Dunwell Richard yeoman 630157 630157 Dunwell, Richard, of Oundell, Nhants, yeoman 0
4897507 2325879 2325879 defendant Knyght Richard merchant 630157 630157 Knyght, Richard, of Oundell, Nhants, merchant 1
4910346 2329752 2329752 defendant Knytht Richard chapman 630157 630157 Knytht, Richard, of Oundell, Nhants, chapman 1
4914493 2331054 2331054 defendant Knyght Richard merchant 630157 630157 Knyght, Richard, of Oundell, Nhants, merchant 0
4926144 2334603 2334603 defendant Lyrketon alan   630157 630157 Lyrketon, alan, of Oundell, Nhants, parson 0
4929402 2335614 2335614 defendant Geboun John butcher 630157 630157 Geboun, John, of Oundell, Nhants, butcher 0
4929407 2335615 2335615 defendant Geboun John butcher 630157 630157 Geboun, John, of Oundell, Nhants, butcher 0
4930262 2335867 2335867 defendant Knyght Richard merchant 630157 630157 Knyght, Richard, of Oundell, Nhants, merchant 1
4935513 2337505 2337505 defendant Kyrkeston Alan clerk 630157 630157 Kyrkeston, Alan, of Oundell, Nhants, clerk 0
4955718 2343674 2343674 defendant Doget William gent 630157 630157 Doget, William, of Oundell, Nhants, gent 3
4982146 2351577 2351577 defendant Doket William gent 630157 630157 Doket, William, of Oundell, Nhants, gent 5
4984107 2352179 2352179 defendant Lytster Henry chapman 630157 630157 Lytster, Henry, of Oundell, Nhants, chapman 0
4984503 2352300 2352300 defendant Wyse John yeoman 630157 630157 Wyse, John, of Oundell, Nhants, yeoman 1
4984508 2352301 2352301 defendant Wyse John yeoman 630157 630157 Wyse, John, of Oundell, Nhants, yeoman 1
5004790 2358300 2358300 defendant Blechowe John husbandman 630157 630157 Blechowe, John, of Oundell, Nhants, husbandman 4
5019160 2362493 2362493 defendant Milner alias White Richard chandler 630157 630157 Milner alias White, Richard, of Oundell, Nhants, chandler 0
5019163 2362494 2362494 defendant Mylner or Whyte Richard chandler 630157 630157 Mylner or Whyte, Richard, of Oundell, Nhants, chandler 0
5022795 2363580 2363580 defendant Grymston Henry dyer 630157 630157 (Grymston, Henry, of Oundell, Nhants, dyer 2
5022800 2363581 2363581 defendant Grymston Henry dyer 630157 630157 (Grymston, Henry, of Oundell, Nhants, dyer 2
5037166 2367736 2367736 defendant Lytster Henry chapman 630157 630157 Lytster, Henry, of Oundell, Nhants, chapman 0
5053464 2372639 2372639 defendant Taylour Thomas tailor 630157 630157 Taylour, Thomas, of Oundell, Nhants, tailor 3
5076317 2379419 2379419 defendant Lene or Leve Richard husbandman 630157 630157 Lene or Leve, Richard, of Oundell, Nhants, husbandman 0
5221745 2422056 2422056 defendant Gosseryche William gent 630157 630157 Gosseryche, William, of Oundell, Nhants, gent 2
5234510 2425681 2425681 defendant Hepper Thomas laborer 630157 630157 Hepper, Thomas, of Oundell, Nhants, laborer 0
5254912 2431649 2431649 defendant Shepperd Thomas drover 630157 630157 Shepperd, Thomas, of Oundell, Nhants, drover 0
5265611 2434998 2434998 defendant Roger John yeoman 630157 630157 Roger, John, of Oundell, Nhants, yeoman 2
5265616 2434999 2434999 defendant Roger John yeoman 630157 630157 Roger, John, of Oundell, Nhants, yeoman 0
5291231 2442439 2442439 defendant Tomson John mercer 630157 630157 Tomson, John, of Oundell, Nhants, mercer 0
5303783 2446128 2446128 defendant Loweson William chapman 630157 630157 Loweson, William, of Oundell, Nhants, chapman 0
5336578 2456004 2456004 defendant Clapthorn John yeoman 630157 630157 Clapthorn, John, of Oundell, Nhants, yeoman 0
5347443 2459363 2459363 defendant Boleyn Thomas chapman 630157 630157 Boleyn, Thomas, of Oundell, Nhants, chapman 1
5435401 2485529 2485529 defendant Rawelyn Richard chapman 630157 630157 Rawelyn, Richard, of Oundell, Nhants, chapman 1
5441989 2487523 2487523 defendant Raulyne Richard draper 630157 630157 Raulyne, Richard, of Oundell, Nhants, draper 0
5450461 2490025 2490025 defendant Rawelyn Richard chapman 630157 630157 Rawelyn, Richard, of Oundell, Nhants, chapman 1
5454747 2491343 2491343 defendant Raulyns Richard draper 630157 630157 Raulyns, Richard, of Oundell, Nhants, draper 0
5466605 2494953 2494953 defendant Raulyns Richard draper 630157 630157 Raulyns, Richard, of Oundell, Nhants, draper 0
5504104 2506201 2506201 defendant Hall William chapman 630157 630157 Hall, William, of Oundell, Nhants, chapman 0
5535830 2515711 2515711 defendant Rawelyns Richard yeoman 630157 630157 Rawelyns, Richard, of Oundell, Nhants, yeoman 0
5536938 2516040 2516040 defendant Rawelyns Richard yeoman 630157 630157 Rawelyns, Richard, of Oundell, Nhants, yeoman 4

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