names

42 rows where place_id = 622170

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3745607 1940532 1940532 defendant Rows John fuller 622170 622170 Rows, John, of Walderne, fuller 1
4057312 2044999 2044999 defendant Fuller John husbandman 622170 622170 Fuller, John, of Walderne, husbandman 1
4189952 2091988 2091988 defendant Sherwood John husbandman 622170 622170 Sherwood, John, of Walderne, husbandman 1
4493069 2198531 2198531 defendant Willard William   622170 622170 Willard, William, of Walderne 0
4495831 2199378 2199378 defendant Pouke John turner 622170 622170 Pouke, John, of Walderne, turner 3
4502455 2201349 2201349 defendant atte Frythe John   622170 622170 atte Frythe, John, of Walderne 0
4531799 2210207 2210207 defendant Boyschede Richard   622170 622170 Boyschede, Richard, of Walderne 1
4543578 2213883 2213883 defendant atte Forde Lawrence   622170 622170 atte Forde, Lawrence, of Walderne 0
4547637 2215200 2215200 defendant Taillour Thomas   622170 622170 Taillour, Thomas, of Walderne 1
4593651 2229288 2229288 defendant Belsaunt John   622170 622170 Belsaunt, John, of Walderne 4
4725663 2273313 2273313 defendant Crotyndenne Thomas husbandman 622170 622170 Crotyndenne, Thomas, of Walderne, husbandman 0
4831465 2305872 2305872 defendant Rypon John weaver [ much obscured ] 622170 622170 Rypon, John, of Walderne, weaver [ much obscured ] 1
4874906 2319095 2319095 defendant Rypon John clerk 622170 622170 Rypon, John, of Walderne, holy water, clerk 1
4881082 2320994 2320994 plaintiff Willard Margery (legal representative) 622170 622170 Willard, Margery, of Walderne, widow of Willard, Nicholas, executors of 0
4894453 2324940 2324940 defendant atte Gate Walter husbandman 622170 622170 atte Gate, Walter, of Walderne, husbandman 2
4953404 2342983 2342983 defendant Holbeme John husbandman 622170 622170 Holbeme, John, of Walderne, husbandman 1
5191791 2413335 2413335 defendant Staunton John draper 622170 622170 Staunton, John, of Walderne, draper 0
5272621 2437068 2437068 defendant Staunton Richard draper 622170 622170 Staunton, Richard, of Walderne, draper 0
5317674 2450373 2450373 defendant Tomkyn John husbandman 622170 622170 Tomkyn, John, of Walderne, husbandman 0
5334166 2455287 2455287 plaintiff Eggyngworth or Heggyngworth Richard   622170 622170 Eggyngworth or Heggyngworth, Richard, of Walderne 0
5364740 2464635 2464635 plaintiff Atwode Helen   622170 622170 Atwode, Helen, of Walderne 0
5364741 2464635 2464635 plaintiff Walsshe Robert   622170 622170 Walsshe, Robert, of Walderne 1
5383717 2470428 2470428 plaintiff atte Wode Helen   622170 622170 atte Wode, Helen, of Walderne 0
5383718 2470428 2470428 plaintiff Welsshe Robert   622170 622170 Welsshe, Robert, of Walderne 1
5395519 2473800 2473800 plaintiff atte Wode Helen   622170 622170 atte Wode, Helen, of Walderne 0
5395520 2473800 2473800 plaintiff Welshe Robert   622170 622170 Welshe, Robert, of Walderne 1
5395523 2473801 2473801 plaintiff atte Wode Helen   622170 622170 atte Wode, Helen, of Walderne 0
5395524 2473801 2473801 plaintiff Welshe Robert   622170 622170 Welshe, Robert, of Walderne 1
5395527 2473802 2473802 plaintiff atte Wode Helen   622170 622170 atte Wode, Helen, of Walderne 0
5395528 2473802 2473802 plaintiff Welshe Robert   622170 622170 Welshe, Robert, of Walderne 1
5408811 2477597 2477597 plaintiff atte Wode Thomas (legal representative) 622170 622170 atte Wode, Thomas, of Walderne, executrix of 0
5422121 2481560 2481560 plaintiff at Wode Thomas (legal representative) 622170 622170 at Wode, Thomas, of Walderne, executrix of 0
5422122 2481560 2481560 plaintiff atte Wode Helen   622170 622170 atte Wode, Helen, of Walderne 1
5422146 2481570 2481570 plaintiff atte Wode Helen   622170 622170 atte Wode, Helen, of Walderne 0
5422147 2481570 2481570 plaintiff Walshe Robert   622170 622170 Walshe, Robert, of Walderne 1
5422150 2481571 2481571 plaintiff atte Wode Helen   622170 622170 atte Wode, Helen, of Walderne 0
5422151 2481571 2481571 plaintiff Walshe Robert   622170 622170 Walshe, Robert, of Walderne 1
5422154 2481572 2481572 plaintiff atte Wode Thomas (legal representative) 622170 622170 atte Wode, Thomas, of Walderne, executrix of 0
5422157 2481573 2481573 plaintiff atte Wode Thomas (legal representative) 622170 622170 atte Wode, Thomas, of Walderne, executrix of 0
5441793 2487472 2487472 plaintiff att Wode Helen   622170 622170 att Wode, Helen, of Walderne 0
5441794 2487472 2487472 plaintiff Walsshe Robert   622170 622170 Walsshe, Robert, of Walderne 1
5526390 2512830 2512830 defendant Erle William husbandman 622170 622170 Erle, William, of Walderne, husbandman 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);