names

98 rows where place_id = 623950

✎ 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
3755278 1943605 1943605 defendant Calverly Richard husbandman 623950 623950 Calverly, Richard, of Laceby, husbandman 1
3816283 1963000 1963000 defendant Skerne Richard gent 623950 623950 Skerne, Richard, of Laceby, gent 0
3872233 1980940 1980940 defendant Skerne Edmund clerk 623950 623950 Skerne, Edmund, of Laceby, clerk 1
3882674 1984470 1984470 defendant Barnabe Thomas husbandman 623950 623950 Barnabe, Thomas, of Laceby, husbandman 0
4134302 2072596 2072596 defendant Bradley William clerk 623950 623950 Bradley, William, of Laceby, clerk 0
4158261 2080962 2080962 defendant Bradley William clerk 623950 623950 Bradley, William, of Laceby, clerk 0
4225008 2104216 2104216 defendant Skary Jane widow 623950 623950 Skary, Jane, of Laceby, widow 1
4236239 2108244 2108244 defendant Francys John yeoman 623950 623950 Francys, John, of Laceby, yeoman 2
4347421 2146353 2146353 defendant Clarke John   623950 623950 Clarke, John, of Laceby clerk 0
4481735 2194989 2194989 defendant Fetyll Robert   623950 623950 Fetyll, Robert, of Laceby 0
4572380 2222901 2222901 defendant Barker Robert   623950 623950 Barker, Robert, of Laceby 0
4583144 2226152 2226152 plaintiff Flynton Hugh de   623950 623950 Flynton, Hugh de, of Laceby, parson 0
4583145 2226152 2226152 defendant Grisby John   623950 623950 Grisby, John, of Laceby 0
4671313 2256677 2256677 defendant Flynton Hugh clerk 623950 623950 Flynton, Hugh, of Laceby, clerk 0
4721962 2272198 2272198 defendant Bosy William yeoman 623950 623950 Bosy, William, of Laceby, yeoman 0
4768900 2286253 2286253 defendant Talmer William yeoman 623950 623950 Talmer, William, of Laceby, yeoman 1
4843876 2309603 2309603 defendant Cosyn William husbandman 623950 623950 Cosyn, William, of Laceby, husbandman 0
4843877 2309603 2309603 defendant Harryson Richard husbandman 623950 623950 Harryson, Richard, of Laceby, husbandman 1
4853592 2312539 2312539 defendant Stokton William chaplain 623950 623950 Stokton, William, of Laceby, chaplain 0
4853598 2312541 2312541 defendant Stokton William chaplain 623950 623950 Stokton, William, of Laceby, chaplain 0
4860059 2314516 2314516 defendant Grysby John husbandman 623950 623950 Grysby, John, of Laceby, husbandman 0
4864474 2315862 2315862 defendant Selar Walter husbandman 623950 623950 Selar, Walter, of Laceby, husbandman 2
4878001 2320074 2320074 defendant of the Chapell Robert husbandman 623950 623950 of the Chapell, Robert, of Laceby, husbandman 1
4899013 2326334 2326334 defendant Rede Thomas thatcher 623950 623950 Rede, Thomas, of Laceby, thatcher 1
4899042 2326342 2326342 defendant Harryson Richard husbandman 623950 623950 Harryson, Richard, of Laceby, husbandman 0
4900657 2326845 2326845 defendant Girsby John husbandman 623950 623950 Girsby, John, of Laceby, husbandman 0
4910027 2329660 2329660 defendant Redehede Thomas thatcher 623950 623950 Redehede, Thomas, of Laceby, thatcher 1
4922977 2333605 2333605 defendant Redhede Thomas husbandman 623950 623950 Redhede, Thomas, of Laceby, husbandman 0
4925300 2334346 2334346 plaintiff Peerson William   623950 623950 Peerson, William, of Laceby 0
4940997 2339205 2339205 defendant Cartwright George husbandman 623950 623950 Cartwright, George, of Laceby, husbandman 6
4958211 2344424 2344424 plaintiff Wrawby Agnes   623950 623950 Wrawby, Agnes, of Laceby 0
4968313 2347484 2347484 defendant Theker William thatcher 623950 623950 Theker, William, of Laceby, thatcher 1
4990981 2354193 2354193 defendant Redhed Thomas husbandman 623950 623950 Redhed, Thomas, of Laceby, husbandman 1
5012448 2360491 2360491 defendant Theker William thatcher 623950 623950 Theker, William, of Laceby, thatcher 0
5031142 2365985 2365985 defendant Theker William thatcher 623950 623950 Theker, William, of Laceby, thatcher 0
5031143 2365985 2365985 defendant Hoggeson Hugh thatcher 623950 623950 Hoggeson, Hugh, of Laceby, thatcher 1
5054338 2372876 2372876 defendant Redehed Thomas thatcher 623950 623950 Redehed, Thomas, of Laceby, thatcher 2
5057601 2373841 2373841 defendant Burton John husbandman 623950 623950 Burton, John, of Laceby, husbandman 7
5057602 2373841 2373841 defendant Overay John hiusbandman 623950 623950 Overay, John, of Laceby, hiusbandman 8
5057651 2373853 2373853 defendant Burton John husbandman 623950 623950 Burton, John, of Laceby, husbandman 4
5057652 2373853 2373853 defendant Overay John husbandman 623950 623950 Overay, John, of Laceby, husbandman 5
5058319 2374033 2374033 defendant Gylle William husbandman 623950 623950 Gylle, William, of Laceby, husbandman 4
5062124 2375227 2375227 defendant Smyth Richard smith 623950 623950 Smyth, Richard, of Laceby, smith 2
5068973 2377216 2377216 defendant Overay John yeoman 623950 623950 Overay, John, of Laceby, yeoman 1
5070885 2377787 2377787 defendant Gille John husbandman 623950 623950 Gille, John, of Laceby, husbandman 0
5070934 2377799 2377799 defendant Cosyn Richard husbandman 623950 623950 Cosyn, Richard, of Laceby, husbandman 0
5070935 2377799 2377799 defendant Overay John husbandman 623950 623950 Overay, John, of Laceby, husbandman 1
5075817 2379260 2379260 defendant Gylle Robert husbandman 623950 623950 Gylle, Robert, of Laceby, husbandman 1
5075819 2379260 2379260 defendant Gille William husbandman 623950 623950 Gille, William, of Laceby, husbandman 3
5093860 2384605 2384605 defendant Herryson Richard husbandman 623950 623950 Herryson, Richard, of Laceby, husbandman 0
5098292 2385930 2385930 defendant Neve Robert husbandman 623950 623950 Neve, Robert, of Laceby, husbandman 0
5101194 2386758 2386758 defendant Croxton John husbandman 623950 623950 Croxton, John, of Laceby, husbandman 0
5101195 2386758 2386758 defendant Croxton William husbandman 623950 623950 Croxton, William, of Laceby, husbandman 1
5101196 2386758 2386758 defendant Robertson William husbandman 623950 623950 Robertson, William, of Laceby, husbandman 2
5101198 2386759 2386759 defendant Croxton John husbandman 623950 623950 Croxton, John, of Laceby, husbandman 0
5101199 2386759 2386759 defendant Croxton William husbandman 623950 623950 Croxton, William, of Laceby, husbandman 1
5101200 2386759 2386759 defendant Robertson William husbandman 623950 623950 Robertson, William, of Laceby, husbandman 2
5105907 2388169 2388169 defendant Barker Henry yeoman 623950 623950 Barker, Henry, of Laceby, yeoman 0
5105910 2388169 2388169 defendant Roberdson William husbandman 623950 623950 Roberdson, William, of Laceby, husbandman 3
5105912 2388170 2388170 defendant Barker Henry yeoman 623950 623950 Barker, Henry, of Laceby, yeoman 0
5105915 2388170 2388170 defendant Roberdson William husbandman 623950 623950 Roberdson, William, of Laceby, husbandman 3
5119695 2392196 2392196 defendant Mendhous John butcher 623950 623950 Mendhous, John, of Laceby, butcher 2
5119697 2392197 2392197 defendant Beteneste Thomas husbandman 623950 623950 Beteneste, Thomas, of Laceby, husbandman 0
5121214 2392633 2392633 defendant Cordewayner William husbandman 623950 623950 Cordewayner, William, of Laceby, husbandman 0
5121215 2392633 2392633 defendant Betenese Thomas husbandman 623950 623950 Betenese, Thomas, of Laceby, husbandman 1
5143675 2399284 2399284 defendant Covell Robert clerk 623950 623950 Covell, Robert, of Laceby, clerk 0
5148946 2400820 2400820 defendant Covell Robert clerk & rector 623950 623950 Covell, Robert, of Laceby, clerk & rector 0
5182503 2410638 2410638 plaintiff Cavell William   623950 623950 Cavell, William, of Laceby, parson 2
5184452 2411191 2411191 defendant Betnefe or Betnese Thomas husbandman 623950 623950 Betnefe or Betnese, Thomas, of Laceby, husbandman 0
5184455 2411192 2411192 defendant Betnese Thomas husbandman 623950 623950 Betnese, Thomas, of Laceby, husbandman 0
5246974 2429280 2429280 defendant Canell Robert clerk 623950 623950 Canell, Robert, of Laceby, clerk 0
5255500 2431841 2431841 defendant Barker Henry husbandman 623950 623950 Barker, Henry, of Laceby, husbandman 0
5255507 2431842 2431842 defendant Barker Henry husbandman 623950 623950 Barker, Henry, of Laceby, husbandman 5
5255515 2431843 2431843 defendant Barker Henry husbandman 623950 623950 Barker, Henry, of Laceby, husbandman 5
5260944 2433544 2433544 defendant Barker Henry husbandman 623950 623950 Barker, Henry, of Laceby, husbandman 5
5261058 2433571 2433571 defendant Barker Henry husbandman 623950 623950 Barker, Henry, of Laceby, husbandman 5
5277997 2438651 2438651 defendant Cawell Robert clerk 623950 623950 Cawell, Robert, of Laceby, clerk 0
5308775 2447664 2447664 defendant Pycard Christopher husbandman 623950 623950 Pycard, Christopher, of Laceby, husbandman 0
5310225 2448093 2448093 defendant Canell Robert clerk & rector 623950 623950 Canell, Robert, of Laceby, clerk & rector 0
5325804 2452800 2452800 defendant Betenese Thomas husbandman 623950 623950 Betenese, Thomas, of Laceby, husbandman 0
5339169 2456826 2456826 defendant Herryson John, junior husbandman 623950 623950 Herryson, John, junior, of Laceby, husbandman 4
5339190 2456831 2456831 defendant Cordewayne William husbandman 623950 623950 Cordewayne, William, of Laceby, husbandman 3
5348702 2459723 2459723 defendant Cordewayn William husbandman 623950 623950 Cordewayn, William, of Laceby, husbandman 2
5348718 2459727 2459727 defendant Cordewayner William husbandman 623950 623950 Cordewayner, William, of Laceby, husbandman 2
5348722 2459728 2459728 defendant Cordewayner William husbandman 623950 623950 Cordewayner, William, of Laceby, husbandman 2
5356605 2462136 2462136 defendant Harryson John, junior husbandman 623950 623950 Harryson, John, junior, of Laceby, husbandman 0
5360756 2463396 2463396 defendant Betenef Patrick husbandman 623950 623950 Betenef, Patrick, of Laceby, husbandman 0
5392221 2472863 2472863 defendant Turnay John yeoman 623950 623950 Turnay, John, of Laceby, yeoman 1
5405255 2476587 2476587 defendant Turney (illegible) yeoman 623950 623950 Turney, ----, of Laceby, yeoman 0
5418333 2480408 2480408 defendant Turney John yeoman 623950 623950 Turney, John, of Laceby, yeoman 0
5420330 2481006 2481006 defendant Turner John yeoman 623950 623950 Turner, John, of Laceby, yeoman 0
5436867 2485957 2485957 defendant Turner John yeoman 623950 623950 Turner, John, of Laceby, yeoman 0
5464928 2494424 2494424 defendant Turnor John yeoman 623950 623950 Turnor, John, of Laceby, yeoman 0
5466958 2495068 2495068 defendant Turney John, sen yeoman 623950 623950 Turney, John, sen, of Laceby, yeoman 0
5476450 2497959 2497959 defendant Turnor John yeoman 623950 623950 Turnor, John, of Laceby, yeoman 0
5509935 2507949 2507949 defendant Grantham Peter husbandman 623950 623950 Grantham, Peter, of Laceby, husbandman 1
5536709 2515967 2515967 defendant Leedys Thomas gent 623950 623950 Leedys, Thomas, of Laceby, gent 0
5550170 2520084 2520084 defendant Short Henry butcher 623950 623950 Short, Henry, of Laceby, butcher 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);