names

75 rows where place_id = 586570

✎ 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
3589064 1864227 1864227 defendant Howes alias Whyllewryte Rovert husbandman 586570 586570 Howes alias Whyllewryte, Rovert, of Weveton, husbandman 1
3594211 1865831 1865831 defendant Rodeham Edward merchant 586570 586570 Rodeham, Edward, of Weveton, merchant 0
3603816 1868864 1868864 defendant Steell James yeoman 586570 586570 Steell, James, of Weveton, yeoman 0
3606954 1869838 1869838 defendant Dokkyng John yeoman 586570 586570 Dokkyng, John, of Weveton, yeoman 0
3606955 1869838 1869838 defendant Pronge John yeoman 586570 586570 Pronge, John, of Weveton, yeoman 1
3692655 1923892 1923892 plaintiff Kyngis John   586570 586570 Kyngis, John, of Weveton 0
3692666 1923896 1923896 plaintiff Kyngys John   586570 586570 Kyngys, John, of Weveton 0
3736997 1937818 1937818 plaintiff Kyngys John yeoman 586570 586570 Kyngys, John, of Weveton, yeoman 0
3762516 1945921 1945921 plaintiff Godys Roger chaplain 586570 586570 Godys, Roger, of Weveton, chaplain 0
3765295 1946810 1946810 plaintiff Kyng John merchant 586570 586570 Kyng, John, of Weveton, merchant 0
3799897 1957885 1957885 plaintiff Kyngys John merchant 586570 586570 Kyngys, John, of Weveton, merchant 0
3819607 1964010 1964010 plaintiff Orwell Thomas merchant 586570 586570 Orwell, Thomas, of Weveton, merchant 0
3855540 1975375 1975375 plaintiff Watt John   586570 586570 Watt, John, of Weveton 0
3874906 1981832 1981832 plaintiff Dey John   586570 586570 Dey, John, of Weveton 0
4064599 2047621 2047621 plaintiff Gynne Hugh yeoman 586570 586570 Gynne, Hugh, of Weveton, yeoman 0
4068707 2049095 2049095 plaintiff Kyrrie George yeoman 586570 586570 Kyrrie, George, of Weveton, yeoman 0
4141971 2075360 2075360 defendant Braye Francis widow 586570 586570 Braye, Francis, of Weveton, widow 1
4185383 2090399 2090399 defendant Braye Francis widow 586570 586570 Braye, Francis, of Weveton, widow 1
4695737 2264149 2264149 defendant Broun John yeoman 586570 586570 Broun, John, of Weveton, yeoman 0
4725177 2273170 2273170 defendant Derham Simon   586570 586570 Derham, Simon, of Weveton 0
4729588 2274470 2274470 plaintiff Lererpooll Thomas (legal representative) 586570 586570 Lererpooll, Thomas, of Weveton, executors of 0
4749648 2280383 2280383 defendant atte Brigge Katherine widow 586570 586570 atte Brigge, Katherine, of Weveton, widow 1
4769226 2286354 2286354 defendant Souter Richard mariner 586570 586570 Souter, Richard, of Weveton, mariner 0
4769227 2286354 2286354 defendant Leyk John yeoman 586570 586570 Leyk, John, of Weveton, yeoman 1
4809465 2299135 2299135 defendant Pparker John husbandman 586570 586570 Pparker, John, of Weveton, husbandman 3
4834485 2306793 2306793 defendant Letherpoll Katherine widow 586570 586570 Letherpoll, Katherine, of Weveton, widow 0
4839100 2308160 2308160 plaintiff Hacon John   586570 586570 Hacon, John, of Weveton 0
4858422 2314007 2314007 plaintiff Broun John merchant 586570 586570 Broun, John, of Weveton, or of Blakenee, merchant 0
4870968 2317895 2317895 defendant Parker John chapman 586570 586570 Parker, John, of Weveton, chapman 0
4876178 2319508 2319508 defendant Bryd Reginald clerk 586570 586570 Bryd, Reginald, of Weveton, clerk 0
4919207 2332519 2332519 defendant Hervy William carpenter 586570 586570 Hervy, William, of Weveton, carpenter 0
4936073 2337679 2337679 defendant Dalle Alan butcher 586570 586570 Dalle, Alan, of Weveton, butcher 0
4936075 2337679 2337679 defendant Dalle Thomas butcher 586570 586570 Dalle, Thomas, of Weveton, butcher 2
4972483 2348702 2348702 defendant Martyn Reginald yeoman 586570 586570 Martyn, Reginald, of Weveton, yeoman 2
4987439 2353199 2353199 defendant Hacon Simon yeoman 586570 586570 Hacon, Simon, of Weveton, yeoman 0
5023977 2363923 2363923 defendant Dalle John husbandman 586570 586570 Dalle, John, of Weveton, husbandman 0
5023978 2363923 2363923 defendant Dalle Alan husbandman 586570 586570 Dalle, Alan, of Weveton, husbandman 1
5029181 2365412 2365412 defendant Howes William husbandman 586570 586570 Howes, William, of Weveton, husbandman 6
5047817 2370963 2370963 defendant Bertram John gent 586570 586570 Bertram, John, of Weveton, gent 0
5055355 2373187 2373187 defendant Hacon Simon merchant 586570 586570 Hacon, Simon, of Weveton, merchant 0
5057945 2373950 2373950 defendant atte Hough John husbandman 586570 586570 atte Hough, John, of Weveton, husbandman 0
5086264 2382375 2382375 plaintiff Hawkyn Simon   586570 586570 Hawkyn, Simon, of Weveton 0
5090436 2383581 2383581 defendant Dalle John merchant 586570 586570 Dalle, John, of Weveton, merchant 0
5143509 2399235 2399235 plaintiff Andrewe Thomas   586570 586570 Andrewe, Thomas, of Weveton 0
5157297 2403274 2403274 defendant Dall John yeoman 586570 586570 Dall, John, of Weveton, yeoman 0
5173269 2407895 2407895 defendant Dall John yeoman 586570 586570 Dall, John, of Weveton, yeoman 0
5201251 2416121 2416121 plaintiff Andrew Thomas   586570 586570 Andrew, Thomas, of Weveton 1
5231914 2424907 2424907 defendant Andrewes James yeoman 586570 586570 Andrewes, James, of Weveton, yeoman 0
5239142 2427037 2427037 defendant Dalle John merchant 586570 586570 Dalle, John, of Weveton, merchant 0
5245420 2428813 2428813 defendant Dalle John merchant 586570 586570 Dalle, John, of Weveton, merchant 0
5268482 2435901 2435901 defendant Brygge John gent 586570 586570 Brygge, John, of Weveton, gent 0
5268483 2435901 2435901 defendant Steell John merchant 586570 586570 Steell, John, of Weveton, merchant 1
5274236 2437543 2437543 defendant Andrewes William yeoman 586570 586570 Andrewes, William, of Weveton, yeoman 1
5274240 2437544 2437544 defendant Andrewes William yeoman 586570 586570 Andrewes, William, of Weveton, yeoman 1
5279749 2439160 2439160 plaintiff Brown William (legal representative) 586570 586570 Brown, William, of Weveton, executors of 0
5279752 2439160 2439160 defendant Steell Robert yeoman 586570 586570 Steell, Robert, of Weveton, yeoman 0
5290020 2442086 2442086 defendant Dalle John (legal representative) 586570 586570 Dalle, John, of Weveton, husbandman, executors of 3
5290022 2442086 2442086 defendant Dalle Thomas husbandman 586570 586570 Dalle, Thomas, of Weveton, husbandman 5
5315714 2449764 2449764 defendant Andrewe John merchant 586570 586570 Andrewe, John, of Weveton, merchant 0
5335458 2455675 2455675 defendant Andrewes John yeoman 586570 586570 Andrewes, John, of Weveton, yeoman 0
5347825 2459471 2459471 defendant Andrewes John yeoman 586570 586570 Andrewes, John, of Weveton, yeoman 3
5347831 2459472 2459472 defendant Andrewes John yeoman 586570 586570 Andrewes, John, of Weveton, yeoman 3
5348243 2459596 2459596 defendant Brygge John gent 586570 586570 Brygge, John, of Weveton, gent 3
5352387 2460846 2460846 defendant Russh Richard yeoman 586570 586570 Russh, Richard, of Weveton, yeoman 0
5371608 2466706 2466706 defendant Brygge John gent 586570 586570 Brygge, John, of Weveton, gent 0
5409969 2477952 2477952 defendant Andrews John merchant 586570 586570 Andrews, John, of Weveton, merchant 0
5453836 2491038 2491038 defendant Andrewys John yeoman 586570 586570 Andrewys, John, of Weveton, yeoman 2
5476661 2498015 2498015 defendant Brygge John gent 586570 586570 Brygge, John, of Weveton, gent 0
5480581 2499165 2499165 defendant Andrewes John yeoman 586570 586570 Andrewes, John, of Weveton, yeoman 7
5480589 2499166 2499166 defendant Andrewes John yeoman 586570 586570 Andrewes, John, of Weveton, yeoman 2
5502204 2505615 2505615 defendant Qwarles William merchant 586570 586570 Qwarles, William, of Weveton, merchant 0
5502205 2505615 2505615 defendant Lawes Edmund merchant 586570 586570 Lawes, Edmund, of Weveton, merchant 1
5597882 2534238 2534238 plaintiff Grenewey John   586570 586570 (Grenewey, John, of Weveton 1
5604336 2536220 2536220 defendant Wilson Roland painter 586570 586570 Wilson, Roland, of Weveton, painter 0
5636392 2555340 2555340 defendant Sopere William laborer 586570 586570 Sopere, William, of Weveton, laborer 3

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