names

53 rows where place_id = 616681

✎ 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
3715595 1931163 1931163 defendant Milys Simon husbandman 616681 616681 Milys, Simon, of Brunsted, husbandman 0
3735328 1937284 1937284 defendant Dengeyn Henry gent 616681 616681 Dengeyn, Henry, of Brunsted, gent 1
3905809 1992223 1992223 defendant Auncell John butcher 616681 616681 Auncell, John, of Brunsted, butcher 0
4053005 2043505 2043505 defendant Kermye William clerk 616681 616681 Kermye, William, of Brunsted, clerk 10
4060723 2046239 2046239 defendant Powle Nicholas husbandman 616681 616681 Powle, Nicholas, of Brunsted, husbandman 0
4089535 2056544 2056544 defendant Keringe William clerk 616681 616681 Keringe, William, of Brunsted, clerk 2
4091987 2057430 2057430 defendant Johnson Richard husbandman 616681 616681 Johnson, Richard, of Brunsted, husbandman 0
4107964 2063121 2063121 defendant Jeryng William clerk 616681 616681 Jeryng, William, of Brunsted, clerk 2
4107969 2063122 2063122 defendant Keryng William clerk 616681 616681 Keryng, William, of Brunsted, clerk 2
4110167 2063898 2063898 defendant Kering William clerk 616681 616681 Kering, William, of Brunsted, clerk 2
4223784 2103804 2103804 defendant Riches John clerk 616681 616681 Riches, John, of Brunsted, clerk 0
4308776 2133219 2133219 defendant Stubben John yeoman 616681 616681 Stubben, John, of Brunsted, yeoman 2
4312757 2134593 2134593 defendant Gedney Edmund husbandman 616681 616681 Gedney, Edmund, of Brunsted, husbandman 2
4334079 2141679 2141679 defendant Stubben John yeoman 616681 616681 Stubben, John, of Brunsted, yeoman 2
4599378 2231022 2231022 defendant Proud Roger   616681 616681 Proud, Roger, of Brunsted 0
4658520 2248546 2248546 defendant Mabelot Bartholomew husbandman 616681 616681 Mabelot, Bartholomew, of Brunsted, husbandman 0
4818973 2302015 2302015 defendant Poule William husbandman 616681 616681 Poule, William, of Brunsted, husbandman 1
4882319 2321380 2321380 defendant Grene John yeoman 616681 616681 Grene, John, of Brunsted, yeoman 2
4932198 2336469 2336469 defendant Jefferey Richard   616681 616681 Jefferey, Richard, of Brunsted, servant 0
4932642 2336603 2336603 defendant Jeffrey Richard   616681 616681 Jeffrey, Richard, of Brunsted, servant 0
4935098 2337386 2337386 defendant Dengayne Thomas esq 616681 616681 Dengayne, Thomas, of Brunsted, esq 0
4941927 2339459 2339459 defendant Dengayn Thomas esq 616681 616681 Dengayn, Thomas, of Brunsted, esq 0
4977964 2350373 2350373 defendant Grene Alice widow 616681 616681 Grene, Alice, of Brunsted, widow 2
4992434 2354621 2354621 defendant Dengayne Thomas esq 616681 616681 Dengayne, Thomas, of Brunsted, esq 0
5007629 2359132 2359132 defendant Kyng Clement husbandman 616681 616681 Kyng, Clement, of Brunsted, husbandman 0
5024060 2363947 2363947 defendant Kyng Clement husbandman 616681 616681 Kyng, Clement, of Brunsted, husbandman 0
5024061 2363947 2363947 defendant Rust William husbandman 616681 616681 Rust, William, of Brunsted, husbandman 1
5036633 2367581 2367581 defendant Dengayn William gent 616681 616681 Dengayn, William, of Brunsted, gent 0
5089571 2383326 2383326 defendant Cower William yeoman 616681 616681 Cower, William, of Brunsted, yeoman 0
5089572 2383326 2383326 defendant Terwyn Henry husbandman 616681 616681 Terwyn, Henry, of Brunsted, husbandman 1
5089573 2383326 2383326 defendant Kyng Clement husbandman 616681 616681 Kyng, Clement, of Brunsted, husbandman 2
5089574 2383326 2383326 defendant Benet Thomas husbandman 616681 616681 Benet, Thomas, of Brunsted, husbandman 3
5089575 2383326 2383326 defendant Rust John husbandman 616681 616681 Rust, John, of Brunsted, husbandman 4
5089576 2383326 2383326 defendant Ryst William husbandman 616681 616681 Ryst, William, of Brunsted, husbandman 5
5116082 2391132 2391132 defendant Coweherd William yeoman 616681 616681 Coweherd, William, of Brunsted, yeoman 3
5133531 2396298 2396298 defendant Foulman Robert esq 616681 616681 Foulman, Robert, of Brunsted, esq 1
5133537 2396299 2396299 defendant Foulman Robert esq 616681 616681 Foulman, Robert, of Brunsted, esq 1
5135756 2396969 2396969 defendant Raulyns Thomas yeoman 616681 616681 Raulyns, Thomas, of Brunsted, yeoman 2
5153337 2402129 2402129 defendant Foulman Robert esq 616681 616681 Foulman, Robert, of Brunsted, esq 1
5153343 2402130 2402130 defendant Foulman Robert esq 616681 616681 Foulman, Robert, of Brunsted, esq 1
5170798 2407182 2407182 defendant Foulman Robert esq 616681 616681 Foulman, Robert, of Brunsted, esq 1
5170803 2407183 2407183 defendant Foulman Robert esq 616681 616681 Foulman, Robert, of Brunsted, esq 1
5172367 2407643 2407643 defendant Rawlyns Thomas yeoman 616681 616681 Rawlyns, Thomas, of Brunsted, yeoman 1
5206272 2417567 2417567 defendant Foulman Robert esq 616681 616681 Foulman, Robert, of Brunsted, esq 1
5212981 2419534 2419534 plaintiff Benet Thomas   616681 616681 Benet, Thomas, of Brunsted 0
5359404 2462977 2462977 plaintiff Raulyns Walter   616681 616681 Raulyns, Walter, of Brunsted 0
5368771 2465823 2465823 defendant Kyng Richard clerk 616681 616681 Kyng, Richard, of Brunsted, clerk 0
5485818 2500655 2500655 plaintiff Rawelyns Katherine   616681 616681 Rawelyns, Katherine, of Brunsted, administrators of 0
5485821 2500655 2500655 defendant Rawelyns William husbandman 616681 616681 Rawelyns, William, of Brunsted, husbandman 0
5485822 2500656 2500656 plaintiff Rawelyns Katherine   616681 616681 Rawelyns, Katherine, of Brunsted, administrators of 0
5485825 2500656 2500656 defendant Rawlyns William husbandman 616681 616681 Rawlyns, William, of Brunsted, husbandman 0
5498973 2504628 2504628 defendant Bakke Roland yeoman 616681 616681 Bakke, Roland, of Brunsted, yeoman 0
5584636 2530265 2530265 defendant Garrard Thomas husbandman 616681 616681 Garrard, Thomas, of Brunsted, 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);