names

62 rows where place_id = 597804

✎ 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
3629906 1904208 1904208 defendant Chamber John yeoman 597804 597804 Chamber, John, of West Wycombe, yeoman 0
3668782 1916173 1916173 defendant Ravenyng Robert husbandman 597804 597804 Ravenyng, Robert, of West Wycombe, husbandman 0
3668783 1916173 1916173 defendant Ravenyng John laborer 597804 597804 Ravenyng, John, of West Wycombe, laborer 1
3669007 1916237 1916237 defendant More William miller 597804 597804 More, William, of West Wycombe, miller 0
3686524 1921936 1921936 plaintiff Bromfeld Robert   597804 597804 Bromfeld, Robert, of West Wycombe 0
3693261 1924102 1924102 defendant Smyth Roger tanner 597804 597804 Smyth, Roger, of West Wycombe, tanner 2
3702809 1927150 1927150 defendant Hill John husbandman 597804 597804 Hill, John, of West Wycombe, husbandman 1
3709141 1929157 1929157 plaintiff Pisey or Pesey Christopher yeoman 597804 597804 Pisey or Pesey, Christopher, of West Wycombe, yeoman 0
3709143 1929157 1929157 defendant Hayle Thomas husbandman 597804 597804 Hayle, Thomas, of West Wycombe, husbandman 1
3719982 1932520 1932520 defendant Cobler John husbandman 597804 597804 Cobler, John, of West Wycombe, husbandman 0
3724029 1933799 1933799 plaintiff Pusey Christopher yeoman 597804 597804 Pusey, Christopher, of West Wycombe, yeoman 0
3728362 1935114 1935114 defendant Plumrigge Thomas, senior husbandman 597804 597804 Plumrigge, Thomas, senior, of West Wycombe, husbandman 0
3782497 1952271 1952271 defendant Mynchard William yeoman 597804 597804 Mynchard, William, of West Wycombe, yeoman 0
3788307 1954140 1954140 defendant Huchyn Edward laborer 597804 597804 Huchyn, Edward, of West Wycombe, laborer 2
3795688 1956524 1956524 defendant Hobroke Philip tanner 597804 597804 Hobroke, Philip, of West Wycombe, tanner 0
3795689 1956524 1956524 defendant Revenyng Geoffrey buthcer 597804 597804 Revenyng, Geoffrey, of West Wycombe, buthcer 1
3804604 1959380 1959380 defendant Clerk William   597804 597804 Clerk, William, of West Wycombe 0
3811378 1961453 1961453 defendant Ravenyng alias Carter Richard tanner 597804 597804 Ravenyng alias Carter, Richard, of West Wycombe, tanner 0
3831256 1967661 1967661 defendant Asshebroke Richard butcher 597804 597804 Asshebroke, Richard, of West Wycombe, butcher 0
3833106 1968278 1968278 plaintiff Kyng Robert (legal representative) 597804 597804 Kyng, Robert, of West Wycombe, executor of 0
3833108 1968278 1968278 defendant House William tanner 597804 597804 House, William, of West Wycombe, tanner 0
3846446 1972442 1972442 defendant Bromefeld Robert yeoman 597804 597804 Bromefeld, Robert, of West Wycombe, yeoman 0
3848259 1973023 1973023 defendant Dene William husbandman 597804 597804 Dene, William, of West Wycombe, husbandman 0
3862099 1977510 1977510 defendant Asshebroke Nicholas butcher 597804 597804 Asshebroke, Nicholas, of West Wycombe, butcher 0
3863459 1977972 1977972 defendant Henson Robert   597804 597804 Henson, Robert, of West Wycombe, mason 0
3883770 1984840 1984840 plaintiff White Thomas   597804 597804 White, Thomas, of West Wycombe 0
4187595 2091163 2091163 defendant Hawll or Hall Thomas husbandman 597804 597804 Hawll or Hall, Thomas, of West Wycombe, husbandman 0
4213297 2100164 2100164 defendant Saunders William husbandman 597804 597804 Saunders, William, of West Wycombe, husbandman 4
4304480 2131704 2131704 defendant Ravenynge alias Carter Thomas yeoman 597804 597804 Ravenynge alias Carter, Thomas, of West Wycombe, yeoman 0
4304481 2131704 2131704 defendant Hunte Hugh yeoman 597804 597804 Hunte, Hugh, of West Wycombe, yeoman 1
4304483 2131705 2131705 defendant Ravenynge alias Carter Thomas yeoman 597804 597804 Ravenynge alias Carter, Thomas, of West Wycombe, yeoman 0
4304484 2131705 2131705 defendant Hunte Hugh yeoman 597804 597804 Hunte, Hugh, of West Wycombe, yeoman 1
4304485 2131705 2131705 defendant Sherwood William yeoman 597804 597804 Sherwood, William, of West Wycombe, yeoman 2
4304487 2131706 2131706 defendant Ravenynge alias Carter Thomas yeoman 597804 597804 Ravenynge alias Carter, Thomas, of West Wycombe, yeoman 0
4331564 2140853 2140853 defendant Hunt Henry yeoman 597804 597804 Hunt, Henry, of West Wycombe, yeoman 1
4503943 2201793 2201793 defendant Hunte William   597804 597804 Hunte, William, of West Wycombe 0
4515679 2205325 2205325 plaintiff Clerk Hugh   597804 597804 Clerk, Hugh, of West Wycombe 0
4515682 2205325 2205325 defendant Bedewale John   597804 597804 Bedewale, John, of West Wycombe 2
4529571 2209530 2209530 defendant Smyth Adam   597804 597804 Smyth, Adam, of West Wycombe 0
4710319 2268583 2268583 defendant Yong William laborer 597804 597804 Yong, William, of West Wycombe, laborer 0
5070559 2377689 2377689 defendant West William husbandman 597804 597804 West, William, of West Wycombe, husbandman 3
5070560 2377689 2377689 defendant West Nicholas husbandman 597804 597804 West, Nicholas, of West Wycombe, husbandman 4
5070732 2377744 2377744 defendant Smyth William smith 597804 597804 Smyth, William, of West Wycombe, smith 0
5070733 2377744 2377744 defendant Carter Ralph husbandman 597804 597804 Carter, Ralph, of West Wycombe, husbandman 1
5214743 2420037 2420037 defendant Gelot John laborer 597804 597804 Gelot, John, of West Wycombe, laborer 1
5324273 2452351 2452351 defendant Dormer William husbandman 597804 597804 Dormer, William, of West Wycombe, husbandman 0
5324274 2452351 2452351 defendant Hayle John laborer 597804 597804 Hayle, John, of West Wycombe, laborer 1
5324275 2452351 2452351 defendant Carter John laborer 597804 597804 Carter, John, of West Wycombe, laborer 2
5333800 2455181 2455181 defendant Carter Ralph butcher 597804 597804 Carter, Ralph, of West Wycombe, butcher 0
5346012 2458889 2458889 defendant Carter David husbandman 597804 597804 Carter, David, of West Wycombe, husbandman 0
5357419 2462388 2462388 defendant Auste John smith 597804 597804 Auste, John, of West Wycombe, smith 3
5365529 2464892 2464892 defendant Dormer William husbandman 597804 597804 Dormer, William, of West Wycombe, husbandman 0
5380575 2469495 2469495 defendant Dormer William husbandman 597804 597804 Dormer, William, of West Wycombe, husbandman 0
5385271 2470862 2470862 defendant Junklyn John smith 597804 597804 Junklyn, John, of West Wycombe, smith 1
5453860 2491045 2491045 defendant Hunt William husbandman 597804 597804 Hunt, William, of West Wycombe, husbandman 0
5453864 2491046 2491046 defendant Hunt William   597804 597804 Hunt, William, of West Wycombe 0
5477247 2498204 2498204 defendant Hunt William husbandman 597804 597804 Hunt, William, of West Wycombe, husbandman 0
5488571 2501465 2501465 defendant Hunt William husbandman 597804 597804 Hunt, William, of West Wycombe, husbandman 2
5503844 2506117 2506117 defendant Oxlad Richard husbandman 597804 597804 Oxlad, Richard, of West Wycombe, husbandman 4
5529597 2513757 2513757 defendant Pusey Joan widow 597804 597804 Pusey, Joan, of West Wycombe, widow 0
5582358 2529558 2529558 plaintiff Dormer William   597804 597804 Dormer, William, of West Wycombe, merchant of the staple, executotrs of 0
5592074 2532513 2532513 defendant Carter Thomas, senior husbandman 597804 597804 Carter, Thomas, senior, of West Wycombe, husbandman 2

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