names

74 rows where place_id = 755602

✎ 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
4429598 2174049 2174049 plaintiff Warde John   755602 755602 Warde, John, of Wadyngton 0
4438267 2181264 2181264 defendant Erby John de   755602 755602 Erby, John de, of Wadyngton, parson 2
4443806 2183037 2183037 defendant Renyngton Thomas de   755602 755602 Renyngton, Thomas de, of Wadyngton 1
4447531 2184142 2184142 defendant Betenson John   755602 755602 Betenson, John, of Wadyngton 0
4505752 2202308 2202308 defendant Mason John   755602 755602 Mason, John, of Wadyngton 3
4511028 2203899 2203899 defendant Kirkeby John   755602 755602 Kirkeby, John, of Wadyngton 0
4511034 2203900 2203900 defendant Kirkeby John   755602 755602 Kirkeby, John, of Wadyngton 0
4513564 2204665 2204665 defendant Kirkeby John   755602 755602 Kirkeby, John, of Wadyngton 0
4530559 2209856 2209856 plaintiff Orby John   755602 755602 Orby, John, of Wadyngton, parson 0
4534924 2211202 2211202 defendant Kirkby John   755602 755602 Kirkby, John, of Wadyngton 1
4540577 2212953 2212953 defendant Batheby John   755602 755602 Batheby, John, of Wadyngton 2
4541464 2213226 2213226 defendant Botheby John   755602 755602 Botheby, John, of Wadyngton 1
4557569 2218301 2218301 plaintiff Langford John   755602 755602 Langford, John, of Wadyngton 0
4557570 2218301 2218301 defendant Normanton William de   755602 755602 Normanton, William de, of Wadyngton 0
4562790 2219921 2219921 defendant Wadyngton Thomas   755602 755602 Wadyngton, Thomas, of Wadyngton 0
4584421 2226542 2226542 defendant West Robert   755602 755602 West, Robert, of Wadyngton 0
4588361 2227751 2227751 defendant Kirkeby John   755602 755602 Kirkeby, John, of Wadyngton 0
4588363 2227751 2227751 defendant Wright Thomas   755602 755602 Wright, Thomas, of Wadyngton 2
4605916 2232964 2232964 defendant Godewyn Alice daughter of John 755602 755602 Godewyn, Alice, of Wadyngton, daughter of John 0
4648299 2245564 2245564 defendant Makeaunter Richard   755602 755602 Makeaunter, Richard, of Wadyngton 0
4648300 2245564 2245564 defendant Lauforde John   755602 755602 Lauforde, John, of Wadyngton 1
4648301 2245564 2245564 defendant Lully John   755602 755602 Lully, John, of Wadyngton 2
4648302 2245564 2245564 defendant Botheby Robert   755602 755602 Botheby, Robert, of Wadyngton 3
4659420 2248806 2248806 defendant Welyngham John husbandman 755602 755602 Welyngham, John, of Wadyngton, husbandman 2
4669398 2256137 2256137 defendant Landford John husbandman 755602 755602 Landford, John, of Wadyngton, husbandman 2
4669400 2256137 2256137 defendant Blyton William husbandman 755602 755602 Blyton, William, of Wadyngton, husbandman 4
4669614 2256207 2256207 defendant Landford John husbandman 755602 755602 Landford, John, of Wadyngton, husbandman 2
4669616 2256207 2256207 defendant Blyton Willim husbandman 755602 755602 Blyton, Willim, of Wadyngton, husbandman 4
4680119 2259392 2259392 defendant Wryght Thomas husbandman 755602 755602 Wryght, Thomas, of Wadyngton, husbandman 0
4737549 2276856 2276856 defendant Makaunter Richard husbandman 755602 755602 Makaunter, Richard, of Wadyngton, husbandman 1
4795949 2294879 2294879 defendant Landeford John husbandman 755602 755602 Landeford, John, of Wadyngton, husbandman 0
4832551 2306207 2306207 defendant More William husbandman 755602 755602 More, William, of Wadyngton, husbandman 0
4838418 2307932 2307932 plaintiff Godewyn Agnes (legal representative) 755602 755602 Godewyn, Agnes, of Wadyngton, formerly wife of John Godewyn, husbandman, executor of 0
4838419 2307932 2307932 plaintiff Wilson William   755602 755602 Wilson, William, of Wadyngton 1
4838420 2307932 2307932 defendant Bentley William husbandman 755602 755602 Bentley, William, of Wadyngton, husbandman 0
4838421 2307932 2307932 defendant Tutte Richard husbandman 755602 755602 Tutte, Richard, of Wadyngton, husbandman 1
4838422 2307932 2307932 defendant Langford John husbandman 755602 755602 Langford, John, of Wadyngton, husbandman 2
4887770 2323007 2323007 defendant Boton William husbandman 755602 755602 Boton, William, of Wadyngton, husbandman 3
4891586 2324107 2324107 defendant Petytte Nicholas pardoner 755602 755602 Petytte, Nicholas, of Wadyngton, pardoner 0
4912836 2330507 2330507 defendant Pynkard John yeoman 755602 755602 Pynkard, John, of Wadyngton, yeoman 0
4960020 2344962 2344962 defendant Pyncare John yeoman 755602 755602 Pyncare, John, of Wadyngton, yeoman 0
4961524 2345411 2345411 defendant Bradley John husbandman 755602 755602 Bradley, John, of Wadyngton, husbandman 1
4978664 2350567 2350567 defendant Pyncard John yeoman 755602 755602 Pyncard, John, of Wadyngton, yeoman 3
4981446 2351366 2351366 defendant Soure Thomas husbandman 755602 755602 Soure, Thomas, of Wadyngton, husbandman 4
4985413 2352560 2352560 defendant Wryght John husbandman 755602 755602 Wryght, John, of Wadyngton, husbandman 0
4997201 2356016 2356016 defendant Wryght John husbandman 755602 755602 Wryght, John, of Wadyngton, husbandman 0
5000816 2357114 2357114 defendant Bradley John husbandman 755602 755602 Bradley, John, of Wadyngton, husbandman 1
5000817 2357114 2357114 defendant Pyncard John yeoman 755602 755602 Pyncard, John, of Wadyngton, yeoman 2
5001728 2357400 2357400 plaintiff More William   755602 755602 More, William, of Wadyngton 0
5007976 2359223 2359223 defendant Soure Thomas husbandman 755602 755602 Soure, Thomas, of Wadyngton, husbandman 0
5045822 2370385 2370385 defendant Wryght William chaplain 755602 755602 Wryght, William, of Wadyngton, chaplain 1
5045823 2370385 2370385 defendant Parker John husbandman 755602 755602 Parker, John, of Wadyngton, husbandman 2
5054853 2373017 2373017 defendant Sore Thomas husbandman 755602 755602 Sore, Thomas, of Wadyngton, husbandman 3
5090999 2383764 2383764 plaintiff More William   755602 755602 More, William, of Wadyngton 0
5091001 2383765 2383765 plaintiff More William   755602 755602 More, William, of Wadyngton 0
5161544 2404475 2404475 defendant Broun Thomas thatcher 755602 755602 Broun, Thomas, of Wadyngton, thatcher 0
5197787 2415092 2415092 defendant Wadyngton Walter yeoman 755602 755602 Wadyngton, Walter, of Wadyngton, yeoman 4
5197788 2415092 2415092 defendant Wadyngton Edward yeoman 755602 755602 Wadyngton, Edward, of Wadyngton, yeoman 5
5197795 2415093 2415093 defendant Wadyng Walter yeoman 755602 755602 Wadyng, Walter, of Wadyngton, yeoman 4
5197796 2415093 2415093 defendant Wadyngton Edward yeoman 755602 755602 Wadyngton, Edward, of Wadyngton, yeoman 5
5233822 2425479 2425479 defendant Medryngham John gent 755602 755602 Medryngham, John, of Wadyngton, gent 0
5349044 2459830 2459830 defendant Perkyn Waren yeoman 755602 755602 Perkyn, Waren, of Wadyngton, yeoman 0
5434689 2485313 2485313 defendant Farand John clerk 755602 755602 Farand, John, of Wadyngton, clerk 0
5491981 2502510 2502510 defendant Salaman John husbandman 755602 755602 Salaman, John, of Wadyngton, husbandman 2
5492184 2502573 2502573 defendant Newecom Thomas husbandman 755602 755602 Newecom, Thomas, of Wadyngton, husbandman 0
5492185 2502573 2502573 defendant Newecom William husbandman 755602 755602 Newecom, William, of Wadyngton, husbandman 1
5492186 2502573 2502573 defendant Bradley John husbandman 755602 755602 Bradley, John, of Wadyngton, husbandman 2
5492187 2502573 2502573 defendant Cartewright Richard husbandman 755602 755602 Cartewright, Richard, of Wadyngton, husbandman 3
5516428 2509969 2509969 defendant Oseby William carpenter 755602 755602 Oseby, William, of Wadyngton, carpenter 0
5516429 2509969 2509969 defendant Wellyngore Thomas, senior   755602 755602 Wellyngore, Thomas, senior, of Wadyngton, wheel wright 1
5516432 2509970 2509970 defendant Wellyngore Thomas, senior   755602 755602 Wellyngore, Thomas, senior, of Wadyngton, wheelwright 1
5608179 2537460 2537460 defendant Freman Thomas husbandman 755602 755602 Freman, Thomas, of Wadyngton, husbandman 0
5614392 2548294 2548294 defendant Tasker William   755602 755602 Tasker, William, of Wadyngton 0
5614394 2548294 2548294 defendant Grippe John   755602 755602 Grippe, John, of Wadyngton 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);