names

51 rows where place_id = 597745

✎ 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
3629692 1904141 1904141 plaintiff Dawson Edmund mercer 597745 597745 Dawson, Edmund, of Kymbolton, mercer 0
3629694 1904141 1904141 defendant Stowghton William yeoman 597745 597745 Stowghton, William, of Kymbolton, yeoman 1
3771267 1948705 1948705 plaintiff Stoughton William   597745 597745 Stoughton, William, of Kymbolton 0
3794384 1956122 1956122 defendant Maye Geogre joiner 597745 597745 Maye, Geogre, of Kymbolton, joiner 1
3863621 1978020 1978020 defendant Stoughton Henry yeoman 597745 597745 Stoughton, Henry, of Kymbolton, yeoman 1
3863622 1978020 1978020 defendant Stoughton William yeoman 597745 597745 Stoughton, William, of Kymbolton, yeoman 2
3904690 1991826 1991826 defendant Stowghton Henry butcher 597745 597745 Stowghton, Henry, of Kymbolton, butcher 0
4115898 2065970 2065970 defendant Baseley Thomas tailor 597745 597745 Baseley, Thomas, of Kymbolton, tailor 1
4243085 2110678 2110678 defendant Beard Edmund (legal representative) 597745 597745 Beard, Edmund, of Kymbolton, yeman, administrator of 2
4243087 2110678 2110678 defendant Beard Robert (legal representative) 597745 597745 Beard, Robert, of Kymbolton, gent, administratrix of 4
4243088 2110678 2110678 defendant Beard Joan widow 597745 597745 Beard, Joan, of Kymbolton, widow 5
4253375 2114119 2114119 defendant Beard Edmund   597745 597745 Beard, Edmund, of Kymbolton, yeoman, dministrator of 2
4253377 2114119 2114119 defendant Beard Robert (legal representative) 597745 597745 Beard, Robert, of Kymbolton, gent, administratrix of 4
4253378 2114119 2114119 defendant Beard Joan widow 597745 597745 Beard, Joan, of Kymbolton, widow 5
4260555 2116497 2116497 defendant Bearde Edmund (legal representative) 597745 597745 Bearde, Edmund, of Kymbolton, yeoman, administrator of 0
4260556 2116497 2116497 defendant Bearde Thomas yeoman 597745 597745 Bearde, Thomas, of Kymbolton, yeoman 1
4298904 2129705 2129705 defendant Chambers Thomas yeoman 597745 597745 Chambers, Thomas, of Kymbolton, yeoman 0
4298905 2129705 2129705 defendant Carter Oliver yeoman 597745 597745 Carter, Oliver, of Kymbolton, yeoman 1
4298906 2129705 2129705 defendant Kendall George blacksmith 597745 597745 Kendall, George, of Kymbolton, blacksmith 2
4336018 2142333 2142333 defendant Phillippe Christopher yeoman 597745 597745 Phillippe, Christopher, of Kymbolton, yeoman 0
4350707 2147499 2147499 defendant Kendalle George blacksmith 597745 597745 Kendalle, George, of Kymbolton, blacksmith 1
4486219 2196396 2196396 plaintiff Ruer John   597745 597745 Ruer, John, of Kymbolton, on his own account 0
4522561 2207394 2207394 defendant Beres Henry   597745 597745 Beres, Henry, of Kymbolton 0
4523754 2207758 2207758 defendant Bateman William   597745 597745 Bateman, William, of Kymbolton 0
4601103 2231575 2231575 defendant Bray Richard   597745 597745 Bray, Richard, of Kymbolton 2
4674863 2257747 2257747 defendant Chaundeler John   597745 597745 Chaundeler, John, of Kymbolton, arrow maker 0
4674865 2257748 2257748 defendant Chaundeler John   597745 597745 Chaundeler, John, of Kymbolton, arrow maker 0
4925669 2334462 2334462 defendant Felyp Roger drover 597745 597745 Felyp, Roger, of Kymbolton, drover 1
4931411 2336203 2336203 defendant Key John yeoman 597745 597745 Key, John, of Kymbolton, yeoman 1
5114776 2390735 2390735 defendant Couper William husbandman 597745 597745 Couper, William, of Kymbolton, husbandman 0
5114777 2390735 2390735 defendant Pette Simon cordwainer 597745 597745 Pette, Simon, of Kymbolton, cordwainer 1
5144231 2399464 2399464 defendant Corbert John butcher 597745 597745 Corbert, John, of Kymbolton, butcher 2
5153786 2402267 2402267 defendant Fylyspende Roger butcher 597745 597745 Fylyspende, Roger, of Kymbolton, butcher 0
5178851 2409540 2409540 defendant Broun Thomas butcher 597745 597745 Broun, Thomas, of Kymbolton, butcher 1
5189323 2412609 2412609 defendant Fylyppe Roger butcher 597745 597745 Fylyppe, Roger, of Kymbolton, butcher 0
5202835 2416595 2416595 defendant Baret Thomas yeoman 597745 597745 Baret, Thomas, of Kymbolton, yeoman 2
5202836 2416595 2416595 defendant Fyssher John   597745 597745 Fyssher, John, of Kymbolton, glove maker 3
5242775 2428091 2428091 defendant Penne John courser 597745 597745 Penne, John, of Kymbolton, courser 0
5262642 2434062 2434062 defendant Corbet John butcher 597745 597745 Corbet, John, of Kymbolton, butcher 1
5366431 2465154 2465154 plaintiff Broun John   597745 597745 Broun, John, of Kymbolton, bailiff 0
5393542 2473212 2473212 defendant Draper Thomas tailor 597745 597745 Draper, Thomas, of Kymbolton, tailor 1
5396531 2474098 2474098 defendant Parys Wiliam yeoman 597745 597745 Parys, Wiliam, of Kymbolton, yeoman 0
5397692 2474409 2474409 defendant Broune Thomas, junior butcher 597745 597745 Broune, Thomas, junior, of Kymbolton, butcher 0
5409781 2477900 2477900 defendant Parys William yeoman 597745 597745 Parys, William, of Kymbolton, yeoman 0
5410862 2478200 2478200 defendant Broune Thomas, sen husbandman 597745 597745 Broune, Thomas, sen, of Kymbolton, husbandman 1
5410863 2478200 2478200 defendant Broune John butcher 597745 597745 Broune, John, of Kymbolton, butcher 2
5424964 2482432 2482432 defendant Broune John butcher 597745 597745 Broune, John, of Kymbolton, butcher 2
5424967 2482433 2482433 defendant Broune Thomas, sen husbandman 597745 597745 Broune, Thomas, sen, of Kymbolton, husbandman 1
5424968 2482433 2482433 defendant Broune John butcher 597745 597745 Broune, John, of Kymbolton, butcher 2
5491126 2502245 2502245 defendant Parker Thomas yeoman 597745 597745 Parker, Thomas, of Kymbolton, yeoman 0
5491127 2502245 2502245 defendant Stoughton William   597745 597745 Stoughton, William, of Kymbolton, tallow chandler 1

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